Sync Supplier To Retail Fails With FOTY0001 Error (Doc ID 1574852.1)

Last updated on JANUARY 20, 2016

Applies to:

Oracle Financial Operations Control Integration Pack for Oracle Retail Merchandise Operations Management and Oracle E-Business Suite Financials - Version 2.5 to 2.5 [Release 2.5]
Information in this document applies to any platform.

Symptoms

Testing synchronization of supplier from e-Business to Retail, AIA flow is failing.
SyncSupplierPartyListRetailProvABCSImpl is failing during call to SyncSupplierPartyListEBM_To_CreateSupplierPartyListRetailABM with following error

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

In oc4j soa log, the following error is seen:

   XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference value is empty for Reference Column Name "COMMON" and for  Table Name "PAYMENTTERM_ID"

Note:
Had to re-install AIA so since then it has been failing.

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