Home » Applications » Oracle Fusion Apps & E-Business Suite » How to run the concurrent program from database
How to run the concurrent program from database [message #287711] Thu, 13 December 2007 04:13 Go to next message
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.
Re: How to run the concurrent program from database [message #287724 is a reply to message #287711] Thu, 13 December 2007 04:54 Go to previous messageGo to next message
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.
Re: How to run the concurrent program from database [message #287726 is a reply to message #287724] Thu, 13 December 2007 04:58 Go to previous messageGo to next message
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.
Re: How to run the concurrent program from database [message #287728 is a reply to message #287726] Thu, 13 December 2007 05:02 Go to previous messageGo to next message
oracle.jayesh
Messages: 3
Registered: November 2007
Location: Pune
Junior Member
Check if you commited your work after running the procedure.
Re: How to run the concurrent program from database [message #287732 is a reply to message #287728] Thu, 13 December 2007 05:04 Go to previous messageGo to next message
bholaimmu
Messages: 35
Registered: October 2007
Member
tried both the things.
With COMMIT and without COMMIT.

But no results....
Re: How to run the concurrent program from database [message #287809 is a reply to message #287732] Thu, 13 December 2007 10:24 Go to previous message
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)
Previous Topic: FA Account Generator Workflow Customization
Next Topic: AME Documentation
Goto Forum:
  


Current Time: Sun Dec 04 14:45:23 CST 2016

Total time taken to generate the page: 0.20883 seconds