Introduction: This Post illustrates the steps required to delete the employee records in Oracle EBS HRMS Module. Script: Step 1 –Create Table create table papf_16082018 (person_id number, employee_number varchar2(10)); Step…
Read MoreIntroduction: This Post illustrates the steps required to Fetch the Invoice lines not transferred to GL in Oracle . Sql Script: SELECT rct.trx_number invoice_number, rctl.line_number, msib.segment1, hp.party_name bill_to_customer, DECODE (rctt.TYPE,…
Read MoreIntroduction: This Post illustrates the steps required to On Hand Quantity with Available To Transact in Oracle EBS. Script to Fetch the On Hand Quantity with Available To Transact Step-1…
Read MoreIntroduction: This Post illustrates the steps required to fetch data from AR to GL in Oracle EBS 11i. Script SELECT je_header_id, line_number, trx_number, item_number, customer_number, customer_name, SOURCE, CATEGORY, batch_name,…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Open work orders in Oracle EBS. Query to Fetch the Open Work Orders SELECT DISTINCT a.job, a.item item, a.item_description, a.product_category,…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Open sales orders in Oracle EBS. Script to Fetch the Open sales Orders SELECT customer_number, customer_name, organization_code, sku, request_date, schedule_ship_date,…
Read MoreIntroduction This Post illustrate steps required to Change the Item Cost Groups in Oracle EBS. Script to Change the Item Cost Groups DECLARE p_item VARCHAR2; p_organization_id NUMBER; p_subinventory VARCHAR2; p_locater…
Read MoreIntroduction This Post illustrate steps required to import bank account details of the suppliers in Oracle EBS R12. Script to import Bank account details for suppliers. PROCEDURE create_banks_accounts (p_change_type VARCHAR2)…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Leases which are Expired but not terminated in Oracle EBS R12. Script to Leases Expired but not terminated SELECT GCC.segment4 SOL_ID…
Read MoreIntroduction This post describes the steps required for email validation using PL/SQL Function Script for Email Validation using Pl/Sql Function CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2) RETURN BOOLEAN IS lv_n_check_len NUMBER; lv_b_check_in_at BOOLEAN; lv_b_check_in_dot BOOLEAN; lv_v_extn VARCHAR2 (10); BEGIN lv_n_check_len := LENGTH (pi_email_id); pi_email_id := LOWER (pi_email_id);…
Read More