Archive for May, 2012

Not able to login to APPS after cloning – Java.lang.NullPointerException

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 –, I was getting below error

at oracle.apps.fnd.framework.webui.OADialogManager.getDialogMessages(
at oracle.apps.fnd.framework.webui.OAPageSecurity.validatePageSecurity(
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at _oa__html._OA._jspService(

This reminded me another issue where after applying RUP4 patch, I was getting blank page when iProcurement was launched. Hence applied the same fix here and bounced the apache

Fix was – changed the profile “Self Service Personal Home Page Mode” from “Personal Home Page” to “Personal Home Page with Framework”. Reference – Metalink Note ID – 859151.1

This resolved the issue and I was successfully login to APPS


Categories: Oracle Apps

Oracle Workflow not working and giving java null pointer exception..

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 {}, Name [null] and/or Port [1521] is null

we looked for a script which could have updated the POP3 server from backend. Below was the script – endorsed by Oracle.

  1. sqlplus apps/pwd
  2. @$FND_TOP/sql/afsvcpup.sql
  3. At first prompt identify from list the component id for WF Mailer and enter its value : 10006
  4. At second prompt identify the parameter id for POP3 and enter its value
  5. At third prompt enter the new value for parameter POP3 : <new_value>
  6. Bounce the workflow notification mailer

This helped to update POP3 server and workflow notification mailer started without any error.


Categories: Oracle Apps

Migrating LDAP server to a new host

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 point to new LDAP server.

Below step wise approach performed to achieve this

  1. Stop the oidsrv process
    -oidctl connect=fabprod server=odisrv instance=1 stop
  2. how to check if the instance is 1 or 2 (Normally it is 1)
  3. Go to LDAP log directory and look for oidsrvnn.log –> nn can be 1 or 2
  4. Disable the synchrnization profile using Oracle Directory Manager (ODM)
  5. Login to ODM using ‘orcladmin’ user account –> Server management –> Integration Server –>Configuration Set1
  6. Select the profile –> Eidt and select ‘DISABLE’ option
  7. it can be confirmed using ‘ldapsearch’ command – ldapsearch –h <OID_Host> –p <port_no> –D “cn=orcladmin” –w <password> –b “orclodipAgentName=<Profile_name>,cn=subscriber profile ,cn=changelog subscriber,cn=oracle internet directory” –s base “objectclass=*” orclodipagentcontrol
  8. Change the server name (LDAP server name) while in ODM – by going into the execution tab and the property is “Connected Directory URL“. Change this value to new host name or IP address
  9. Make sure the “highestCommittedUSN” is in sync for old and new LDAP server – if not bootstrapping needs to be done
    1. how to check the “highestCommittedUSN” in AD
      1. ldapsearch –h <AD_HOST> –p 389 –D <AD_USER> –w “<password> –b “” –s base “objectclass=*” highestCommittedUSN
  10. While in ODM,update the “last applied change number” attribute with the “highestCommittedUSN”
  11. All this would make the synchonization profile updated with the new values
  12. Remove the OID and LDAP logs. When you start the oidsrv process, these logs will be generated afresh.
  13. Start the oidsrv process
  14. Check if the process started using ‘ldapcheck’ command
  15. Confirm if the synchrnization is working
  16. Final step is to drop and recreate the plugins for external authentication. This is very much required for external authentication as the packages are tagged to the AD host.

I will cover the ‘external authentication’ in my next blog….Keep reading


Categories: Oracle Apps

Deleting duplicate users in Oracle Portal

In one of our PROD application (Oracle portal), user reported that he is not able to login and getting some weird error message. Later on while troubleshooting, it was found that this is happening due to duplicate user in OID.

      How to remove the duplicate user from Oracle portal

Step1 : Login to Portal using ‘orcladmin’ accound and query the problematic user and you will see 2 entries for the same user
Step2 : Login to OID database using ‘portal’ user

a)Query wwsec_person$ table – this table is populated ONLY when the user logs into the portal
b)DELETE the entry from wwsec_person$ table. If there is an error while deleting the user, disable the below triggers, delete the record and then enable the trigger again
Step3 : Remove the entry from LDAP using ldapdelete command
-ldapdelete -h -D “cn=orcladmin” -w -p -v “”
Step4 : Confirm by running the ldapsearch command on the Infra tier
-ldapsearch -h -p -D “cn=orcladmin” -w -b ” -s base “objectclass=*” orclobjectguid

Now the user must be made to synch again with OID. This can be verified from LDAP log.

Categories: Oracle Portal

“View status Diagram” not working after we applied iExpense pathes and RUP4

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 this error – Metalink Note ID – 304685.1.

Updated the profile option – “Server Timezone” to  the database time zone and then retested the issue, it went fine without any above mentioned error. No “NullPointerException”. Fortunately this worked without bouncing the apache.

Categories: Oracle Apps