How to Create Responsibility API
Description: A responsibility is an important configuration which allows the user to navigate to the various menus and form functions within that responsibility. Oracle API is used to load responsibility…
Read MoreQuery to get transactions of inventory items with available onhand quantity
Introduction This post is about to get transactions of inventory items with available onhand quantity. Script to get transactions of inventory items with available onhand quantity. SELECT recs.doc_type, recs.item_number,…
Read MoreAccount Payables Remittance Advice.
Introduction This post is about AP Remittance Advice, a document that describes payments that are being made. The person or company that is causing the payment will include a remittance…
Read MoreSuppliers Report (XML)
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 MoreQuery 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 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 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