Answer Posted / satbir

There are five types of trigger in Oracle Reports

Before Parameter Form
Fires before the Runtime Parameter Form are displayed. Can
access the PL/SQL global variables, report level columns
and manipulate accordingly.

After Parameter Form
Fires after the Runtime Parameter form are displayed. Used
to validate the parameter values.

Before Report
Fires before the report is executed but after the queries
is parsed and date is fetched.

Between Pages
Fires before each page of the report are formatted, except
the very first page. This page is used to customize page
formatting.

After Report
Fires after the report previewer are exited, or after
report output is sent to a specified destination.

What do you understand by oracle forms?

774

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1787

---

List out the oracle forms configuration files?

782

---

What is an SQL FORMS ?

2485

---

if some data is not transfered where it will get stored

1656

---

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2693

---

How can we generate report output in excel format?

740

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

1783

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1740

---

What are the various configuration files that are used by oracle forms?

763

---

a text item is there what r the different types of triggers associated with it

1678

---

Is it possible to execute a dynamic sql from forms?

791

---

what are the oracle forms services components include?

733

---

How can we expand Parameter Form Canvas on Reports 6i?

2146

---

Explain how one can iterate through items and records in a specified block?

728

---