My Oracle Support Banner

R12: AP: AP Suppliers Table Last_updated_by Column Is Getting Updated With Terminated Oracle Users (Doc ID 2804592.1)

Last updated on SEPTEMBER 17, 2021

Applies to:

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

Symptoms

Users observed a few suppliers records in table AP_SUPPLIERS with last_update_date and last_updated_by values referring to application users who were deactivated/terminated much earlier.

The DBA team has confirmed that those oracle user ids have not logged into Oracle Applications production instance after their inactivation date.

The issue happens randomly.  It is not reproducible at will.

This is observed by customers internal audit team and requesting a justification on this unexpected behavior.

The following query was used by the DBA and it returned records:

 

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.