Welcome to Oracle ERP

1) Create Requisition: Requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc) neede...

Oracle Payments provides the IBY_FD_EXTRACT_EXT_PUB extensibility package to construct custom XML element structure that can be added to th...

DECLARE x_result_rec_type iby_fndcpt_common_pub.result_rec_type; v_error_reason VARCHAR2 (2000) := NULL; v_msg_data VARCHAR2 (1000) := ...

Month End reconciliation between GL and AP is highly recommended. If AP is interfaced to GL, verifying the balance between the two applicat...

SELECT asic.selected_check_id, asic.currency_code, asic.check_amount -- ibypsr.payment_amount, 'A' paystatus, 'APPAYMENT'...

ap_po_vendors_apis_pkg.insert_new_vendor (p_vendor_name => v_vendor.vendor_name, p_vendor_type_lookup_code => l_lookup_code, p_taxpay...

-- VENDOR, PO AND INVOICE DETAILS (2 WAY MATCH) SELECT DISTINCT a.org_id "ORG ID", e.segment1 "VENDOR NUM", e.vendo...

In order to load Supplier external bank, branches and bank accounts, one needs to use the Oracle Supplied Package IBY_EXT_BANKACCT_PUB. ...

- Banks and their Branches are now each stored as Parties (HZ_PARTIES) in their own right. They are linked together through Relationships(...

Login to XML Publisher Administrator, download below template and start customizing report. IBYDC_STD1.rtf file is the initial starting p...

1) Login to Payables Manager and Navigate to Payments > Entry > Payments Manager 2) Click on Payment Process Request Tab and then...

1) Login to Payables Manager and Navigate to Setup > Payment > Payment Administrator 2) Click on XML Publisher format Template and...