Registering parametric report?



Registering parametric report?..

Answer / niranjan

Any applications will have two parameters,
1) from-period 2) to-period
a) Go to object navigator and create the parameters.
User parameters  from_no, to_no (data type
char and width 30)
b) Open the report layout and write the query(we have
to reg the table in AOL)
Select empno,ename,from g_emp where empno between
:from_no and to_no
c) Compile and put the .RDP file in the server directory.
d) Registering in AOL.
Concurrent  executable
Concurrent  program then go to ?PARAMETERS?
e) Go to Application  validation set. then go to
?EDIT INTO?
After entering the VALUE SETS (1) And TOKENS (2)
f) Go to Administrations
Sequrity  responsibility  Request
h) Add and assign a concurrent program to a request group

Q) HOW DO YOU RECTIFY THE ERRORS IN INTERFACE TABLES?
Depending on the naming convention used, errors appear in
either alphabetical order or by error code number.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,


How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  


What is an Index , Types od index why we are use index.

2 Answers   IBM,


what is MRC? Why it is needed?

4 Answers   Convergys,


What are the different components of soa suite?

0 Answers  






link between po and ap modules

5 Answers   ERP Solutions,


in which table sub inventory related information for item is stored?

3 Answers   chain sys, Scan Steel,


what is organization id

3 Answers  


When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,


Can we create tables in apps schema?

0 Answers  


what is the data type of lexical parameter?

5 Answers   Wipro,


how can we get odd numbered pages in output of a report

2 Answers   Infosys,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)