EBS Customizations (MOSC)

MOSC Banner

Not able to submit request set bu FND_SUBMIT API

edited Jul 16, 2016 5:02AM in EBS Customizations (MOSC) 1 commentAnswered

Hi,

I am using below sample code to submit request set from back end.

But after executing the below script request set is showing in FND_CONCURRENT_REQUETS table with phase_code = 'P' and status_code='I'

But the stage is not submitting and after sometime the request is showing errored out .

declare

V_REQUEST_SET_EXIST   BOOLEAN := FALSE;

req_id                INTEGER := 0;

l_CONC_PROG_SUBMIT    BOOLEAN := FALSE;

srs_failed            EXCEPTION;

submitprog_failed     EXCEPTION;

submitset_failed      EXCEPTION;

l_start_date          VARCHAR2(250);

BEGIN

fnd_global.APPS_INITIALIZE(user_id=>'27945',

                           resp_id=>'58936',

                           resp_appl_id=>702);

dbms_output.put_line('Calling set_request_set');

Tagged:

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