Cross Reference is not created when collecting data - Returned Cross Reference Target value is the same as the Source value. (Doc ID 1382821.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Fusion Global Order Promising - Version 11.1.7.0.0 to 11.1.9.2.0 [Release 1.0]
Oracle Fusion Distributed Order Orchestration - Version 11.1.7.0.0 to 11.1.9.2.0 [Release 1.0]
Oracle Fusion Planning Common - Version 11.1.7.0.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance - Release 9 Specific***

Symptoms

We have attempted to perform a collection with cross referencing to existing data using Collections Web Service - mscCollConfigurationPublicService/CollDataLoadService. The data is collected, but this is not cross referenced, the source and target value are identical, and is the same as source Value submitted in the Collection payload

Instructions described in the following notes have been executed:

NOTE: 1684214.1 - How to perform GOP Collection For Shipping Service Levels
NOTE: 1525902.1 - How to perform GOP Collection For Unit of Measure (UOM) Cross Referencing
NOTE: 1540895.1 - How to perform GOP Collection For Payment Terms Cross Referencing
NOTE: 1521533.1 - How to perform GOP Collection For Currency Cross Referencing
NOTE: 1525491.1 - How to perform GOP Collection For Return Reason Cross Referencing
NOTE: 1525543.1 - How to perform GOP Collection For Invoicing and Accounting Rules
NOTE: 1514670.1 - How to perform GOP Collection For Freight Terms Cross Referencing

Followng the instructions in NOTE: 1525902.1 - How to perform GOP Collection For Unit of Measure (UOM) Cross Referencing, we observe that the following data is populated in the collected and cross reference tables:

MSC_XREF_MAPPING

REFRESH_NUMBERINSTANCE_CODEATTRRIBUTE_NAMESOURCE_VALUETARGET_VALUE
2684 LEG UNIT_OF_MEASURE LEG_PCT1 LEG_PCT1
2684 LEG UOM_CODE 999 999

MSC_UNITS_OF_MEASURE

REFRESH_NUMBERINSTANCE_CODEUNIT_OF_MEASUREUOM_CODEUOM_CLASSBASE_UOM_FLAG
2684 LEG LEG_PCT1 999 à1ê N

We are expecting that the following data should be loaded into the collected and cross reference tables:

MSC_XREF_MAPPING

REFRESH_NUMBERINSTANCE_CODEATTRRIBUTE_NAMESOURCE_VALUETARGET_VALUE
2684 LEG UNIT_OF_MEASURE LEG_PCT1 PCT1
2684 LEG UOM_CODE 999 zzy

MSC_UNITS_OF_MEASURE

REFRESH_NUMBERINSTANCE_CODEUNIT_OF_MEASUREUOM_CODEUOM_CLASSBASE_UOM_FLAG
2684 LEG PCT1 zzy à1ê N

 

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