E-PUM: Running the Initial Filter Queries error: "Result: Change Assistant Failure: Invalid return sql" (Doc ID 2105052.1)

Last updated on APRIL 14, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Error during applying patches using Change Assistant 8.55 (no patch)

Step: Preparing for Application Changes
Running the Initial Filters

Errors similar to the following:

Filter0001_out.log shows the following information:

Filter Query Name: Filter0001
Filter Query ID: PT853_Patch06ADSCheck
Description: Filter Query used to verify whether Customer has previously applied the ADS Patch 06 Hotfix Project.
True If Value: 1
Query: select count(*) from PSPCMNAME where OBJECTID1 = 104 AND OBJECTVALUE1 = 'PTADSDEFN' AND OBJECTID2 = 107 AND OBJECTVALUE2 = 'AdsValidationBase' AND OBJECTID3 = 12 AND OBJECTVALUE3 = 'OnExecute' AND RECNAME = 'RECORD' and REFNAME = 'PTIA_DUAL'
Compare Value Type: Numeric
Compare operation: =
Result: Change Assistant Failure: Invalid return sql result:

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