Home » Developer & Programmer » Forms » submitting concurrent from PL/SQL problem
submitting concurrent from PL/SQL problem [message #380946] Wed, 14 January 2009 04:54 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #380953 is a reply to message #380951] Wed, 14 January 2009 06:04 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Its a RDF report...... If possible, please attach the procedure code to this message. I will register it ans test it.


Re: submitting concurrent from PL/SQL problem [message #380959 is a reply to message #380953] Wed, 14 January 2009 07:02 Go to previous messageGo to next message
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 #380964 is a reply to message #380959] Wed, 14 January 2009 07:23 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
OK. I will test it on my local instance.
But are you passing any parameter to procedure?
Re: submitting concurrent from PL/SQL problem [message #380977 is a reply to message #380964] Wed, 14 January 2009 09:51 Go to previous messageGo to next message
20210005
Messages: 24
Registered: November 2007
Location: Dubai
Junior Member
yes i passed parameter, kindly check by calling the concurrent with and witout passing parameters by changes on called procedure.

thanks
Re: submitting concurrent from PL/SQL problem [message #381055 is a reply to message #380977] Thu, 15 January 2009 00:27 Go to previous messageGo to next message
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 #381062 is a reply to message #381055] Thu, 15 January 2009 00:52 Go to previous messageGo to next message
20210005
Messages: 24
Registered: November 2007
Location: Dubai
Junior Member
Thanks alot for your efforts,

I will check and inform you for the result.

Hope this will be the solution.
Re: submitting concurrent from PL/SQL problem [message #381064 is a reply to message #381062] Thu, 15 January 2009 01:44 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: submitting concurrent from PL/SQL problem [message #381156 is a reply to message #381075] Thu, 15 January 2009 08:06 Go to previous messageGo to next message
20210005
Messages: 24
Registered: November 2007
Location: Dubai
Junior Member
Hi,

Thanks alot for your reply, and i will test your code on saturday because tomorrow is off.

i will inform you about the result Boss.

Regards
Re: submitting concurrent from PL/SQL problem [message #381221 is a reply to message #381075] Thu, 15 January 2009 21:26 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@Parag,

Will you please use 'code' tags!

David
Re: submitting concurrent from PL/SQL problem [message #381231 is a reply to message #380946] Thu, 15 January 2009 23:06 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member

Sorry for the mistake.
I am new to this forum. Yesterday I read some guidelines to follow. I will try my level best to follow it.
Re: submitting concurrent from PL/SQL problem [message #381438 is a reply to message #381231] Fri, 16 January 2009 23:49 Go to previous message
20210005
Messages: 24
Registered: November 2007
Location: Dubai
Junior Member
Hi,
Parag

Thank you very much for your assistant, today i execute your code and it is working fine without any errors.

Regards,
Moamin Shadid


Previous Topic: ANSI Joins in Forms 6
Next Topic: commiting changes in a block without a change
Goto Forum:
  


Current Time: Mon Dec 05 15:18:42 CST 2016

Total time taken to generate the page: 0.08999 seconds