ETL Re-run Deletes All the Shipment Stops But Re-inserts the Stop That Has Been Updated in OTM Since the Last ETL Run
(Doc ID 2028157.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 6.3.2 to 6.4.1 [Release 6.3 to 6.4]
Information in this document applies to any platform.
When a change to a shipment stop is made on OTM (OLTP DB) after the shipment has been moved to FTI (HD DB), when ETL runs, it delete all the shipment stops but only re-inserts the stop with the latest change since the last ETL run (this can be seen in F_SHIPMENT_STOP_D table in FTI comparing to SHIPMENT_STOP table in OTM). This results in a shipment with only one stop rather than two.
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