General Description
The Audit Trail is an Oracle inbuilt functionality that lets audit specific columns belonging to selected tables. This implementation enhances the security of the system.
Purpose
Purpose of this document is to instruct the user to setup the Oracle AuditTrail on the following tables:
• FND_PROFILE_OPTION_VALUES (Profile Option Updates)
• FND_USER (New User Creations or Updates)
• WF_LOCAL_USER_ROLES (Responsibility Assignments)
Getting Started
For [...]

It can happen that after unendating a responsibility assignment, the user cannot see that responsibility. To solve this problem there are 2 procedures that can help:
1. Run the request ‘Sync responsibility role data into the WF table’.
2. Run the request “Synchronize WF LOCAL tables”.
3. Run the request “Workflow Directory Services User/Role Validation” (with parameters 10000, [...]

Purpose
The Purpose of this of this configuration, is to create a report that shows which active responsibilities are assigned to which active users. The same procedure can be followed to create a report that runs whatever query.
Description
The implementation of this report will be divided in 5 steps:
1. Create the Executable on the EBS
2. Create the [...]

Before to set an end date to a user account, it always worth to check if there are scheduled concurrent programs assigned.
The script scheduled_programs.sql can be customized to get which users have scheduled the same program or which programs have been scheduled by a single user.
If you find it useful do not forget to leave [...]

In case of issues, a System Administrator needs to know what a user has done in the system.
The script forms_used_by_user.sql gives in output the forms that have been used and for how long.
If you find it useful do not forget to leave your comment!

Purpose
The Purpose of this Form Personalization is to limit the access to the profile option settings disabling the Site Level checkbox.
Description
The implementation of this Form Personalization is divided in 2 steps:
1. Uncheck the Site Level Checkbox.
2. Hide the Site Level Checkbox.
Form Personalization Function Definition
Responsibility: System Administrator
Navigate: Application -> Function
Define a new function that is a [...]

Purpose
The Purpose of this Form Personalization is to restrict the list of responsibilities that a user can assign using the ‘Users’ function that access the form FNDSCAUS.
Description
The implementation of this Form Personalization is divided in 3 steps:
1. Restrict the List of Values of the Responsibilities.
2. Make Read Only the Responsibility START_DATE and END_DATE.
3. Hide the [...]