Sure Apps
Welcome
Home
Login/Register
FAQs
Sql
Pl/Sql
Reports
Forms
Oracle Apps
Learn
Sql
Pl/Sql
Reports
Forms
Oracle Apps
Commands
Sql
Pl/Sql
Reports
Forms
Oracle Apps

Oracle Reports: Frequently Asked Questions

List all Questions.
1 What is a frame in a report layout model?
A. Frames are used to surround other objects and protect them from being over written or pushed by other objects. For example, a frame might be used to surround all objects owned by a group, to surround column headings, or to surround summaries.

2 How many parameters are there in the report?
A. 1. SYSTEM PARAMTER.
2. USER PARAMETER:- Two Types
(a) Bind variable
(b) Lexical Parameter - Starts with & like &EMPNO.
Lexical parameter can be avoid by using Ref CURSOR.

3 How many Modes are in Report?
A. 1. CONFINE MODE. If Confined mode is On then child field can not move out from Parent. If it is Off then can move.

2. FLEX MODE. If flex is On then parent borders "stretch" when child objects are strech. If it is Off then parent borders remain fixed when child objects are moved against them.

4 What is the difference between the POST and COMMIT.
A. POST makes temporary change and COMMIT makes permanent change.

5 What is a repeating frame?
A. Repeating frames surround all of the fields that are created for a groupís columns. The repeating frame prints once for each record of the group.

6 What is the execution style of Report?
A. 1. Before Parameter Form
2. After Parameter Form
3. Before Report
4. Between pages
5. After report

7 How to execute a Report from a Report?
A. With SRW.RUN_REPORT package.

8 How to Print a message in a Report?
A. With SRW.MESSAGE package.

9 What is an Anchor?
A. To determine the vertical and horizontal positioning of a child object relative to its parent. The end of the anchor with a symbol on it is attached to the parent object.

10 What is a FORMULA column?
A. In Formula Column we define our own formula.

11 What is a SUMMARY Column?
A. In Summary Column there are pre defined formulae.

12 What is a Place Holder column?
A. Place Holder holds the given values for a certain datatype.

13 Which one is the faster among Formula, Summary and Place holder columns?
A. Formula Column is faster then Summary Column and then Place Holder.

14 What is a Data Link?
A. We use it to define relation between queries. The child query returns records for the correxponding record in master query.

15 How many types of columns are there in Reports and what are they?
A. Formula Column, Summary Column and Place Holder Column.

Click here for more...
Ask A Question
DisclaimerContact UsPrivacy Policy