E-PUM: Running the Initial Filter Queries error: "Result: Change Assistant Failure: Invalid return sql"
Last updated on APRIL 26, 2018
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.
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms