My Oracle Support Banner

INCR_F_SHIPMENT_ORDER_RELEASE_COST and INIT_ORDER_RELEASE_COST Tables Failing to Populate Data When No Allocation Exists (Doc ID 1331058.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.2.0 to 6.2.2 [Release 6.2]
Information in this document applies to any platform.

Symptoms


The ODI Interface INCR_F_SHIPMENT_ORDER_RELEASE_COST and INIT_ORDER_RELEASE_COST is incorrect. The join between ALLOCATION and SHIPMENT must be outer join but listed as an inner join, in the following SQL:

If no data exists in the ALLOCATION, this will fail the inner join and not load the data.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.