Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent Request - Backend (EBS 11.5.10.2/ Solaris)
Concurrent Request - Backend [message #477873] Tue, 05 October 2010 00:59 Go to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi All,

I have a requirement to execute concurrent requests on a daily basis. Hence I have decided to automate it using PL/SQL. The below given code was taken from metalink, and I have modified it as per my needs. When I execute the code, the out is Quote:

PL/SQL procedure successfully completed.
.
But I am unable to view the concurrent request displayed either in the front end or backend. Can someone help me on this?
DECLARE
v_request_id varchar2(100);
begin
FND_GLOBAL.APPS_INITIALIZE(0,20420,0);
v_request_id := FND_REQUEST.SUBMIT_REQUEST (application => 'Application Object Library',
          program          => 'Workflow Directory Services User/Role Validation',
          description      => NULL, 
          start_time       => NULL,-- To start immediately 
          sub_request      => FALSE,
          argument1        => '1000',
          argument2        => 'Yes',
          argument3        => 'Yes',
          argument4        => '', 
          argument5        => '', 
          argument6        => '',
          argument7        => '',
          argument8        => '',
          argument9        => '',
          argument10       => '',
          argument11       => '',
          argument12       => '',
          argument13       => '',
          argument14       => '',
          argument15       => '',
          argument16       => '',
          argument17       => '',
          argument18       => '', 
          argument19       => '', 
          argument20       => '',
          argument21       => '',
          argument22       => '',
          argument23       => '',
          argument24       => '',
          argument25       => '',
          argument26       => '',
          argument27       => '',
          argument28       => '',
          argument29       => '', 
          argument30       => '' 
          );
dbms_output.put_line('Request submitted. ID = ' || v_request_id);
commit ;
exception
when others then
dbms_output.put_line('Request set submission failed - unknown error: ' ||
sqlerrm);
END;
/ 


Regards,
Antony
Re: Concurrent Request - Backend [message #477902 is a reply to message #477873] Tue, 05 October 2010 03:17 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Have you searched the Forum?
Did you look at the Developer Guide, how to code it?
1. Have you checked the request_id? Is it coming as zero?
2. application and program parameters are short codes, not the full names.
3. Last but not the least. Why can't you use scheduler in SRS window? Why you want to do it from PL/SQL.

By
Vamsi
Re: Concurrent Request - Backend [message #477923 is a reply to message #477902] Tue, 05 October 2010 04:52 Go to previous messageGo to next message
eric62
Messages: 24
Registered: January 2009
Junior Member
Hello

Parameter application:It's the application short Name?
Parameter program : It's thhe program short Name?

Regards,
Eric.
Re: Concurrent Request - Backend [message #478085 is a reply to message #477923] Wed, 06 October 2010 02:22 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Thanks for the input. After providing the short names, I was able to view the record when I press F9 in toad. But if I issue F5, the records are not visible. Also, the records are not visible in the front end. What could be the issue?
Re: Concurrent Request - Backend [message #478086 is a reply to message #478085] Wed, 06 October 2010 02:35 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
You didn't answer my 1 and 3 questions.

By
Vamsi
Re: Concurrent Request - Backend [message #478087 is a reply to message #478085] Wed, 06 October 2010 02:38 Go to previous messageGo to next message
eric62
Messages: 24
Registered: January 2009
Junior Member
Hello.

I don't use Toad -> I don't know F5.

I see :
FND_GLOBAL.APPS_INITIALIZE(User_Id => 0,....).

Do you connected as user_id 0 (SYSADMIN).
Othervise you see all users' requests under responsibility "System Administrator" (Menu: Concurrent -> Requests).

Regard,
Eric.
Re: Concurrent Request - Backend [message #478093 is a reply to message #478087] Wed, 06 October 2010 03:45 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Vamsi : 1. New IDs are generated. I am able to see when I press F5.
3. I don't what an SRS is Sad

Eric : Yes, I connect as sysadmin, I used the find the requests option to view the request. I use concurrent program name as input. So, I should be able to see, if the request is in the front-end.
Re: Concurrent Request - Backend [message #478094 is a reply to message #478093] Wed, 06 October 2010 03:47 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Vamsi: Adding to the previous one, we refresh the environment on a daily basis, so I feel using PL/SQL will be the correct option.
Re: Concurrent Request - Backend [message #478096 is a reply to message #478094] Wed, 06 October 2010 04:01 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Thank u everyone. I did not issue a commit. That was the problem.

F5 - shows committed rows.
F9 - show uncommited rows also.
Re: Concurrent Request - Backend [message #478141 is a reply to message #478096] Wed, 06 October 2010 09:43 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
But you have the commit in the code, which you have posted.
SRS -> Standard Request Submission
Anyway, as you are refreshing everyday, you want to run the PL/SQL. Fine....

By
Vamsi
Previous Topic: Cash Management Bank statement loading UK
Next Topic: Problem while Creation of Recipts in Iprocurement
Goto Forum:
  


Current Time: Mon Dec 23 13:18:08 CST 2024