Query for Open Work Order
Introduction: 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 MoreQuery for Open sales Order
Introduction: 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 MoreProgram To Change the Item Cost Groups
Introduction 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 MoreAPI To Create Bank Account Details in Oracle EBS-R12
Introduction 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 MoreQuery for Lease Expired But Not Terminated
Introduction: 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 MoreEmail Validation using PL/SQL Function
Introduction 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 MoreApprove and Review iExpense Reports in oracle apps
Description 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 MoreiExpense report audit/review in oracle apps
Introduction: 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 MoreiExpense with Business and Personal expense validate and submit for approval
Description iExpense is an Oracle module used to report and seek reimbursement of expenses paid by employees. This powerful application empowers companies to capture data at various stages of expense reimbursement, a few of them…
Read MoreI Expense Related Issue Release R12
While employee Submitting expense reports, he will face the issues. Which means, expense report will get stuck up with the status as Pending with System Administrator Action Points: a. Check…
Read More