Introduction This Post illustrates the steps required to project Revenue Exception in Fusion Application. Script to PA – Project Revenue exception SELECT pcdl.prvdr_gl_period_name ei_latest_gl_period_name, gcc.segment1 r_company, peia.revenue_recognized_flag ei_revenue_distributed_flag, ppat.NAME ei_project_name, ppab.segment1…
Read MoreIntroduction Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source. Database…
Read MoreIntroduction This Post illustrates the steps required to Project Accounting Labor Revenue in fusion Application Script to Project Accounting Labor Revenue in fusion Application SELECT prd.org_id employee_cost_org_id, prd.gl_period_name gl_period, NVL…
Read MoreDescription: The eAM Asset Number Open Interface enables you to import Asset Numbers into eAM, using a batch process. Optionally import Asset Number attributes. You can create new Asset…
Read MoreDescription: The below post describe the steps to create AP Pre payments Query: AP XLA GL SELECT glcc.segment1 COMPANY, glcc.segment2 LOCATION, glcc.segment3 COST_CENTER, glcc.segment4 ACCOUNT, glcc.segment5 PRODUCT_LINE, glcc.segment6 CHANNEL,…
Read MoreIntroduction This Post illustrates the steps required to PA Invoice Detail in Fusion Application Script to PA Invoice Detail Query in Fusion Application SELECT PEI.expenditure_item_id ,PPA.segment1 project_number ,PPA.name project_name ,PPA.segment1||’-‘||pih.invoice_num…
Read MoreDescription: 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 More