XML Gateway on Release 12:

XML Gateway on Release 12:

Solution

1. Run the following command to locate the properties file that you want to customize to preserve your settings:

sh $AD_TOP/bin/adtmplreport.sh contextfile=$CONTEXT_FILE target=$INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties

2. Navigate to the location of the template directory and create a custom subdirectory to store to store your customization:

cd $FND_TOP/admin/template

mkdir custom

3. Copy the template file to the custom directory.

cp $FND_TOP/admin/template/oafm_oc4j_properties_1013.tmp $FND_TOP/admin/template/custom

4. Verify which OTA related parameters already exist as context variables as these can easily be updated in the $CONTEXT_FILE file be changed when you run autoconfig.

vi $FND_TOP/admin/template/custom/oafm_oc4j_properties_1013.tmp

#

# Place holder for OXTA configuration

#

applSysSchema=%s_applsys_user%

OXTAInPoolSize=%s_oxtainpool_size%

OXTAOutThreads=%s_outbound_threads%

OXTAOutUseProxy=%s_oxta_proxy%

OXTAOutProxyHost=%s_oxta_proxyhost%

OXTAOutProxyPort=%s_oxta_proxyport%

5. Add your environment specific settings to the your EBS version file:

$FND_TOP/admin/template/custom/oafm_oc4j_properties_1013.tmp

# Custom Static Parameters

#

# Increase Max Inbound Size From 1M

#

OXTAInMaxContent=10000000

# Increase From 10 Seconds

#

OXTAOutBaseTimeout=60

# Increase From 500 ms/kb

#

OXTAOutLinearTimeout=1000

# Increase From 180 Seconds

#

OXTAOutMaxTimeout=540

# Decrease From 5 Attempts

#

OXTAOutMaxAttempts=3

# Decrease From 300 Seconds

#

OXTAOutResendDelay=30

6. Run autoconfig and confirm that your Custom Static Parameters are now in your EBS version properties file:

vi $INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties

+++++++++++++++ Configure OTA For XML +++++++++++++

Referred doc  418926.1 and 1087499.1

Note For 1087499.1 ID

Need to change ASADMIN Password :
Step 1:

FNDCPASS apps/apps 0 Y system/manager USER ASADMIN Welcome1

   (Or)
Through OAM

Keep ASADMIN password as below:

user= ASADMIN

password=  ASADMIN

Keep password as !Welcome1

EX:

<user>
         <name>ASADMIN</name>
               <display-name>Default Apps SOA User</display-name>
               <description>Used by SOAProvider for DB connection</description>
                      <credentials>!welcome1</credentials>
</user>

[oracle@svrqatal1 config]$  cd /d01/oracle/SVRQAT/inst/apps/SVRQAT_svrqatal1/ora/10.1.3/j2ee/oafm/config

[oracle@svrqatal1 config]$  cat  system-jazn-data.xml | grep credentials

                              <credentials>!welcome1</credentials>

                     

Shutdown and restart the OAFM container and re-test:

sh $ADMIN_SCRIPTS_HOME/adoafmctl.sh  stop / start 

Query to view the status:

SQL> select machine,action, decode(count(*),0,'Error: OTA is Not Running','OTA is Running')

from gv$session  where action like '%OXTA%'  group by machine, action;

+++++++++++++++++++++++++++                                  

Preserve System Properties Customized For Your ECX (XML Gateway) [ID 829449.1]

+++++++++++++++++++++++++++