Pivot-07 And Pivot-08 Errors After Applying PUM18
Last updated on DECEMBER 20, 2016
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Applied PUM18 to HCM 9.2 environment running PT8.54.18.
The errors are Pivot-07 and Pivot-08 errors.
Missing query field
HRS_PG_TTF HRS_PG_TTF_QRY Age in Days
HRS_PG_TTF_DB HRS_PG_TTF_DB_QRY Age in Days
HRS_PG_TTF_M HRS_PG_TTF_M_QRY Age in Days
(Pivot-08) Query field headings in PSQRYFIELD do not match column name
defined in PSPGMODEL table: Pivot Grid Name
When running the ADS Compare/Copy steps, we received the following validation error, and the items wouldn't copy:
Invalid Query Field Age in Days specified in the source for the Pivot Grid HRS_PG_TTF.
All the Pivot Grid Fields need to match the Query Fields for the Pivot Grid to render. This error should be corrected before a Copy is performed on the project.
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