Oracle EBS: How to Correct Duplicate Items In Inventory Master Items Form

Although duplicate Item creation is not allowed in Oracle, often times you would come across duplicate Items created in INV, PIM such that the creation date and time is exact same to the level of the milliseconds.

Oracle EBS: How To Clear The Caches Using Functional Administrator

Oracle Caching framework allows to clear the caches in mid-tiers. Caching Framework comes with an administration user interface, which is available under the Functional Administrator responsibility.

When the changes in configurations, profile options are not reflected in the UI or OA framework pages are seen dark blue, clearing caches comes handy.

Oracle EBS: SQL to find currently running jobs in application with start date and time details

The following query find the currently running jobs/concurrent programs in the application along with the date and time details. It's a very useful query which provide the  Request ID, Program name and provided the start date and time in the required format.

Output will be in one column under CURRENTLY_RUNNING_PROGRAMS with results like - 

Request_ID 7746467 (Program Name) has been running since 2015-04-08 14:20:31

Oracle EBS: Query to find application responsibilities assigned to a user

Following SQL query help to find all the application responsibilities assigned to a specific user or users with start date and end dates, provided a user name.
Query can be further tweaked to suit to your needs and fetch additional information life user names in detail, responsibility ID other responsibility details.