Report Interview Questions-1

 Types of reports Layout

-------------------------

1.Tabular

2.Group above

3.Group below

4.Matrix

5.Matrix with Group

6.Form

7.Form Letter

8.Mailing Lable

Oracle Reports (.RDF):

-----------------------------  

1) Develop .rdf as per client requirement

2) Transfer .rdf from local machine to server (Custom top/12.0.0/report/US)

3) Define executable (EM:- Oracle Reports)

4) Define concurrent program

5) Attach concurrent program to Request group

6) Change Responsibility (PO US RESP SANDEEP)

7) Run concurrent program through SRS window

Confine mode & Flex Mode

--------------------------

Confine Mode:ON: Child objects cannot be moved outside their enclosing parent object. OFF:Child objects can be moved outside their enclosing parent object. 

Flex Mode:ON:Parent borders "stretch" when child objects are moved against them. OFF:Parent borders remain fixed when child objects are moved against them.

Standard for oracle reports

----------------------------------

1) Create user parameter called “P_CONC_REQUEST_ID"

It is the bridge between oracle apps and report builder. To get REQUEST_ID

2) Call user exit in before Report trigger

SRW.USER_EXIT(‘FND SRWINIT’);

It is used to initialize the profile values

3) Call user exit in After report trigger

SRW.USER_EXIT(‘FND SRWEXIT’);

It is used to deallocate the memory which occupied by profiles

(SRW: Sequel report writer)

Sequence of Report builder triggers:

------------------------------------------

1) Before parameter form

2) After parameter form

3) Before report

4) Between pages

5) After report

What is an implicit anchor and how is it different from an explicit anchor in a report builder?

------------------------------------------------------------------------------------------------

An anchor is used to determine the position of an object in horizontal and vertical directions.

This position of an object will always be relative to the position of the other objects, 

which can be called parent objects for these child objects.

What is lexical reference?How can it be created?

-------------------------------------------------------

Lexical reference is place_holder for text that can be embedded in a sql statements. 

A lexical reference can be created using & before the column or parameter name.

What is bind reference and how can it carate?

---------------------------------------------------

Bind reference are used to replace the single value in sql,pl/sql statements 

a bind reference can be careated using a (:) before a column or a parameter name.