Interested to Buy Any Domain ? << Click Here >> for more details...
What are the User PARAMETERS in the Reports?
- 6 Answers
- 17492 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 |
In a Standard form a DFF is disable?How we can Enable it?
What is template?
what is inbound and outbound interface?
Do you know what is applysys in oracle application database schema, what is apps?
In one flat file i got headers and lines data how you can write control file now ?
what is lexical parameter?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
What are Mandatory triggers to write in the block, which is created on view?
Do you know where we can check the status of po?
What are basic steps for AIM?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
Oracle Apps Technical 
