Oracle EBS

HOW-TO: Setup the Oracle AuditTrail to Enhance the Security of the System

Posted by in Oracle EBS
5 Comments

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 …

Read More →

Troubleshooting: Responsibility not Visible by User After unendate

Posted by in Oracle EBS
4 Comments

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

Read More →

SCRIPT: Forms used by a User

Posted by in Oracle EBS
No Comments

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!