GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Oracle Apps
Go To First  |  Previous Question  |  Next Question 
 Oracle Apps  |  Question 39 of 174    Print  
How to run concurrent request from an after report trigger in a report? (This report runs as a concurrent program, but this should launch another concurrent program to run after its execution based on its request ID as parameter to the next cocurrent program)

  
Total Answers and Comments: 2 Last Update: December 26, 2006     Asked by: Brijesh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 08, 2006 15:38:46   #1  
Silpa        

RE: How to run concurrent request from an after report...

Brijesh,

                    Were u able to get the answer for ur question. If so could u please let me know. I have to kick off a shell script from the after report trigger. Thanks in advance.

Silpa.


 
Is this answer useful? Yes | No
December 26, 2006 04:54:30   #2  
Brajesh Singh Bhadoriya Member Since: December 2006   Contribution: 12    

RE: How to run concurrent request from an after report...

To call a concurrent program from after report trigger of the report one can not use fnd_request.submit_request deirectly. But one must use the following:

1. If this is a custom report then in the "before report trigger" you need to set the SRW.USER_EXIT('FND SRWINIT');
this will set conc request id and other env variables for the report.

2. You shall have to define a user parameter of type number by the name P_CONC_REQUEST_ID. you can read/pass the value of this parameter as :P_CONC_REQUEST_ID in after report trigger.In the after report trigger put SRW.USER_EXIT('FND SRWEXIT'); before the trigger ends.

3. Make sure the parameters you are passing to the fnd_request.submit_request are correct...the application short name and concurrent-prog short names should be valid. 

These changes will make u to submit concurrent program.

Thanks,

Brajesh


 
Is this answer useful? Yes | No

 Related Questions

Can we get data for a Report from _v and _vl. Is it possible to use a view to retrive the data for a report
Read Answers (3) | Asked by : gopal

What is the difference between the \'Application\' entered while registering a concurrent program and the Application in the Request Group where the concurrent program is attached,how can we diffrentiate which report belongs to which application
Read Answers (1) | Asked by : Ashish

I have run a request and it is in pending status since one hour and got completed as normal in two seconds time. My question is :why the request was in pending state for one hour as it was not scheduled also. Also ther where only a few requests running that time.... there was no load on managers also..what could be the possible reasons?
Read Answers (2) | Asked by : muneer

What is the usage of Recurring Invoice Report from AP module?what is the functionality of Requisition interface from PO module?
View Question | Asked by : chiranjeevi reddy

What is the various Return codes in the registration of PL/SQL concurrent program?Trouble shooting in Interfaces and various Oracle Application modules?
Read Answers (2) | Asked by : chiranjeevi reddy

Latest Answer : 1. When you get MD050, first take some time to analyse the MD50 and understand the functionality of the report.2. See the layout given in MD050.3. Try to find out the Tables involved in that.4. Develope pseudo code and prepare MD070.5. check any format ...
Read Answers (2) | Asked by : poojar

What are the 2 mandatory parameters that we pass when we register a conc program in oracle applications
Read Answers (3) | Asked by : suresh kumar

Revenue Recognition Master Program PL/SQL Stored Procedure on Daily Basis. Need Help!! How can I do that. What are the consequences of changing the Master Program. How can I change it so the Revenue is recognized daily as well.
View Question | Asked by : sbagai2001

How to run concurrent request from an after report trigger in a report? (This report runs as a concurrent program, but this should launch another concurrent program to run after its execution based on its request ID as parameter to the next cocurrent program)
Read Answers (2) | Asked by : Brijesh

How to share a request set with a resposibility?I have set up a request but want to share it so other users can run?
Read Answers (2) | Asked by : Corbon


 Sponsored Links

 
Related Articles

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Performing DML Operations on XML Schema Based XMLType Views

Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol
 

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b
 

Getting Started with Oracle and ODP.NET

ODP NET Developer’ s Guide by Jagadish Chatarji Pulakhandam Sunitha Paruchuri A practical guide for developers working with the Oracle Data Provider for NET and the Oracle Developer Tools for Visual Studio 2005 Application development with ODP NET Dealing with XML DB using ODP NET Oracle
 

PHP Oracle Web Development Review

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books The author is also an expert in open source technologies and SOA Service Oriented Architecture But besides
 

Microsoft AJAX Library - JavaScript Execution Context

JavaScript Execution Context In this section we ll take a peek under the hood of the JavaScript closures and the mechanisms that allow us to create classes objects and object members in JavaScript For most cases understanding these mechanisms isn t absolutely necessary for writing JavaScript code&am
 

Step by Step Oracle PL-SQL Tutorial

This introductory tutorial to PL SQL will help you to understand the basic concepts of PL SQL Please review the following tutorials and practice the sample SQL Statements on your local Oracle Database Please note that you must learn these basic things before we actually start getting in to Advanced
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape