Correlate the icx_ticket value within connect_server() in a Oracle NCA script

Correlate the icx_ticket value within connect_server() in a Oracle NCA script

Correlating icx_ticket

In the following example, you need to correlate the value for "icx_ticket."

Example:
connect_server("111.11.111.11", "3610"/*version=11i*/,"module=/of11dev3-01/u01/app/oracle/11.5.3/prodappl/fnd/11.5.0/forms/US/FNDSCSGN userid=applsyspub/pub@of11dev3 fndnam=apps config=’bluebeard_of11dev3′ icx_ticket=’.813529852′ resp=’MLGL/ML_GL_REPORTING_MANAGER’ secgrp=’STANDARD’::NLS_LANG=’AMERICAN_AMERICA.UTF8′ FORMS60_USER_DATE_FORMAT=’DD-MON-RRRR’ FORMS60_USER_DATETIME_FORMAT=’DD-MON-RRRR HH24:MI:SS’ NLS_DATE_LANGUAGE=’AMERICAN’");

This value is not recorded by the Oracle NCA protocol. It is recorded by the Web protocol on the initial URL. You need to correlate it using a web_create_html_param or web_reg_save_param statement.

Example:
//Correlate the icx_ticket base on the boundary as retuned by the server
web_reg_save_param("icx_ticket", "LB=TICKET=", "RB=&RES", LAST);

web_url("OracleConfigure.render",
"URL=http://111.11.111.11:9002/pls/VIS/OracleConfigure.render\?p_page_id=2598&p_mode=0", LAST);


//use the correlated value for the icx_ticket number
connect_server("111.11.111.11", "3610"/*version=11i*/,"module=/of11dev3-01/u01/app/oracle/11.5.3/prodappl/fnd/11.5.0/forms/US/FNDSCSGN userid=applsyspub/pub@of11dev3 fndnam=apps config=’bluebeard_of11dev3′ icx_ticket='<icx_ticket>’ resp=’MLGL/ML_GL_REPORTING_MANAGER’ secgrp=’STANDARD’::NLS_LANG=’AMERICAN_AMERICA.UTF8′ FORMS60_USER_DATE_FORMAT=’DD-MON-RRRR’ FORMS60_USER_DATETIME_FORMAT=’DD-MON-RRRR HH24:MI:SS’ NLS_DATE_LANGUAGE=’AMERICAN’");

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s