EBS Customizations (MOSC)

MOSC Banner

FND_SUBMIT API is not working

edited Jul 22, 2016 11:43AM in EBS Customizations (MOSC) 2 commentsAnswered

I am not able to submit the request set with the below sample code.

When I execute the code the request set is showing in fnd_concurrent_requests table with phase_code='P' and status_code='I'

But the stage is not submitting. So the execution is error 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