Running an Oracle Host Concurrent program from PL / SQL
Kindly assist.
Am submitting this request from a wrapper PL/SQL fired thru Concurrent program.
l_conc_output :=
apps.fnd_request.submit_request (
application => 'TEST',
program => 'PULL_FILES_A',
description => NULL,
start_time => SYSDATE,
sub_request => FALSE);
argument1 => p_ledgername, -- filename to look for
argument2 => l_remhost, -- remote host
argument3 => l_remdir, -- remote dir
argument4 => l_remacct, -- remote acct
argument5 => l_fnprefix -- filename prefix
);
FND_FILE.PUT_LINE(fnd_file.LOG,'Pull_Files completed...');
When I submit the concurrent program PULL_FILES_A by itself, it works fine.
However, when I try to submit that same concurrent program from a PLSQL wrapper fired thru a "parent" concurrent program, that line above is getting "skipped". There are no errors and the "Pull_Files completed..." message appears in the logs, too.