Introduction This Post described Suppliers Report (XML) is used to review the supplier, supplier site, and supplier contact details. Query Fetching Vendor Details: SELECT p.vendor_id c_vendor_id, p.segment1 c_vendor_number, p.vendor_name c_vendor_name, DECODE (UPPER (:p_order_by_par),…
Read MoreBelow is a Sample Array Type Fast Formula : DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_ID IS 0 DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_TYPE IS ‘x’ DEFAULT_DATA_VALUE FOR PER_HIST_ASG_EFFECTIVE_START_DATE IS ‘1951/01/01 00:00:00’ (DATE) DEFAULT_DATA_VALUE FOR PER_HIST_ASG_EFFECTIVE_END_DATE IS…
Read MoreDescription: 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 Introduction This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF,…
Read MoreIntroduction 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 More