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)

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

in GL module specifing org_id or not?

1 Answers  

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

---

what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,

---

---

how can u link a org-id with a responsibility in reports?

2 Answers   TCS,

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---

wht is the use of Xml reports over reports6i?

5 Answers  

---

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,

---

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,

---

is it possible to run the interface without using oracle apps?

2 Answers   Accenture,

---