My Oracle Support Banner

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 FEBRUARY 04, 2019

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_NUMBER INSTANCE_CODE ATTRRIBUTE_NAME SOURCE_VALUE TARGET_VALUE
2684 LEG UNIT_OF_MEASURE LEG_PCT1 LEG_PCT1
2684 LEG UOM_CODE 999 999

MSC_UNITS_OF_MEASURE

REFRESH_NUMBER INSTANCE_CODE UNIT_OF_MEASURE UOM_CODE UOM_CLASS BASE_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_NUMBER INSTANCE_CODE ATTRRIBUTE_NAME SOURCE_VALUE TARGET_VALUE
2684 LEG UNIT_OF_MEASURE LEG_PCT1 PCT1
2684 LEG UOM_CODE 999 zzy

MSC_UNITS_OF_MEASURE

REFRESH_NUMBER INSTANCE_CODE UNIT_OF_MEASURE UOM_CODE UOM_CLASS BASE_UOM_FLAG
2684 LEG PCT1 zzy à1ê N

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.