P2T Process Wrongly Updates "Update_date" Fileld with "Current" Date on Transaction Tables
(Doc ID 2779882.1)
Last updated on MAY 27, 2021
Applies to:
Oracle Transportation Management Cloud Service - Version 21.1 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
P2T process was updating UPDATE_DATE to current date for the below listed tables.
X_UN_LOC_CODE
CONTACT_POINT
NOTIFY_REQUEST
ADHOC_NOTIFY
REPORT_EMAIL
EXTERNAL_SYSTEM
PROCESS_CONTROL_REQUEST
DRIVER_CDL
CONTACT
DRIVER
I_MESSAGE
ORDER_RELEASE
SHIPMENT
EXTERNAL_SYSTEM_SERVICE
EXPECTED BEHAVIOR
-----------------------
UPDATE_DATE column should be same as production instance
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Do P2T refresh
2. check above transaction tables, "update_date" column
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 |