Oracle Application Technology

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 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

Anand

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 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.

Anand

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

-Anand

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.