Rod Database Not Loading Daily Data
(Doc ID 1145194.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.1.0 to 6.1.3 [Release 6.1]Information in this document applies to any platform.
Symptoms
Find the ROD data base is not loading daily data from OTM Database (OLTP).
EXPECTED BEHAVIOR
-----------------------
Expect that the ROD data base would be loading daily data from OTM Database (OLTP) for viewing.
STEPS
-----------------------
1. Scheduled the frequency of the ETL job
2. Run the script to add the status Type of HD_LOAD_STATUS to the Shipment, Order Base & Order Release tables in the Oracle Transportation Management OLTP database.
3. Updates the Status Value to “READY_TO_LOAD” for the Shipments, Order Base & Order Releases.
4. Run exec aa_load_hd.p_load_all to launch the ETL process.
5. Load Historical Database using ROD
6. Log into the ROD Database the following day to verify that Shipments were loaded, Order Base and Order Releases were loaded.
Changes
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 |
Changes |
Cause |
Solution |
References |