Answer Posted / 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.

tell me the scenarios of the independent in reports

2658

---

Do you know what are user profiles in apps. Any examples you can give?

1140

---

How to create a purchase order without a requisition?

1254

---

What do you understand by a set of books?

1154

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2264

---

What are the Standard Reports and Forms in HRMS?

2379

---

Which oracle apps version you are very confident in?

1256

---

How to move the one file from one instance to another instance? And your scripts also?

1173

---

how do you describe O2C along with tables

2834

---

What are do's and dont's of Interface?

2474

---

how to print multi lay outs,muti currency,muti language in xml publisher

12394

---

please send me forms, xml pulisher questions,answers

2160

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3734

---

What do you understand by concurrent programs?

1146

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2312

---