Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Running an Oracle Host Concurrent program from PL / SQL

edited Jan 11, 2017 3:40PM in Core Concurrent Processing - EBS (MOSC) 4 commentsAnswered

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center