My Oracle Support Banner

Invoice Information Missing From Fusion Transportation Intelligence (FTI) (Doc ID 1316188.1)

Last updated on MARCH 05, 2019

Applies to:

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

Symptoms


Data is not being loaded in the HDOWNER.F_SHIPMENT_INVOICE_BILL_DETAIL and HDOWNER.F_SHIPMENT_INVOICE_BILL_LINE_D tables.
This appears to be an issue with the queries being used in the HDOWNER.AA_LOAD_HD pacakge (the P_LOAD_F_SHPMNT_INVOIC_BIL_DTL and P_LOAD_F_SHPMNT_INVC_BL_LN_DTL procedures).
Both have queries that do a partial outer join to the GLOGOWNER.USER_APPDATA table, but not a full outer join.
Because the invoices do not have users with records in this table no data is returned.


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.