My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

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


 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




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

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