Introduction

In a typical large organization where multiple individuals work on a single application to support the Business Operation it is very natural that multiple changes are made to configuration setups and transactional data and tracking details like who/when and why made these changes become really difficult.

Audit Framework Functionality of Oracle HCM Cloud (also applicable to other modules including FIN, SCM etc) does comes to rescue.

Please refer MOS (My Oracle Support) article below to get more details:

http://docs.oracle.com/cd/E28271_01/fusionapps.1111/e15524/bs_audit.htm#CIHEIBBI . Check the chapter 12 Implementing Audit Trail Reporting for more details.

While there are specific setups required in case one is interested to find audit details for Transactional Tables there is a delivered ESS Job (Scheduled Process) for Tracking User Password Changes.

While some might feel at this point that how does this info matters it actually can  in specific scenario, Some most common ones being:

1. End User raises a request to Support Team for Password Change. Support Team makes the changes. End user comes back complaining that reset operation was never done and ticket was closed without any actions been performed.

2. To understand how often User Passwords are changed and what kind of support manpower may be required to support Business Operations on this front.

These are the two usage which I can think of at this point of time but there could be many other scenarios too.

“User Password Changes Audit Report” is the name of the delivered scheduled process.

We would try to run the Scheduled process and have a look at the Output.

Running the Scheduled Process

Like all other scheduled process this one also is submitted using the following navigation

Navigator->Tools->Scheduled Processes

Once you click on the link you would be directed to the Scheduled Process page where you can try to submit the scheduled process “User Password Changes Audit Report”. This process provides flexibility of choosing “All Users”, “Single User” or even choosing a specific “Name Pattern”. Also one can select specific date range within which the scheduled process should be run. I guess the below screenshot are self-explanatory

Once we submit we will observe that there will be three zip files created.

And the output data will appear as below:

One important thing to note is this Process only returns details of the changes made by the logged in user. So if you are an implementation user you would need to login with your specific credentials.

Also, by running this report at any point of time one may even come to know how many password updates have been done by a specific support executive over a particular span of time including the exact data and time of the change.

Hope this is useful!

Ashish Harbhajanka

Add comment