F_SHIPMENT_ORD_REL_COST_D and F_SHIPMENT_ORDER_RELEASE_COST Tables Not Getting Populated (Doc ID 1922543.1)

Last updated on SEPTEMBER 03, 2014

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.0 and later
Information in this document applies to any platform.

Symptoms


 When attempting to run a report in FTI under 'Shipment order Release Dimensions' , no  data is being returned.

F_SHIPMENT_ORDER_RELEASE_COST table is populated when allocating by Order Release Header level. But Order Release cost table was not populating when  allocating by Order Release Line level.



 -- Expected Behavior
Currently FTI only supports allocation by Order release header level, expecting allocation by Order Release Line level as well.


 -- Steps
 The issue can be reproduced at will with the following steps.

1) Navigate to Transportation Intelligence > Adhoc Query
2) Select Analysis > Transportation Intelligence
3) From the menu, Navigate to Shipment Order Release Analysis > Shipment order Release Dimensions
4) Select FTI Order Release GID, FTI Shipment GID. Select Results.
5) No results are found
 

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