Purge or Delete the Payables Interface In Oracle Apps

Purge or Delete the Payables Interface In Oracle Apps

Payables Interface store's all the Processed and Rejected records in the Interface tables and we need to purge or delete these records timely basis. So for this , We have many ways to purge or delete the records from the Payables Interface tables and here below I will share this in details.

 

 

2 ways to Purge or Delete the Payables Interface In Oracle Apps

1. Using Database/Backend to Purge or Delete the records from Payables Interface In Oracle Apps

2.Oracle Aps standard Method using Standard Concurrent Program 'Payables Open Interface Purge'.

 

 

 

Using Database/Backend to Purge or Delete the records from Payables Interface

Use this below sql Query

 

Delete from AP_INVOICES_INTERFACE

 

Delete from AP_INVOICE_LINES_INTERFACE

 

 

Oracle Aps standard Method using Standard Concurrent Program 'Payables Open Interface Purge'

 

Step1:-  We need to run the Standard Program  'Payables Open Interface Purge' to purge the Payables Interface tables in Oracle apps.

 

 

Enter the Parameters as per your Requirements to Purge or Delete the records in the  Payables Interface

 

Purge or Delete the Payables Interface In Oracle Apps