Payment process request table in Oracle fusion

Hi friends, we are going to discuss about the Payment process request table in Oracle fusion. We will share all the important tables which do use in the payment process request in oracle fusion. Payment Process request is the process to make supplier payments. When we run this process , we need to enter many parameters and based on that it extract the supplier open and validated invoices for the payment. Then as per our requirement ,we can add or remove the supplier invoices in the payment batch for the final supplier payments. These payment process request steps and activities keep stores in the payment process request tables. Each payment process request table help to store the different part of payment process request informations in Oracle Fusion. Please find below the complete detail about Payment process request table in Oracle fusion.

Payment process request table in Oracle fusion

9 Important tables of Payment process request in Oracle Fusion

1.AP_INV_SELECTION_CRITERIA_ALL

2.AP_SELECTED_INVOICES_ALL

3.AP_UNSELECTED_INVOICES_ALL

4.IBY_DOCS_PAYABLE_ALL

5.IBY_PAYMENTS_ALL

6.AP_INVOICE_PAYMENTS_ALL

7.IBY_TRXN_DOCUMENTS

8.IBY_PAYMENT_INSTRUCTIONS_ALL

9.AP_CHECKS_ALL

Detail Information of Each Payment process request table in Oracle fusion

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.

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.

Payment process request table in Oracle fusion

Payment process request table in Oracle fusion