R12: AP: Unable To Purge An Invoice, Concurrent "APXPGSEL: AP/PO Purge Initiation (Selection) Routine" Is Not Selecting The Invoice (Doc ID 2457653.1)

Last updated on MARCH 01, 2019

Applies to:

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

Symptoms

Unable To Purge A Particular Invoice.

Concurrent "APXPGSEL: AP/PO Purge Initiation (Selection) Routine" is not selecting the invoice.

Standard log file shows

+---------------------------------------------------------------------------+
Payables: Version : 12.1
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
APXPGSEL: AP/PO Purge Initiation (Selection) Routine
+---------------------------------------------------------------------------+
Current system time is 17-MAY-2018 10:53:10
+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_PURGE_NAME="SM Debug Prg"
P_ACTION="INITIATE"
P_PAYABLES_STATUS='Y'
P_PURCHASING_STATUS='Y'
P_INVENTORY_STATUS='Y'
P_ASSETS_STATUS='Y'
P_WIP_STATUS='N'
P_MRP_STATUS='Y'
P_PA_STATUS='N'
P_PA_YES="Yes"
P_CHV_STATUS='N'
P_EDI_STATUS='N'
------------

APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Enter Password:
MSG-00000: And so it begins ...
MSG-00001: (Before Report) After SRWINIT
MSG-00002: (Before Report) After Get_Company_Name
MSG-00003: (Before Report) After Get_NLS_Strings
MSG-00004: (Before Report) After Get_Base_Curr_Data
MSG-00001: (Get_Purge_Parameters)Starting Get_Purge_Parameters
MSG-00002: (Get_Purge_Parameters)End Get_Purge_Parameters
MSG-00008: (Before Report) After Check_No_Purge_In_Process
MSG-00009: (Before Report) After Seed_Purge_Tables
MSG-00020: After SRWEXIT

Report Builder: Release 10.1.2.3.0 - Production on Thu May 17 10:53:11 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
(Updating table financials_purges)Starting Set_purge_status
(Check_no_purge_in_process)Starting Check_no_purge_in_process
(Seed_purge_tables)Get Accounting Methods
(Get_Accounting_Method)Starting Get_Accounting_Method
(Get_Accounting_Method)End Get_Accounting_Method
(Seed_purge_tables)Starting Seed_purge_tables
(Seed_purge_tables)Simple Invoices
(Inserting into ap_purge_invoice_list)Starting Seed_invoices
P_Purge_Name:SM Debug Prg
P_Using_Accrual_Basis:Y
P_Using_Cash_Basis:N
g_activity_date:31-MAR-04
approx_rows: 0 pay_alone: Y
0 records in ap_purge_invoice list table

No Errors shown in the concurrent log file.

And the APList shows the following data of the Invoice at header level