My Oracle Support Banner

R12: AP: AP/PO Purge Initiation (Selection) Routine - APXPGSEL Is Taking More Than 19 Hour To Process 2 Years Of Data And Never Completes. (Doc ID 2445157.1)

Last updated on MAY 14, 2021

Applies to:

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

Symptoms

"AP/PO Purge Initiation (Selection) Routine" - APXPGSEL concurrent is taking more than 19 hours to process 2 years of data.

"Initiate Purge" process runs for 19+ hrs. processing 2 yrs. of data and never completed.

Unable to purge matched purchase orders and invoices.

SQL*Trace of the process shows the following as the most expensive SQLs 

 

STEPS TO REPRODUCE:

  1. Log into the Oracle Applications using either of the following responsibilities:
    • Oracle Puchasing (For example: Purchasing, Vision Operations (USA))
    • Oracle Payables, Archive Purge (For example: Oracle Payables, Archive Purge (Vision Operations))
  2. Enter the "submit Purge" screen.
    • If using the Oracle Purchasing responsibility Navigate to Management > Purge
    • If using the Oracle Payables responsibility, Navigate to Purge
  3. Once in the "Submit Purge" screen, enter the values accordingly and click on [Initiate]

    then you will get popup window with the Request ID of the concurrent submitted.


  4. If you go to view your requests, you will see the concurrent "AP/PO Purge Initiation (Selection) Routine" has been submitted.

    and if you go back to the "Submit Purge" screen and query the purge submitted, it will shows with status Initiating

 

 

Changes

Applied <Patch 17755325>

Applied <Patch 20714409>

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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