Changing User Names Does Not Appear To Update All Application Tables Where The Username Is Stored (Doc ID 2167534.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Approvals Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

We are using the change username functionality to change user names, but we have noticed in a few tables where the user name is stored that Oracle is not propagating the change as expected.

AME_APPROVALS_HISTORY
AME_TEMP_OLD_APPROVER_LISTS


Why did these tables not update the name?
 

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