You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Purge only Error Records for AutoInvoice Interface Table

in Receivables & Collections 1 comment

Summary:

Purge only Error Records for AutoInvoice Interface Table

Content (please ensure you mask any confidential information):

Hello Oracle Community,

I’m working with the Purge AutoInvoice Interface Data process in Oracle Fusion Receivables to manage records in the AutoInvoice Interface tables. From what I understand:
Leaving the "Status" parameter blank (or entering any value other than "Unprocessed") purges only previously processed records (status "P").
Setting the "Status" parameter to "Unprocessed" purges all unprocessed records, which includes records with a null status or a status of "E" (Error).
I have two questions:

Is there a way to selectively purge only Error records (status "E") without deleting all unprocessed records (e.g., those with a null status)? For example, can the "Status" parameter accept a value like "E" to target only Error records, or does this require a custom solution?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!