Open Interface Invoices

[EMANUEL]

Version R12/11i? = R12
Instance PROD/TEST/VIS? = PROD
Module? = AP
OS? = Y

HI,

The Open Interface Invoice Lines are not deleted automatically even after creating of Invoices

The Line status changes to PROCESSED after the AP Invoice is generated but it still remains in Open Interface Invoice Lines

The user has to always delete such lines from the form individually as they get accumulated now and then

Please suggest a way out to how to delete these lines as the ?Payables Open Interface Purge? concurrent is having a parameter of Source, Group and Purge all, but the parameter of ?Status? is not there

Rgds Emanuel

[oteixeira]

Hello Emanuel.

In the Purge All parameter enter No to purge only records that have been successfully imported.

Octavio

[tgs100]

1. When you run open interface import program itself, you can purge the interface lines (after successful import) by selecting Purge parameter as Yes.
2. The purge program will purge only the processed records (I have not tried in R12). If you have only few sources, you can purge by giving source as parameter.
3. If both options 1 and 2 did not work, then write SQL script to purge the data. Backup the data before purging. Tables affected are AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.

Cheers,
Saravanan