Invoice Information Missing From Fusion Transportation Intelligence (FTI)
(Doc ID 1316188.1)
Last updated on JULY 09, 2014
Applies to:Oracle Fusion Transportation Intelligence - Version: 6.1.2
Information in this document applies to any platform.
Data is not being loaded in the HDOWNER.F_SHIPMENT_INVOICE_BILL_DETAIL and HDOWNER.F_SHIPMENT_INVOICE_BILL_LINE_D tables. Appears to them 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.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|