Query of 11i to R12 Table Changes
Description: In this page, going to cover minimum database object level changes done by Oracle in the upgrade like object obsolete, package level changes, API changes. Accounts Payable 11i R12…
Read MoreCall Oracle package in Oracle BI Publisher 10g
Call Oracle package in Oracle BI Publisher 10g Introduction This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF,…
Read MorePA – Project Revenue exception
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 MoreGenerate DDL source code using Oracle SQL
Introduction 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 MoreQuery for Project Accounting Labor Revenue in fusion Application
Introduction 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 MoreeAM-Asset Number Conversion
Description: 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 MoreAP Pre Payments Query: AP XLA GL
Description: 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 MorePA Invoice Detail in Fusion Application
Introduction 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 MoreAP Distribution Query: AP XLA GL
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 MoreOracle 12c accessible by clause
Introduction 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 More