E-CA: HCM 9.2 PUM 21 Application - STEP Checking For Invalid Views Fails (Doc ID 2275473.1)

Last updated on JUNE 20, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

While running HCM 9.2 PUM 21 application update, the Change Assistant Step "Checking for Invalid Views" fails with:

c:\app\psoft\<APP_HOME>\sqr\dddinvws.sqr: DDDINVWS - SQL Statement =

SQL Status = 947, SQL Error = ORA-00947: not enough values

Error on line 71:
  (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.
 

ERROR
-----------------------
ORA-00947


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applying HCM 9.2 PUM 21 application update job

2. Runing Change Assistant step: "Checking for Invalid Views"


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete PUM 21 application update

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