Calling SQL*Loader in the shell script and submitting a concurrent request by using CONCSUB
Hello,
Hope someone has suggestions for this issue:
Customer has a SQL*Loader control file where he's calling "FND_GLOBAL.conc_request_id" to retrieve conc_request_id. SQL*loader is invoked from a shell script that is the Host concurrent program (standard out of the box process for registering any Host concurrent executables). See attached RAIL_HR_PF_ENGAGEMENT_LDR.ctl file.
He created a database Package that has this code:
FUNCTION get_conc_request_id
RETURN number
IS
BEGIN
apps.FND_GLOBAL.APPS_INITIALIZE(
user_id => 3106 --v_user_id
, resp_id => 51107 --v_resp_id
, resp_appl_id => 800 --v_resp_appl_id
Hope someone has suggestions for this issue:
Customer has a SQL*Loader control file where he's calling "FND_GLOBAL.conc_request_id" to retrieve conc_request_id. SQL*loader is invoked from a shell script that is the Host concurrent program (standard out of the box process for registering any Host concurrent executables). See attached RAIL_HR_PF_ENGAGEMENT_LDR.ctl file.
He created a database Package that has this code:
FUNCTION get_conc_request_id
RETURN number
IS
BEGIN
apps.FND_GLOBAL.APPS_INITIALIZE(
user_id => 3106 --v_user_id
, resp_id => 51107 --v_resp_id
, resp_appl_id => 800 --v_resp_appl_id
0