Fusion OTBI : "Product Management - Cross Reference Item Real Time"."GTIN Relationship"."GTIN" wrong data (Doc ID 1994501.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Supply Chain Management Common Components - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Fusion Product Management 11.1.9 OTBI - data missing from columns

Unexpected behavior
----------------------------------

Issue 1: The item has a regular cross reference "H-1000". The analysis shows this cross reference value in the GTIN column of the report. Column therefore shows a data value from the wrong field.



Steps
-----------------
 ‘Product Management - Cross Reference Item Real Time’columns have been selected for the analysis design .

example analysis:

SELECT
   0 s_0,
   "Product Management - Cross Reference Item Real Time"."- Main"."Item Class Name" s_1,
   "Product Management - Cross Reference Item Real Time"."GTIN Relationship"."GTIN Description" s_2,
   "Product Management - Cross Reference Item Real Time"."GTIN Relationship"."GTIN" s_3,
   "Product Management - Cross Reference Item Real Time"."GTIN Relationship"."Unit of Measure" s_4,
   "Product Management - Cross Reference Item Real Time"."Cross Reference Item"."Cross Referenced Items" s_5
FROM "Product Management - Cross Reference Item Real Time"
ORDER BY 1, 4 ASC NULLS LAST, 3 ASC NULLS LAST, 5 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

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