Couple of days back, got a mail from Development team that their concurrent requests are not being processed in DEV instance. From the front end, requests are showing ‘Inactive’ & ‘No Manager’ I started looking into it. From the historical run of the job, it was showing as processed by ‘Standard Manager’. Hence thought of Continue reading

As a DBA, the most challenging task comes when we need to work or diagnose the performance issue. Since I have worked extensively on performance tuning, I would like to share different ways to trace Oracle user session. Tracing is a very handy tool for any DBA to be the first thing to look for Continue reading

It is necessary to know the concurrent program corresponding to ‘Material Transaction’ Interface manager. This is so because before you launch this interface manager, corresponding concurrent program schedule needs to be cancelled. Concurrent program corresponding to ‘Material Transaction’ interface manager – “Process transaction interface” Step 1: Cancel the existing schedule Login using ‘System Administrator’ responsibility Continue reading

Today I got a call from Development team that one the concurrent jobs submitted (in Development instance) by them has not been processed since long. I looked into the job and it showed it is in ‘Pending Standby’ status even though the manager has enough worker to process Somehow it looked to me concurrent manager issue. Continue reading

Today while cloning a DEV instance, I got below error while running adadmin utilitu to update the snapshot information AD Administration error: adusnapUpdateGlobalView(): Error while executing statement AD Administration error: ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_FILES_U2) violated ORA-06512: at “APPS.AD_FILE_UTIL”, line 2398 ORA-06512: at line 3 AD Administration error: adusnapStoreInDB(): Error calling adusnapUpdateGlobalView() Failed to store APPL_TOP Continue reading

Today after cloning a DEV instance from PROD – where we recently applied RUP4 (4676589) patch, I was not able to login to APPS. Launching a direct URL – http://server.domain.com:8000, I was getting below error Java.lang.NullPointerException at oracle.apps.fnd.framework.webui.OADialogManager.getDialogMessages(OADialogManager.java:187) at oracle.apps.fnd.framework.webui.OAPageSecurity.displayPageSecurityError(OAPageSecurity.java:1223) at oracle.apps.fnd.framework.webui.OAPageSecurity.validatePageSecurity(OAPageSecurity.java:938) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2132) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1717) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423) at _oa__html._OA._jspService(_OA.java:86) This reminded me Continue reading

Recently we had an issue in our production environment where the POP3 server for Workflow was migrated to a new host and hence while changing/updating the same from ‘Workflow Manager’ GUI, it was throwing below error java.lang.NullPointerException: Host {xxx-xx-xx.com}, Name [null] and/or Port [1521] is null we looked for a script which could have updated Continue reading

Recently there was a sudden requirement where our Micosoft AD (LDAP server) was being moved to a new host. This could have rendered all the application, where user authentication happens through LDAP, inaccessible – if the applicaiton would not have changed accordingly. One of the critical external customer facing application was supposed to be reconfigured to Continue reading

Recently we implemented iexpense module (11iOIE.K) along with RUP4 patches. Post this, ‘View Status” diagram under ‘Workflow System Administrator’ option started throwing error “Error Page. Contact your system administrator” while checking the JVM logs, error logged showed OAException]:Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException There is a direct hit in the Metalink for Continue reading