Introduction: 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 MoreDescription For both the manager approval and expense report audit/review, any credit card transactions designated as personal expenses will be listed as a separate negative line item on the expense…
Read MoreIntroduction: This post detailed about the Steps required for i-expense Report audit/review in oracle application. Responsibility: – Internet Expenses Audit Manager Ø Log into Oracle and go to Internet Expenses Audit…
Read More