Shipments Fail to Load Into FTI With Load Reject Errors Related to D_LANE and D_LOCATION Tables (Doc ID 2257805.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Transportation Intelligence Cloud Service - Version 6.4.1 to 6.4.2 [Release 6.4]
Oracle Fusion Transportation Intelligence - Version 6.4.1 to 6.4.3 [Release 6.4]
Information in this document applies to any platform.

Symptoms

After Running ETL Data Load process, few Shipments fail to Load into FTI database even though they are set in the SHIPMENT_READY_TO_LOAD status.

Checking the FTI Load Rejects following Errors related to D_LANE and D_LOCATION tables are observed

DI-15065: Join error (FK_FCTP_D_LANE) between the table F_CARRIER_TENDER_PERFORMANCE and the table D_LANE.
ODI-15065: Join error (FK_FSIBL_LANE_GID) between the table F_SHIPMENT_INVOICE_BILL_LINE_D and the table D_LANE.
ODI-15065: Join error (FK_FSIBL_LSP_CLIENT) between the table F_SHIPMENT_INVOICE_BILL_LINE_D and the table D_LOCATION.
ODI-15065: Join error (FK_FSR_D_LANE) between the table F_SHIPMENT_REFNUM and the table D_LANE.
ODI-15065: Join error (FK_FSR_D_LANE) between the table F_SHIPMENT_REFNUM and the table D_LANE.
ODI-15065: Join error (FK_FSR_D_LANE) between the table F_SHIPMENT_REFNUM and the table D_LANE.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms