Currency Exchange Rates Sync Failing On "CURRENCYEXCHANGE_ID" Reference Value (Doc ID 1578399.1)

Last updated on JANUARY 20, 2016

Applies to:

Oracle Financial Operations Control Integration Pack for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials - Version 2.5 and later
Information in this document applies to any platform.

Symptoms

Executing sync of Currency Exchange Rates from PeopleSoft to RMS, SyncCurrencyExchangeListPeopleSoftReqABCSImpl is failing.
The following error is seen during call to label="XfromSyncCurrencyExchangeListPSFTABM_To_SyncCurrencyExchangeListEBM"

ERROR
-----------------------
XPath expression failed to execute. Error while processing xpath expression, the expression is "ora:processXSLT('SyncCurrencyExchangeListPSFTABM_To_SyncCurrencyExchangeListEBM.xsl',bpws:getVariableData('inputVariable','SyncCurrencyExchangeListPSFTABM'))", the reason is FOTY0001: type error. Please verify the xpath query.


In soa log, the following error is seen:

Root cause:
; SystemID: file:/disk01_sy/oracle/product/oas1013sys/bpel/domains/default/tmp/.bpel_SyncCurrencyExchangeListPeopleSoftReqABCSImpl_1.0_b46838098bdeea6bf6ad48d47d6caa16.tmp/SyncCurrencyExchangeListPSFTABM_To_SyncCurrencyExchangeListEBM_template.xsl; Line#: 72; Column#: 118
javax.xml.transform.TransformerException: file:/disk01_sy/oracle/product/oas1013sys/bpel/domains/default/tmp/.bpel_SyncCurrencyExchangeListPeopleSoftReqABCSImpl_1.0_b46838098bdeea6bf6ad48d47d6caa16.tmp/SyncCurrencyExchangeListPSFTABM_To_SyncCurrencyExchangeListEBM_template.xsl: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference value is empty for Reference Column Name "PSFT_01" and for Table Name "CURRENCYEXCHANGE_ID"
Please ensure Reference value is not-empty '


Note: SyncCurrencyExchangeListRetailProvABCSImpl is not executed

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