Search This Blog

Thursday, January 27, 2011

Java Mailer Setup Diagnostic Test

Source $APPL_TOP/$APPLFENV on the Current Manager node assigned to the Workflow Mailer.
unzip ATGSuppJavaMailerSetup12.zip
./ATGSuppJavaMailerSetup12.sh
It needs following parameters to pass
1)apps user
2)apps user password and following
3)user paswd
PARAMETER_ID PARAMETER_NAME VALUE
------------ --------------- -------------------------
10018 ACCOUNT oracle
10033 INBOUND_SERVER smtp.corp.mycompany.com
10043 OUTBOUND_SERVER smtp.xyz.mycompany1.net
10053 REPLYTO oracle@mycompany.com

Use the following script to get above listed parameters
sql script:
col PARAMETER_NAME format a15
col VALUE format a25
select p.parameter_id,
p.parameter_name,
v.parameter_value value
from fnd_svc_comp_param_vals_v v,
fnd_svc_comp_params_b p,
fnd_svc_components c
where c.component_type = 'WF_MAILER'
and v.component_id = c.component_id
and v.parameter_id = p.parameter_id
and p.parameter_name in ('OUTBOUND_SERVER', 'INBOUND_SERVER', 'ACCOUNT', 'REPLYTO')
order by p.parameter_name;

Ref: Oracle Workflow ATG Support: R12 Java Mailer Setup Diagnostic Test [ID 748421.1]

No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...