Forms Reports Interview Preparation Guide
Prepare comprehensively for your Forms Reports interview with our extensive list of 11 questions. Our questions cover a wide range of topics in Forms Reports to ensure youre well-prepared. Whether youre new to the field or have years of experience, these questions are designed to help you succeed. Access the free PDF to get all 11 questions and give yourself the best chance of acing your Forms Reports interview. This resource is perfect for thorough preparation and confidence building.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.
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.
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.
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.
4 :: Suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?
T1's Post-text-item trigger
:textT2 := :textT1;
:textT2 := :textT1;
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;
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.
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.
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"
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
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).
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).