My Oracle Support Banner

R12: AP: Initiate Purge (AP/PO Purge Initiation (Selection) Routine) Has Been Running For Seven Days. (Doc ID 2104111.1)

Last updated on MARCH 10, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


Payables Purge responsibility > Choose "Purge" from menu.

a. Operating unit should default.
b. Enter a unique name.
c. Enter a category from the LOV.
d. Enter last Activity Date. Activity from that date or earlier will be purged.
e. Click Initiate button.
f. The Initiate Purge and Print Purge requests will be submitted.
g. Once program completes, a list of invoices and/or POs that are going to be purged will be in the Print output.

If everything looks good, query the merge in the form and then click the Confirm
button which submits a request that actually archives some basic info, then deletes the transactions.

Initiate Purge (AP/PO Purge Initiation (Selection) Routine)  -APXPGSEL- has been running for seven days.

The SQL statement that is taking long time is the following:






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.