Description: The below process guide to create AP Distribution Query in AP XLA GL SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product_line, glcc.segment6 channel, glcc.segment7 project,…
Read MoreIntroduction This Post illustrates steps required to Oracle 12c accessible by clause in Oracle EBS R12. PACKAGE Helper authed Definer accessible BY(Good_Unit, BAD_UNIT IS PROCEDURE p; END Helper; PACKAGE body…
Read MoreIntroduction Invoice on Hold Report is used to review detailed information about invoices on hold. You can submit the Approval process before submitting this report to obtain the most up-to-date…
Read MoreIntroduction This post is about to create multiple indexes for the same column in Oracle EBS R12. Script to create multiple indexes for the same column. SQL>CREATE TABLE t3…
Read MoreIntroduction Oracle General Ledger Trial Balance report is used to satisfy legal, statutory, and internal management reporting requirements in Portugal. There are five separate reports with a standard layout; however,…
Read MoreIntroduction This Post illustrates the steps required to Create or Update HR location in oracle application. Script to Create or Update HR location in oracle apps SET DEFINE OFF; CREATE…
Read MoreIntroduction This Post illustrates the steps required to get Normalized Exp Amount from Property Manager Script to get Normalized Exp Amount from Property Manager CREATE OR REPLACE FUNCTION APPS.PN_NORM_EXP(p_payment_item_id number,…
Read More1. Description Oracle Inventory provides the features you need to summarize costs related to inventory and manufacturing activities for a given accounting period and distribute those costs to the general ledger…
Read MoreIntroduction This Post illustrates the steps required to AR Aging 4 Bucket with project details in fusion application Script to AR Aging 4 Bucket with project details in fusion WITH …
Read MoreIntroduction The report lists in detail any transactions that have been accounted for with error and all entries that could not be transferred to the general ledger interface. When a…
Read More