ELM 9.X: JOBCODE_SYNC Message Receive Error Message "Error Finding Item" But Receive a Done Status. (Doc ID 1276701.1)

Last updated on AUGUST 15, 2017

Applies to:

PeopleSoft Enterprise ELS Enterprise Learning Management - Version 9 and later
Information in this document applies to any platform.
***Checked for relevance on 10-JUL-2014***

Symptoms

In ELM,  JOBCODE_SYNC message receive error message but also displays a "Done" status. In addition, data is not inserted into PS_LM_JOBCODE_TBL.


Steps to Replicate Issue:
 
1) Ensure JOBCODE_SYNC service operation/message is configured and Active on HRMS and ELM. **
2) Add a new row to an existing JOBCODE in HRMS that does not exist in ELM.
3) Save in HRMS, which triggers and publish the JOBCODE_SYNC message and subscribe in ELM.
3) In ELM  from Asynchronous Process monitor, review the JOBCODE_SYNC message and notice status is Done, but received an Error Message "Error Finding Item". ***

Error:

Error message: Error finding item {LM_JOBCODE_SYNC.LM_JOBCODE_TBL.ItemByKeys}


**Note: For configuration for JOBCODE_SYNC review configuration for JOBCODE_FULLSYNC in referenced <Document 1102567.1> EIP:JOBCODE_FULLSYNC setup from HRMS 9.0 to ELM 9.0/9.1.

***Note: See Attachment GSC_Replication_Steps_JOBCODE_SYNC_Done_Status_Incorrect.doc

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