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 is an oracle report? List its various types.

918

---

What is a canvas in oracle forms?

1008

---

What do you understand by oracle forms?

975

---

Explain the various types of oracle report?

1025

---

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

1984

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2251

---

from where do u receive the information to develop report

1957

---

what are the oracle forms services components include?

959

---

what is oracle forms?

1063

---

what are the new features introduced in oracle form services in 11g release 2?

981

---

In what sequence do triggers get fired by oracle forms?

913

---

Explain the different levels at which oracle form services interact.

1002

---

What do you understand by lov and how can it be used?

1013

---

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

2858

---

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

1931

---