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 […]

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” […]

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 […]

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 […]

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 […]

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 […]

« go back