Re: Audit Trial

Posted by ErmanArslansOracleBlog on Mar 24, 2017; 7:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Audit-Trial-tp2407p2417.html

Okay.
I checked the colums.
It seems GUEST is set for the AUDIT_USER_NAME
and "U" is for the transaction type, which is update in this case.
So , I guess this record is written after a password reset.

Read this as well, Can The FND_USER Table Be Used For Auditing Purposes In Tracking The Password Changes (Doc ID 1642530.1)

Audit trail in EBS, just copies the old data from the main table to the shadow table, so probably your fnd_user has records that include GUEST as the user name.
As I mentioned earlier, check "Forgot Password Function Shows GUEST As The Password Record Update Owner (Doc ID 1502551.1) ", but you may need to live with it...

Ref: 1642530.1
Updating or Deleting operations will pull the old data in main table and insert it into audit table.  Here the column value for AUDIT_USER_NAME COLUMN pulling the data is from the main table.  The Audit Trail in not being used in the intended way and so the custom report shows incorrect information.  Trying to track who changed the data (User Password) which is not audit trail functionality.  The Audit trail functionality is to simply copy the value that was in the table column before the latest change.