My Oracle Support Banner

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 and later   [Release: 6.1 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. 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.


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
  Cause
  Solution
  References

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.

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