Answer / mirza moinuddin

IN Built There are 5 triggers
1.Befor parameter form trigger
2.After parameter form trigger
3.befor report trigger
4.between pages
5.after report.

other than that.
To Format our output
1.Format trigger
2.validation trigger
3.action trigger

Answer / shaikshavali

In report builder we have
1.Group-filter trigger
2.Format trigger
3.Validation trigger
4.Action trigger
5.Report trigger

Additionally in report triggers we have
1.Before parameter form trigger
2.After parameter form trigger
3.Before report trigger
4.Between pages trigger
5.After report trigger.

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,

---

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

---

What is the package?

2 Answers  

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

Can function be overload?

4 Answers  

---

What are documents and test cases u followed.

2 Answers   Accenture,

---

what is organization id

2 Answers   Wipro,

---

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  

---

how to move the one file from one instance to another instance?and ur scripts also?

1 Answers   KPMG,

---

What is the interface?

3 Answers  

---

what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,

---

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

1 Answers   Satyam,

---