Forms Reports Interview Preparation Guide
Download PDF

Forms Reports frequently Asked Questions in various Forms Reports job Interviews by interviewer. The set of Forms Reports interview questions here ensures that you offer a perfect answer to the interview questions posed to you. Get preparation of Forms Reports job interview

11 Forms Reports Questions and Answers:

1 :: Explain the Restricted and unrestricted procedure
in Forms And reports and example as well?

Restricted procedure that affects the basic functions of
SQL * Forms and Report
. It cannot used in all triggers except key triggers.
Unrestricted procedure that does not interfere with the
basic functions of SQL * Forms and Reports it can be used
in any triggers.

2 :: How to create the triggers in the forms?

There are three types of triggers:
Form level
Block level
Item level
If you want to validate the values of an Item, usually use
Item level trigger, such as POST-CHANGE trigger.

3 :: What is the use of between page trigers in REPORTS?

In a Report of more than 1 page information. Then BETWEEN
PAGES trigger fire when one move from one page to other
page. In this trigger we can write process which is required
to affect other page values.

5 :: How to call a report from Forms?

DECLARE
pl_id PARAMLIST;

BEGIN
pl_id := CREATE_PARAMETER_LIST('quotation');
IF NOT ID_NULL(pl_id) THEN
Add_parameter(pl_id,'DESTYPE',TEXT_PARAMETER, :DESTYPE);
ADD_PARAMETER(pl_id,'DESFORMAT',TEXT_PARAMETER,:DESFORMAT);
ADD_PARAMETER(pl_id,'DESNAME',TEXT_PARAMETER,:DESNAME);
Add_parameter(pl_id,'MODE',TEXT_PARAMETER, 'BITMAP');
Add_parameter
(pl_id,'untcd',TEXT_PARAMETER,:GLOBAL.G_STRUNITCODE);
Add_parameter
(pl_id,'FYCD',TEXT_PARAMETER,:GLOBAL.G_STRFINYEARCODE);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');

IF :id is not nullTHEN
Run_Product
(REPORTS,PLANDETAIL.rep',SYNCHRONOUS,RUNTIME,FILESYSTEM,
pl_id, NULL);
DESTROY_PARAMETER_LIST(pl_id);
END IF;
end if;
end;

6 :: How many types of trigger can be used in a table at a time?

We can define a trigger
1. For Each Row
2. For Each Statement

You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE

So it makes a total of 12.

7 :: When to use Place holder columns in Oracle Reports and what is a place holder column?

place holder columns are like global variables in the reports.

Variables declared in the PL/SQL code they cannot be the source of the field. So, if we assign the variables to placeholder columns they can be the source of the field since they are global variables.

8 :: How to hide the report in Apps?

We cannot hide the program in concurrent program window at
the most u can diable it and u can hide the report in the
SRS by "uncheck use in SRS chkbox"

9 :: What is the exact navigation to create a radio button in form6i?
can we create the radio button in report6i?

Just create a radio button on the GUI part means layout
editor(i.e on canvas) then n then the form will prompt you
to create radiogroup under which this radio button will
reside. U just give name the radio group then give name the
radio button. After that U have to go object navigator and
select the property of the radiogroup then set the default
value , oter value thats all.

In report we can't create radio button

10 :: How to restrict a parameter list with parameters?

The Restrict List to Predetermined Values is a checkbox
that indicates whether a value for the parameter must be in
the list of values. For example, if you check Restrict
List to Predetermined Values and the Initial Value does not
match a value in the list of values, an error will be
generated when you accept the Parameter property sheet.
Similarly, if you set a value for the parameter on the
command line or in a command script and it does not match a
value in the list of values, an error will be generated
when the report is run. If you check Restrict List to
Predetermined Values, a list of values will appear in the
runtime parameter form. If you do not check it, a combo
box will appear (i.e., you can enter values as well as
select from the list).