My Oracle Support Banner

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 later
Information 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


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