My Oracle Support Banner

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

Last updated on APRIL 26, 2018

Applies to:

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


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.


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"

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


To view full details, 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 a vibrant support community of peers and Oracle experts.