ELM 9.1 - CURRENCY_FULLSYNC receiving Error SQLExec: Failed to find the matching SQL Statement for EO_CHECK_RECFLDNMN. (Doc ID 1099500.1)

Last updated on DECEMBER 10, 2015

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms


In ELM 9.1 Subscription Contracts, CURRENCY_FULLSYNC message is receiving SQL Error message.

Error:
----------
Error message: SQLExec: Failed to find the matching SQL Statement for EO_CHECK_RECFLDNMN.GBL 2 CURRENCY_CD_TABLE.GBL.CURRENCY_CD_TABLE.SaveEdit

Replication Steps:
----------
1)  Login into HRMS and configure Service Operation CURRENCY_FULLSYNC.
2)  Login into ELM 9.1 and configure Service Operation CURRENCY_FULLSYNC.
3)  Submit process to publish Message CURRENCY_FULLSYNC from HRMS and ensure Done Status in HRMS.
4)  In ELM 9.1, go to Peopletools-> Integration Broker->Asynchronous monitor
 on Subscription Contracts Details page, verify status of CURRENCY_FULLSYNC message.






 

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