Home » Developer & Programmer » Forms » submitting concurrent from PL/SQL problem
submitting concurrent from PL/SQL problem [message #380946] |
Wed, 14 January 2009 04:54  |
20210005
Messages: 24 Registered: November 2007 Location: Dubai
|
Junior Member |
|
|
Dear all,
I have on Oracle Application 11i concurrent which is "pl/sql stored procedure" as executable method. now I am trying to submit this concurrent from pl/sql using the following code but unfortunattly the concurrent not submitted on the application, i tried another concurrent which has "Oracle Report" as executable method and it was submitted successufully,
i think the problem came in the first try because of the type of concurrent which is "pl/sql stored procedure", anybody can help me for this urgent problem.
fnd_global.apps_initialize (13327,54848,20003);
REPORT_NAME :='XX_ALERT_PROC';--Concurrent SHORT NAME
nSubmitReq :=
apps.fnd_request.submit_request(
'xxhr', -- apln id
REPORT_NAME, -- report name
'', -- null
'', -- null
FALSE, -- Sub rquest
'','','',
'',
'',
'', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '');
commit; [EDITED by DJM: Why go to the effort of writing your own code labels? Just use the 'code' tag button.]
[Updated on: Wed, 14 January 2009 22:50] by Moderator Report message to a moderator
|
|
|
Re: submitting concurrent from PL/SQL problem [message #380948 is a reply to message #380946] |
Wed, 14 January 2009 05:27   |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
I guess, you have not included two mandatory parameter errbuff and retcode.
Else see following code how I have submitted request:
L_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST
('XXEGA',
'XXEGA_IBR_BOM_EXPORT',
'',
'',
FALSE,
:EGA_BOM_HEADER.BOM_HEADER_ID,
'',
'','', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '','', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'','', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', ''); [EDITED by DJM: More 'code' tags]
[Updated on: Wed, 14 January 2009 22:52] by Moderator Report message to a moderator
|
|
|
Re: submitting concurrent from PL/SQL problem [message #380951 is a reply to message #380948] |
Wed, 14 January 2009 05:49   |
20210005
Messages: 24 Registered: November 2007 Location: Dubai
|
Junior Member |
|
|
Thanks Boss for your reply,
i put the parameters which u mention, and i dont think that my code is different than your code, just u send a prarameter.
my question is ,
what is the executable method for 'XXEGA_IBR_BOM_EXPORT'??
|
|
|
|
Re: submitting concurrent from PL/SQL problem [message #380959 is a reply to message #380953] |
Wed, 14 January 2009 07:02   |
20210005
Messages: 24 Registered: November 2007 Location: Dubai
|
Junior Member |
|
|
sorry, what exactly you want??
if you mean my procedure code, i don't thing it will be benefit for you because it just a procedure that make some thing,
but if you have a time,I suggest to create any procedure and register it under any concurrent and submit it as normally from the application to make sure it is working fine, then call it from pl/sql and tell me what is the result.
Note:
As i told you RDF was working with me without errors, the problem when the executable method is procedure.
I hope it will work with you Mr.Parag.
Regards
[Updated on: Wed, 14 January 2009 07:06] Report message to a moderator
|
|
|
|
|
Re: submitting concurrent from PL/SQL problem [message #381055 is a reply to message #380977] |
Thu, 15 January 2009 00:27   |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
Hi,
I found the solution as :
When you want to use fnd_request.submit_request from plsql, there is no need of passing null parameters like
L_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST
('XXBC',
'XXBC_CONC_PROG_FRM_PLSQL',
'',
'',
FALSE,
420,
'',
'','', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '','', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '',
'','', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '');
end;
These null parameters needed only when you invoke this block from Oracle forms.
I have created one procedure with following code and registered conc program with one parameter as "value".
create or replace procedure XXBC_CONC_PROG_FRM_PLSQL (errbuf OUT varchar2, retcode OUT varchar2,value number)
is
begin
insert into xxbc.xxbc_test
values(value);
commit;
end;
Hope this will solve your problem..
|
|
|
|
Re: submitting concurrent from PL/SQL problem [message #381064 is a reply to message #381062] |
Thu, 15 January 2009 01:44   |
20210005
Messages: 24 Registered: November 2007 Location: Dubai
|
Junior Member |
|
|
parag,
i cannot understand you, how there is no need for sending null parameters,
FND_REQUEST.SUBMIT_REQUEST must recive dedicated number of parameters, thats mean i cannot ignore any parameter even if it is null,
please send to me exactly your code that call the concurrent to understand what did you mean.
|
|
|
Re: submitting concurrent from PL/SQL problem [message #381075 is a reply to message #381064] |
Thu, 15 January 2009 03:00   |
parag_narkhede
Messages: 110 Registered: January 2008 Location: Pune
|
Senior Member |
|
|
Hi,
I registered a concurrent program of type 'PL/SQL' and tried to submit the request for same through pl/sql block it was working fine code for submitting the request that I used is:
declare
L_REQUEST_ID number;
begin
fnd_global.apps_initialize(1007902, 20420, 1);
L_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST
('XXBC',
'XXBC_CONC_PROG_FRM_PLSQL',
'',
'',
FALSE,
420);
commit;
dbms_output.put_line(l_request_id);
end;
and my concurrent program unit(Procedure which is registered as concurrent program) is:
create or replace procedure XXBC_CONC_PROG_FRM_PLSQL (errbuf OUT varchar2, retcode OUT varchar2,value number)
is
begin
insert into xxbc.xxbc_test
values(value);
commit;
end;
If you want to submit the same concurrent program using Oracle forms then you have to pass null parameters otherwise not.
Just remove null parameters from your code which call fnd_request.submit_request
Test this code for your case and let me know if you have any doubt.
Hope this will help
Regards,
Parag
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Feb 14 09:13:27 CST 2025
|