EAR 9.2: SYSAUDIT Pivot-11 & -12 Exceptions For C360 Pivot Grids After FSCM PI022 (Doc ID 2247304.1)

Last updated on JULY 05, 2017

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On 9.2 Image 22, SYSAUDIT Pivot 08, 11, 12 errors as per below:


ERROR
-----------------------
(Pivot-08) Query field headings in PSQRYFIELD do not match column name defined in PSPGMODEL table
(PIVOT-11) PSQuery bind variable heading in PSQRYBIND does not match prompt name defined in PSPGQRYPROMPT table for Pivot Grid.
(PIVOT-12) PSQuery bind variable prompt records in PSQRYBIND table do not match prompt record defined in PSPGQRYPROMPT table for Pivot Grid.

REPLICATION STEPS
---------------------
The issue can be reproduced at will with the following steps:

  1. Run sysaudit
  2. Verify the issue

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