Answer Posted / lokanatha reddy

Using RUN_PRODUCT Built in we can call a Report from a Form.
It will take 7 Parameters as follows
1) Product name :: REPORT/GRAPHICS
2) Module name :: Report name
3) Communication Mode :: Synchronous /Asynchronous
SYN :: we cannot work with the Form until and unless you
closes the Report.
Asyn:: We can work with Form & Reprot (Navigate)

4) Exec :: Batch/Run time
Batch :: it will fetch all records at a time
Run time :: It will fetch only one Record at a time
5) File name :: database/Filesystem
6) Parameters :: Report Parameters
7) Display :: For Graphics (Mostly null)
Ex :: If i have :p_deptno parameter then we can call as
Follows
RUN_PRODUCT
('REPORT','C:\TEST1.rep',SYN,BATCH,DATABASE,p_deptno,' ');

In what situation u create the BPA.

2147

---

Explain the different levels at which oracle form services interact.

998

---

what is tripstop report?

1755

---

how to send file attachment from oracle forms

2486

---

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

2940

---

What do we mean by record group in oracle forms?

1021

---

how do u place it in required folder

1861

---

What is an SQL FORMS ?

2714

---

Is it possible to execute a dynamic sql from forms?

1021

---

can you convert or reverse engineer a fmx back to a fmb file?

1086

---

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

1928

---

what is oracle forms?

1054

---

did u received a single file or multiple files

1965

---

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

976

---

Explain how can you use the same lov for 2 columns?

1074

---