EAP: Payables Open Liability error, Process 11603 ABENDED at Step APX1406.MAIN.Step02 (PeopleCode) -- RC = 24 (108,524), Cannot open query - APY1406_AP_OPEN_LIABILITY (235,3000) (Doc ID 1326130.1)

Last updated on JULY 24, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the Payables Open Liability Report (APY1406 job), the XML Publisher APX1406 process ends in No Success and an error occurs:

ERROR
Failed to create field instance for the field number 3, select number 1 (50,402)
Failed to read all query select definitions (50,389)

Cannot open query - APY1406_AP_OPEN_LIABILITY (235,3000)
PSXP_RPTDEFNMANAGER.Utility.OnExecute Name:CheckQryForTreePrompt PCPC:10640 Statement:229
Called from:PSXP_RPTDEFNMANAGER.DataSourceDefn.OnExecute Name:Get Statement:93
Called from:PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:GetDatasource Statement:497
Called from:PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:ProcessReport Statement:1002
Called from:APX1406.MAIN.GBL.default.1900-01-01.Step02.OnExecute Statement:33

Process 11603 ABENDED at Step APX1406.MAIN.Step02 (PeopleCode) -- RC = 24
(108,524)

STEPS
1. Navigate to Accounts Payable > Reports > Voucher Reconciliation > Payables Open Liability
2. Run APY1406 job.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms