Pivot-07 And Pivot-08 Errors After Applying PUM18 (Doc ID 2187441.1)

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.

Symptoms

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

Changes

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.

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