Invoice Information Missing From Fusion Transportation Intelligence (FTI)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms