Oracle Platform Security Services Audit DB Tables
Summary:
We have enabled audit policy for Oracle Platform Security Services. We need to develop a BIP report to see security console related changes such as Role changes or User's role assignment history.
Content (please ensure you mask any confidential information):
We have enabled audit policy for Oracle Platform Security Services. We need to develop a BIP report to see security console related changes such as Role changes or User's role assignment history.
Standard Audit report for OPSS is not up to the mark. It contain lots of unwanted information and all information is not presented in a single row. Like if you revoke a role from a user, one row will contain the user name from which it got revoked and anther row will tell you the role name. Also there are repetition of information for obi, fscm, IDCCS, hcm & CRM.