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.

how do you describe O2C along with tables

2774

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1067

---

What is a flexfield? List out its types.

1173

---

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

2617

---

What is instead of trigger in where we will use?

1178

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2133

---

please send me forms, xml pulisher questions,answers

2113

---

List the various types of value set.

1082

---

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

2266

---

Which oracle apps version you are very confident in?

1214

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2048

---

How do you register report in oracle apps?

1099

---

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

1125

---

What do you understand by soa and what are the benefits of using this architecture?

1091

---

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

12292

---