Showing posts from May, 2013

End Date a Responsibility for Users

If we need to end date a responsibility for a user then we can use the below syntax. S…

Read more

Finding Patch Level of a Product in Oracle Application

If we need to find the latest patch level for a particular product then we can use the b…

Read more

APP-FND-01926 - The custom event WHEN-LOGON-CHANGED raised unhandled exception. ORA-06508 PL/SQL could not find program unit being called

This error occurs while opening Forms in Oracle Applications. Reason: This issue accu…

Read more

Finding Concurrent Program Past Execution Details

If we need to find the Concurrent Program previous\past execution details then the below…

Read more

Finding the Blocking Session at Database

The below query can be used to find the blocking sessions at the database level. Query…

Read more

Viewing Request Output and Log Files in HTML/Browser

If the ouput and log files of the concurrent needs to be viewed in Browser, then we can …

Read more

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

If we are facing the issue ORA-20002, then we can perform the below work around.This bas…

Read more

Oracle HTTP Server MLR Patchset

There might be requirement from Oracle to check the HTTP server level MLR Patch Set, we …

Read more

Tables which are purged with FND_CONC_CLONE.SETUP_CLEAN

When EXEC FND_CONC_CLONE.SETUP_CLEAN is executed various tables are purged. To know w…

Read more

Finding the Languages Installed in Oracle Applications

The below query can be used for the finding the languages installed in Oracle Applicati…

Read more