Behavioral Forms Reports Interview Questions & Answers:

1. How to call a URL from a menu using Oracle Forms 6i?

With use of the built_in named
Web.Show_Document('https:www.google.com',_blank);

This like you can do.

2. 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).

3. 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

4. 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"

5. 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.

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. 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;

8. 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;

9. 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.

10. 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.