Blog / Category
oracle payables
9 articles in this category
Supplier Master Details in Oracle Apps R12
Introduction: This blog provides a consolidated SQL query that can be used to generate a Supplier Master Details Report in Oracle Apps R12 (Payables). The repor…
Transmission Configuration For Payment Outbound Interface – Oracle Fusion
Transmission Configuration AP payments made in Oracle Could sends payment files to banks to make the real payment to vendors. In such cases, file transfer link…
PGP Key Encryption in AP Payment Outbound Interface
PGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable t…
Query to extract AP unpaid invoices details
Introduction: This will displays all the unpaid invoices details select hrou.name Operating_Unit, api.invoice_num Invoice_Number, decode(aid.MATCH_STATUS_FLAG,…
AP Paid invoices details
Introduction: The will displays all the Paid invoices details . Select “Operating Unit” ,”Invoice Number” ,”Invoice Date” ,”Supplier Number” ,”Supplier Name” ,”…
AP Invoice Payments API
Below is the package you can download for AP Invoice Payments. ap-invoice-payments-api
Create Bank and Bank Branch Using API
When performing Master Data Migration for Supplier or Customer business also needs the migration of Associated Banks and Bank Branches.In order to perform this…
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, …
AP Distribution Query: AP XLA GL
SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, &nb…