Configure ISG Rest services in R12.2.9

In Oracle Apps R12.2.9, follokw the below steps to configure Integreated SOA gateway

1 select substr(user_name, 1, 30) name, substr(role_name, 1, 30) role 

From wf_local_user_roles 

Where user_name='ASADMIN';

2 Confirm if the below queries retrieve the same password for ASADMIN user. 

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

select fnd_vault.get ( 'FND', 'ASADMIN' ) from dual;

3 Update ASADMIN password in FND_VAULT using the below script. Replace ASADMIN password accordingly. 

@$FND_TOP/sql/afvltput.sql FND ASADMIN Fish1234

4 ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkSoaConfigUtility.xml addASADMINToFNDVault

-- this will update under ISG

5 Confirm that the ASADMIN user's password is correct. Substitute it for the ASADMIN user password. 

Select fnd_web_sec.validate_login('ASADMIN','Fish1234') From dual;

6  Source the applications run file system environment file

Admin server should be up for this

Run the following script:

perl $FND_TOP/patch/115/bin/ISGRestSetup.pl

--> the script took 10 mins

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

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