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)

in reports token is casesensitive or not?

2 Answers  

---

what is inbound and outbound interface?

2 Answers  

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---

Give a brief overview on OrderManagement.

1 Answers   Zensar,

---

why do we go for oracle apps technical other than sap and other packages?

2 Answers  

---

---

where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  

---

While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,

---

What are the User PARAMETERS in the Reports?

6 Answers   Accenture, CTS,

---

What is the interface?

3 Answers  

---

please explain open interface import

2 Answers  

---

What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---