What are the User PARAMETERS in the Reports?
- 6 Answers
- 15160 Views
- Accenture, CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vasu
Whenever you need to change the query value at runtime then
create a parameter which reads the value during run time.
In this scenario which you are creating the parameters are
known as user parameters.
eg: create a sql query as below:
select * from emp where deptno=:p_deptno
Then system creates a parameter named p_deptno. This bind
parameter is a user parameter.
Run the report, During run time system expect the deptno
value from the user.
I hope you understood.
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / pr@$@d.
Good Eplanation V@$u.
User paramters created by user according to thier needs.
Those we call it as bind variable in report it will be
prefix with :var1 like that.
We can refer Vasu Explanation.
Regards,
-Prasad.
Regards,
-Prasad.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / pulla.reddy@oracle.com
Hi Prasad,
Muneer answer is correct according to question.
Good explanation from vasu.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / siva
when ever u create a bind parameter in select statement
it tends to user parameter
| Is This Answer Correct ? | 1 Yes | 0 No |
What is Summary columns?
what is the difference between request group and request security in oracle apps?
what are the receipt types in Po?
What is set function in sql .E.g.What is difference between union and union all
explain registration steps of a concurrent program.
When loading data from staging table to interface table , how to reload the invalid record once again ?
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
How to know the number of invoices generated for one PO from front end (navigation)?
what are the steps to develop a new report?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
Can you have two stored functions with in the same name?
where we will put the control file ,where we will run sql star loader what is the cmd?
Oracle Apps Technical 
