ELM 9.1 - CURRENCY_FULLSYNC receiving Error SQLExec: Failed to find the matching SQL Statement for EO_CHECK_RECFLDNMN.
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.
In ELM 9.1 Subscription Contracts, CURRENCY_FULLSYNC message is receiving SQL Error message.
Error message: SQLExec: Failed to find the matching SQL Statement for EO_CHECK_RECFLDNMN.GBL 2 CURRENCY_CD_TABLE.GBL.CURRENCY_CD_TABLE.SaveEdit
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.
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