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.

how do u compile a form i.e .fmb file in Unix or in dos

4616

---

all steps of bitmap report?

2398

---

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

3047

---

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

2064

---

What do you understand by oracle forms?

1115

---

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

1076

---

Is it possible to have multiple layouts in a report?

1089

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1258

---

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

2080

---

did u received a single file or multiple files

2060

---

Explain master-detail relationship with some examples.

1055

---

What is an oracle report?

1122

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2438

---

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

2964

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2334

---