Saturday, June 26, 2021

Upgrade JRE in Oracle Apps R12.2.9 to j2se18077

 --> Steps for j2se18077 update:

Perform the below steps for both fs1 and fs2:

cd $COMMON_TOP/webapps/oacore/util/javaplugin/

cp -p j2se18077.exe .

Stop APP services

RUN BELOW COMMAND ACROSS ALL SERVERS THAT RUNS FORMS SERVICE

cd $FND_TOP/bin

txkSetPlugin.sh 18077

Note- [This will run autoconfig on current node]

Start APP Services

Verification

$ grep s_sun_plugin_ver $CONTEXT_FILE

         <sun_plugin_ver oa_var="s_sun_plugin_ver">1.8.0_077</sun_plugin_ver>

Workflow Mailer service error- java.lang.NullPointerException

 In Oracle Apps R12.2.9, when configuring Workflow Mailer service, we got beow error 

1617826424396:-1:-1:xxxxxxxxxx.com::-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]::26197:1617826424309:24:ERROR:[SVC-GSM-WFMLRSVC-411183 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:java.lang.NullPointerException

        at java.util.Hashtable.put(Hashtable.java:514)

        at oracle.apps.fnd.wf.mailer.Mailer.validateParameterValues(Mailer.java:874)

        at oracle.apps.fnd.cp.gsc.SvcComponent.performValidateParameterValues(SvcComponent.java:233)

        at oracle.apps.fnd.cp.gsc.SvcComponent.start(SvcComponent.java:314)

        at 

oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(SvcComponentContainer.java:2223)

        at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301)

        at oracle.apps.fnd.wf.bes.DispatchThread.run(Unknown Source)

Resolution

First issue was with the imap account password and we reset the same.

Second issue was solved following Doc ID 242941.1. The issue was with imap server. 

Figure out issue using below command. 

The connection was getting closed on the new  server while it was giving a "OK CASP01 IMAP4 Ready" message on old server.

New Server

$ telnet imap.xxxxx.com 143

Trying xx.xx.xx.xx...

Connected to imap.xxxxxxx.com.

Escape character is '^]'.

Connection closed by foreign host.

Old Server

$ telnet imap.xxxxx.com 143

Trying xx.xx.xx.xx...

Connected to imap.xxxxxxx.com..

Escape character is '^]'.

* OK CASP01 IMAP4 Ready

main : oracle.apps.fnd.isg.mgmt.client.AdminServiceProxy.getNextAppServer : Error: java.lang.SecurityException: User: ISGADMIN~~DBNAME, failed to be authenticated

 We got below error in Oracle Apps R12.2.9 when configuring  Integrated SOA Gateway Setup for REST Services.

main : oracle.apps.fnd.isg.mgmt.client.AdminServiceProxy.getNextAppServer : Error: java.lang.SecurityException: User: ISGADMIN~~DBNAME, failed to be authenticated

This error was gettin populated in log 

$JAVA_TOP/oracle/apps/fnd/isg/ant/ISGD_<>.log

Resolution

Changed the profile option "SignOn Password Custom" to NULL . Changed the ISGADMIN password from frontend (via sysadmin). Can use FNDCPASS also.

The password was retreived using below command:

select fnd_vault.get('ISG','ISGADMIN') from dual;

Later the profile was reverted.


SOA web services can be validated using following link-

http://<ebs-url>/webservices/rest/provider/isActive/