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:

Symptoms

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:

Changes

Cause

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