Oracle Payment Technical Flow in Oracle application : All details about Payments table in Oracle Application

Oracle Payment Technical Flow in Oracle application : All details about Payments table in Oracle Application

 

All Information’s related to Oracle Payments in the Oracle Apps

 

This table Stores all the information about PPR /Payment batch which is submitted for the payment. Like which are the filters this batch will select the due invoice payments.

SELECT * FROM AP_INV_SELECTION_CRITERIA_ALL;

/AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a
payment batch. Your Oracle Payables application
inserts into this table after you initiate a payment batch.
There will be one row for each invoice that Payables selects for
payment in the current payment batch. When you build payments
in a payment batch, your Oracle Payables
application uses information in this table to create
rows in AP_SELECTED_INVOICE_CHECKS. */

SELECT * FROM AP_SELECTED_INVOICES_ALL
SELECT * FROM AP_SELECTED_INVOICE_CHECKS_ALL

In this table, system stores information’s about that invoices which are due for payment but not rejected by the payment batch due to some issues. We can also get the rejection details for the invoice too.

 
SELECT * FROM AP_UNSELECTED_INVOICES_ALL

 

--This table contains Invoice details, Payment details, payer, payee information against PPR/ Payment Batch
SELECT * FROM IBY_DOCS_PAYABLE_ALL;
SELECT * FROM IBY_PAYMENTS_ALL;
SELECT * FROM AP_INVOICE_PAYMENTS_ALL;

This table Stores Bank Account Information’s

SELECT * FROM CE_BANK_ACCOUNTS;

--Payment Documents to be used for Printed type Payments
SELECT * FROM CE_PAYMENT_DOCUMENTS;
SELECT * FROM AP_CHECK_FORMATS;

-- Payable Formats
SELECT * FROM IBY_FORMATS_B;

--Payable Profiles
SELECT * FROM IBY_SYS_PMT_PROFILES_B
SELECT * FROM IBY_EXTRACTS_TL;

-- Payment Methods
SELECT * FROM IBY_PAYMENT_METHODS_B;

-- XML documents associated with a transaction generated by FORMAT PAYMENT INSTRUCTION Program
SELECT * FROM IBY_TRXN_DOCUMENTS;

-- Stores PPR instructions
SELECT * FROM IBY_PAYMENT_INSTRUCTIONS_ALL

--Payables Payments Data
SELECT * FROM AP_CHECKS_ALL;