Can The FND_USER Table Be Used For Auditing Purposes In Tracking The Password Changes (Doc ID 1642530.1)

Last updated on DECEMBER 13, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

A custom report developed based on audit-table FND_USER_A is created, but the report output is not providing the correct information.

The discrepancy is => USER_A can not have the right to change the password of USER_B, but USER_A information is seen in the output who changed the password of USER_B. Audit Functionality inserts the table FND_USER_A based on DML operations performed on table FND_USER, with the help of AUDIT database triggers.

Data changes are recorded in FND_USER_A table using Oracle-Application or direct insert/update/delete statement.

What are the other sources from which data can be modified affecting the FND_USER table?

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