E-UPG: 9.2 Upgrade Issue - AE_SYNCIDGEN Step Failed With ORA-00904: "SYNCID": Invalid Identifier (Doc ID 1664551.1)

Last updated on NOVEMBER 20, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

On : 8.53 version, Upgrade, initial pass

When attempting to run the AE_SYNCIDGEN Application Engine program,
an error similar to the following.

ERROR
-----------------------
SQL error. Function:  CreateSQL
 Error Position:  71
 Return:  904 - ORA-00904: "SYNCID": invalid identifier
 Statement:  select count(*) from ps_proj_catg_tbl where syncid= 0 or syncid < 0 or SYNCID IS NULL
 Original Statement:  Select Count(*) from %Table(PROJ_CATG_TBL) WHERE SYNCID= 0 or SYNCID < 0 or SYNCID IS NULL
Message Set Number: 0
Message Number: 0
Message Reason: SQL error. Function:  CreateSQL
 Error Position:  71
 Return:  904 - ORA-00904: "SYNCID": invalid identifier
 Statement:  select count(*) from ps_proj_catg_tbl where syncid= 0 or syncid < 0 or SYNCID IS NULL
 Original Statement:  Select Count(*) from %Table(PROJ_CATG_TBL) WHERE SYNCID= 0 or SYNCID < 0 or SYNCID IS NULL  (0,0)

SQL error in Exec. (2,280) FUNCLIB_MOBILE.FUNCLIB_01.FieldFormula  Name:SetSyncIDs  PCPC:551  Statement:10
Called from:FUNCLIB_MOBILE.FUNCLIB_01.FieldFormula  Name:InitSetSyncIDs  Statement:118
Called from:FUNCLIB_MOBILE.FUNCLIB_01.FieldFormula  Name:SetAllSyncIDsAllRecs  Statement:124
Called from:AE_SYNCIDGEN.MAIN.GBL.default.1900-01-01.SyncID.OnExecute  Statement:13
Message Set Number: 2
Message Number: 280
Message Reason: SQL error in Exec. (2,280)
Process 1769151 ABENDED at Step AE_SYNCIDGEN.MAIN.SyncID (PeopleCode) -- RC = 24 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 1769151 ABENDED at Step AE_SYNCIDGEN.MAIN.SyncID (PeopleCode) -- RC = 24 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Complete upgrade to after the alter with deletes
2. Attempt to run the AE_SYNCIDGEN Application Engine program

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