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.

List the types of flexfield?

782

---

In oracle application how do you debug or trace errors?

849

---

How do you register report in oracle apps?

850

---

What do you understand by a set of books?

820

---

testing tools?

1951

---

Can u give the Documentation of Custom.pll in oracle apps

3215

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2746

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2361

---

what is pay run id ?

1900

---

Can you explain the difference between architecture followed in 10g & 11g?

851

---

please send me forms, xml pulisher questions,answers

1879

---

What does appl_top directory contain?

848

---

can we get profile values in report without using user exists is it possible how?

2531

---

What is a flexfield? List out its types.

883

---

what are the prerequisites for costing transactions?

2852

---