When Editing a Location Address, the UPDATE_USER Column Is Not Updated In the Relevant Table. (Doc ID 567202.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04
Information in this document applies to any platform.

Goal

After using the UI to edit the address of a location, you look at the data in the table via SQL.

In the table LOCATION_ADDRESS table, the UPDATE_USER and UPDATE_DATE column are still null, but the date was changed in the INSERT_DATE column.

The expectation is to see the results of the last change to a table in the UPDATE_USER and UPDATE_DATE columns.

Solution

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