Monday, January 11, 2010

How to submit the concurrent request from shell scripts?

CONCSUB utility used for submit the concurrent request from shell scripts. CONCSUB are described in the "System Administration User Guide" as follow:

$ CONCSUB {APPS username}/{APPS password} \
{responsibility application short name} \
{responsibility name} \
{username} \
[WAIT=N|Y{n seconds}] \
CONCURRENT \
{program application short name} \
{program name} \
[PROGRAM_NAME={description}] \
[REPEAT_TIME={resubmission time}] \
[REPEAT_INTERVAL= {number}] \
[REPEAT_INTERVAL_UNIT={resubmission unit}] \
[REPEAT_INTERVAL_TYPE={resubmission type}] \
[REPEAT_END={resubmission end date and time}] \
[START={date}] \
[IMPLICIT={ type of concurrent request} \
[{parameter 1} ... {parameter n}]

For parameters that follow the CONCURRENT parameter and include spaces, enclose the parameter argument in double quotes, then again in single quotes.

-------------------------------------------
More details @ Meta link ID 457519.1

Friday, January 8, 2010

Setting Organization Context in Oracle R12 and 11i

Release 12

BEGIN
apps.mo_global.set_policy_context ('S', org_id_value);
END;

11i Releases

BEGIN
DBMS_APPLICATION_INFO.set_client_info (client_info => 'org_id_value');
END;
--------------- or----------
BEGIN
fnd_global.initialize (NAME => 'ORG_ID', VALUE => 'org_id_value');
END;

Meaning of table's suffix