GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 58 of 98    Print  
How to pass parameters to a report ? Do you have to register them with AOL?
You can define parameters in the define concurrent program form. There is no need to register the parameters with AOL. But you may have to register the value sets for those parameters.   


  
Total Answers and Comments: 2 Last Update: January 05, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 29, 2005 07:39:38   #1  
Anurag Kehri.        

RE: How to pass parameters to a report ? do you have t...

frist of all you have to register the parameters of your repot in AOL.

setps

1.switch to SYSADMIN responsibility.

2 register the executable navigation is

Concurrent>program>executable

3 register the program for this navigation is

concurrent>program>define

in this form there is a one button <PARAMETER> click and register your

report parameter.


 
Is this answer useful? Yes | No
January 05, 2006 06:15:20   #2  
PRATIK GHOSHAL        

RE: How to pass parameters to a report ? do you have t...

Hi

There is no need to register your parameters.There can be verious different reports and for them you might need to set up thousand of different paramaters how would register them all ?..

Anyways in report builder in design time use user parameter to set up the parameters which you either pass from concurrent program or can be picked up from profile options.

Now when you define your concurrent program to which the report is attached define your parameters. remeber to use concurrent_request_id as one of the user parameters. You do not need to use this mandatory parameter in the define program screen


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : Registering Oracle Reports:  Step 1: Register a concurrent program executable   Navigate to the Define Executable form (AOL Reference manual pg 9-84)   This determines the type of program being run,ie an Oracle Report. ...

Latest Answer : Registration of Form in Oracle Apps indicates that the form can be accessed from Oracle Application Responsibility. For that you have define the following. 1. Define the form 2. Define the function  3. Attach the funtion to the Menu  ...

Latest Answer : No special trigger created in the form when it is registered....the triggers mentioned is created only when one creates the master detail relation ship between two data blocks.....Thanks ,Brajesh ...

The steps are as follows :Design your report.Generate the executable file of the report.Move the executable as well as source file to the appropriate product’s folder.Register the report as concurrent 
Latest Answer : STEP- ONE: Register the application.   STEP-TWO:   Put Report in appropriate server directory.           STEP-THREE:         Define Executables. (NavigatoràConcurrentàProgram ...

There are five report trigger :· Before Report· After Report· Before Parameter Form· After Parameter Form· Between PagesThe Firing sequence for 

What are Autonomous transactions ? Give a scenario where you have used Autonomous transaction in your reports ?
An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or 

The steps to register concurrent programs in apps are as follows :· Register the program as concurrent executable.· Define the concurrent program for the executable registered.· Add 
Latest Answer : The steps which are mentioned above are correct.Those are the steps one need to follow to register their concurrent program.Regards,Arun Reddy. ...

You can define parameters in the define concurrent program form. There is no need to register the parameters with AOL. But you may have to register the value sets for those parameters.    
Latest Answer : Hi,There is no need to register your parameters.There can be verious different reports and for them you might need to set up thousand of different paramaters, how would register them all ?..Anyways, in report builder in design time, use user parameter ...

Yes ! you have to register the feeder programs as concurrent programs to Apps.     
Latest Answer : Yes ! you have to register the feeder programs as concurrent programs to Apps. ...

There are two ways to use Flexfields in report. One way is to use the views (table name + ‘_KFV’ or ’_DFV’) created by apps, and use the concatenated_segments column which holds 
Latest Answer : Can use fnd.flexsql for retreiving data from the flex-fields in the report using lexical reference. ...


 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
 

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&rsquo; 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
 

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
 

Working with XML in Oracle

Working with XML in Oracle Introduction to XML Extensive markup language is the language which presents data in a human readable form of text The data can be anything from a purchase order or a stock quote or weather radar or a flight schedule it can be represented using XML XML is very similar to H
 

What is Oracle Net Service

Oracle Net Services provides enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services eases the complexities of network configuration and management, maximizes performance, and improves network diagnostic capabilities. Oracle Net, a component
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape