Answer / ashok

Through NVL function.

select * from FND_User a
where user_name = nvl(:User_Name, a.user_name)

Answer / ahmed mazen

select * from fnd_user a
where (a.user_name = :user_name or :user_name is null)

explain registration steps of a concurrent program.

1 Answers   TCS,

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

which parameters passed in report in oracle developer how to pass

3 Answers  

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

Registering parametric report?

1 Answers  

---

Which is the best website to learn Oracle Apps?

2 Answers  

---

What is Place holder Columns?

3 Answers  

---

Can u define exceptions twice in same block?

3 Answers  

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

---

how to initialize applications?

2 Answers  

---