OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to run the concurrent program from database

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to run the concurrent program from database

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

How to run the concurrent program from database [message #287711]

Thu, 13 December 2007 04:13

bholaimmu
Messages: 35
Registered: October 2007

Member

Hi,

How can we run the concurrent program from the back-end rather than the front-end using FND_GLOBAL.apps_initialize and FND_REQUEST.submit_request.

Thx N Regs,
Khan.

Report message to a moderator

Re: How to run the concurrent program from database [message #287724 is a reply to message #287711]

Thu, 13 December 2007 04:54

oracle.jayesh
Messages: 3
Registered: November 2007
Location: Pune

Junior Member

FND_REQUEST.SUBMIT_REQUEST (Client or Server)
Summary function FND_REQUEST.SUBMIT_REQUEST
(application IN varchar2 default NULL,
program IN varchar2 default NULL,
description IN varchar2 default NULL,
start_time IN varchar2 default NULL,
sub_request IN boolean default FALSE
argument1,
argument2, ..., argument99,
argument100) return number;

Refer Oracle Developers Guide Page 420 for further details.

Report message to a moderator

Re: How to run the concurrent program from database [message #287726 is a reply to message #287724]

Thu, 13 December 2007 04:58

bholaimmu
Messages: 35
Registered: October 2007

Member

Hi,

Thx for ur help....

When I run the procedure, its showing procedure successfully completed but I am not able to find either in front-end or in back-end that the program has been run.

Thx N Regs,
BI.

Report message to a moderator

Re: How to run the concurrent program from database [message #287728 is a reply to message #287726]

Thu, 13 December 2007 05:02

oracle.jayesh
Messages: 3
Registered: November 2007
Location: Pune

Junior Member

Check if you commited your work after running the procedure.

Report message to a moderator

Re: How to run the concurrent program from database [message #287732 is a reply to message #287728]

Thu, 13 December 2007 05:04

bholaimmu
Messages: 35
Registered: October 2007

Member

tried both the things.
With COMMIT and without COMMIT.

But no results....

Report message to a moderator

Re: How to run the concurrent program from database [message #287809 is a reply to message #287732]

Thu, 13 December 2007 10:24

prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US

Senior Member

first you need to initialize the apps using

1)fnd_global.apps_initializ(v_user_id,v_resp_id,v_resp_appl_id);
2) call fnd_request.submit_request
3) commit
4) check request id (optional)

Report message to a moderator

Previous Topic:	FA Account Generator Workflow Customization
Next Topic:	AME Documentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 07:38:54 CST 2024