OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Help in Submitting Concurrent Request..Urgent

Home » Applications » Oracle Fusion Apps & E-Business Suite » Help in Submitting Concurrent Request..Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help in Submitting Concurrent Request..Urgent [message #312958]

Thu, 10 April 2008 03:50

venkatesham
Messages: 45
Registered: April 2005
Location: Hyd

Member

Hi,

I have a trigger on table, and on insert it submits a concurrent program thro FND_SUBMIT.REQUEST_SUBMIT..
whoever insert a new record(thro front-end), the request is submitted thro his/her user..(i.e. requested_by)...i want to submit the request thro sysadmin user..
is it acheivable ??
please help...

Thanks,
venkatesham

Report message to a moderator

Re: Help in Submitting Concurrent Request..Urgent [message #313678 is a reply to message #312958]

Mon, 14 April 2008 02:57

lotus14
Messages: 5
Registered: February 2005

Junior Member

In the trigger code, you initialise the apps with sysadmin user with the following code

FND_GLOBAL.APPS_INITIALIZE(g_num_user_id,--use sysadmin user id
g_num_resp_id,
g_num_resp_appl_id);

Hope this will help you..

Report message to a moderator

Re: Help in Submitting Concurrent Request..Urgent [message #314035 is a reply to message #312958]

Tue, 15 April 2008 10:55

venkatesham
Messages: 45
Registered: April 2005
Location: Hyd

Member

Hi,

Thanks for the update.it works!!
I need another help, can we restrict a request not to be visible in 'All my requests'for a particular user.

Eg.- if a scheduled prgm 'Test1' submitted every 10 mins
thro user login "A".. at EOD user will find many requests..
can we make not to show the user these requests though 'All my requests' option is used ?

Thanks,
venkatesham

Report message to a moderator

Re: Help in Submitting Concurrent Request..Urgent [message #315630 is a reply to message #312958]

Tue, 22 April 2008 04:33

venkatesham
Messages: 45
Registered: April 2005
Location: Hyd

Member

Hi,

Can anyone help me in this case ?

Thanks in advance.

Regards,
Venkat

Report message to a moderator

Re: Help in Submitting Concurrent Request..Urgent [message #316032 is a reply to message #312958]

Wed, 23 April 2008 09:16

venkatesham
Messages: 45
Registered: April 2005
Location: Hyd

Member

Hi All,

got the solution.
we have option to be set before we submit the request,

FND_REQUEST.SET_OPTIONS(IMPLICIT => 'ERROR');

This is optionally called before submitting a concurrent request to set request options.
It determines whether to display this concurrent request in the end–user Concurrent Requests form.
(All requests are automatically displayed in the System Administrator’s privileged Concurrent Requests form, regardless of the value of this argument.) Specify ‘NO’, ‘YES’, ‘ERROR’, or ‘WARNING’.

Parameters Explanation:-

‘NO’ allows the request to be viewed on the end–user Concurrent Requests form.

‘YES’ means that the request may be viewed only from the System Administrator’s privileged Concurrent Requests form.

‘ERROR’ causes the request to be displayed in the end user Concurrent Requests form only if it fails.

‘WARNING’ allows the request to display in the end–user Concurrent Requests form only if it completes with a warning or an error.

Thank you,

Venkatesham

Report message to a moderator

Previous Topic:	trying to customize ASTCUTM1.fmb
Next Topic:	unable to pass flexfield values from report wrapper to oracle applications seeded report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 08:05:57 CDT 2024