E-SEC : EOP_PUBLISHT AE For USER_PROFILE Message Full Data Publish Is Going To "No Success" Status (Doc ID 1916514.1)

Last updated on AUGUST 28, 2014

Applies to:

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

Symptoms

User is running an application engine program "EOP_PUBLISHT" from navigation, 
Enterprise Components >> Integration Definitions >> Initiate Processes >> Full Data Publish. But the AE process goes to "No Success" status.  Error message is as shown:

Full Data Publish Start (18022,7)

Publishing Rule OIM_USER_PROFILE for Message USER_PROFILE (18022,62)

SQL error. Function: CreateSQL
Error Position: 143
Return: 936 - ORA-00936: missing expression
Statement: select a.operpswd, a.wrkpassword, a.operpswdsalt, a.operpswdconf, a.newpassword, a.change_pwd_btn, a.ok_button from ps_derived_pswd a order by
Original Statement: Select A.OPERPSWD, A.WRKPASSWORD, A.OPERPSWDSALT, A.OPERPSWDCONF, A.NEWPASSWORD, A.CHANGE_PWD_BTN, A.OK_BUTTON from %Table(:1) A order by

SQL error in Exec. (2,280) EOL_PUBLISH.PUBLISH2.GBL.default.1900-01-01.Step10.OnExecute PCPC:18223 Statement:228

Process 1687 ABENDED at Step EOL_PUBLISH.PUBLISH2.Step10 (PeopleCode) -- RC = 8 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 15.28.17 2014-06-23

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