Payment Batch table in oracle r12

Hi Friends, we are going to discuss about the Payment Batch table in oracle r12. We will share the complete list of payment batch tables in oracle r12. In oracle r12, when we create the single payment from payment window, then we called that process 'Manual Payment' but when we do process the bunch of invoices and making hundred of payments in one process that is called payment batch. In single payment batch we do process the multiple payments. In oracle r12 , we do call the payment batch as an 'Payment Process Request'. We do submit the Payment Process request' when we need to create the payment batch to multiple payments. In Payment Batch or in Payment Process request , there are multiple tables involves and each table stores different part of Payment Batch or payment request information's in oracle r12. We will try to explain each of these payment batch tables. Please find below the more detail Payment Batch table in oracle r12.

Payment Batch table in oracle r12

8 Important Tables of Payment Batch in oracle r12

1.AP_INV_SELECTION_CRITERIA_ALL

2.AP_SELECTED_INVOICES_ALL

3.AP_UNSELECTED_INVOICES_ALL

4.AP_INVOICE_PAYMENTS_ALL

5.IBY_TRXN_DOCUMENTS

6.IBY_PAYMENT_INSTRUCTIONS_ALL

7.IBY_DOCS_PAYABLE_ALL

8.IBY_PAYMENTS_ALL

Detail Information about each Payment Batch Table in Oracle r12.

IBY_DOCS_PAYABLE_ALL & IBY_PAYMENTS_ALL & AP_INVOICE_PAYMENTS_ALL

These tables have Invoice details, Payment details, payer, payee information against PPR/ Payment Batch.

AP_INV_SELECTION_CRITERIA_ALL :- 

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.

AP_SELECTED_INVOICES_ALL :- 

This Table 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. 

AP_UNSELECTED_INVOICES_ALL :- 

This table 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.

Payment Batch table in oracle r12