Showing posts from May, 2013

End Date a Responsibility for Users

Oracle Apps -

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

Oracle Apps -

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

Oracle Apps -

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

Read more

Finding Concurrent Program Past History Execution Details

Oracle Apps -

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

Read more

Finding the Blocking Session at Database

Oracle 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

Oracle Apps -

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

Oracle Apps -

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

Oracle Apps -

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

Oracle Apps -

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

Oracle Apps -

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

Read more