Answer Posted / sudipta santra

This is the way how to display the page number.

SRW.GET_PAGE_NUM (page_num);

Description: This Function returns the current page number.
This is useful when you want to use the page number in the
field's Format Trigger property.
Syntax:
SRW.GET_PAGE_NUM (page_num);
Parameters:
page_num: Is the variable in which you want to place the
current page number.
Returns: The current page number variable into the boiler
plate text item in the report.

What is responsibility and how u attach How to create user and how u attach with responsibility.

1985

---

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

1016

---

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

1983

---

What is a canvas in oracle forms?

1004

---

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

1930

---

What is the difference between flex mode and confined mode?

986

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2061

---

Explain the various types of oracle report?

1024

---

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

2857

---

Explain master-detail relationship with some examples.

946

---

Explain the different levels at which oracle form services interact.

1001

---

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

---

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

2240

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1848

---

what are the oracle forms services components include?

956

---