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 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 MoreDescription 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 MoreWhile 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 MoreWhat are Cross Validation Rules Cross Validation Rules are used to restrict the combination between the segments of a particular Chart of Accounts. As per our Example, we have the…
Read MoreDescription This article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report Manager…
Read More