Danilo's Blog

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 →

Troubleshooting: LD_LIBRARY_PATH… Warning: ocilogon() http://function.ocilogon: OCIEnvNlsCreate() failed.

Posted by in Oracle on Unix Server
10 Comments

If you are connecting an Oracle Database using an Apache2 webserver that runs on an Ubuntu machine, you might randomly have this error. Warning: ocilogon() http://function.ocilogon: OCIEnvNlsCreate() failed. There is something wrong with your system – please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries. It can be solved setting properly the …

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!