Answer Posted / amit shrivastava

Delete from table where rowid not in (select max(rowid)from
table group by column_name);

Delete from table T1 where rowid < (select min(rowid) from
table T2 where T1.emp_name=T2.emp_name);

What do you understand by soa?

1163

---

Do you know what are user profiles in apps. Any examples you can give?

1097

---

How is choreography different from orchestration?

1140

---

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

2887

---

Tell me where we find the status of order information?

1140

---

Which oracle apps version you are very confident in?

1215

---

In oracle application how do you debug or trace errors?

1125

---

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

3483

---

what are the prerequisites for costing transactions?

3144

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2222

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1123

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2229

---

Tell me how to find the custom directory in front end?

1111

---

How can a process be deployed in soa?

1276

---

What are the different components you should consider while defining a responsibility in oracle apps?

1087

---