Forms Reports Questions And Answers

1⟩ Explain the Restricted and unrestricted procedurein 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.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

161 views

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.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

116 views

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.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

135 views

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;

Is this answer helpful? 0 Yes | 0 No

Answer This Question

145 views

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;

Is this answer helpful? 0 Yes | 0 No

Answer This Question

123 views

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.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

115 views

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.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

158 views

8⟩ 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

Is this answer helpful? 0 Yes | 0 No

Answer This Question

151 views

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

Is this answer helpful? 0 Yes | 0 No

Answer This Question

131 views

10⟩ 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"

Is this answer helpful? 0 Yes | 0 No

Answer This Question

134 views

11⟩ 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.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

142 views

Forms Reports

Home Oracle Forms Reports

11 Forms Reports Questions And Answers

1⟩ Explain the Restricted and unrestricted procedurein Forms And reports and example as well?

2⟩ How to create the triggers in the forms?

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

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?

5⟩ How to call a report from Forms?

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

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

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

9⟩ How to restrict a parameter list with parameters?

10⟩ How to hide the report in Apps?

11⟩ How to call a URL from a menu using Oracle Forms 6i?

Quick Links:

Forms Reports

Home Oracle Forms Reports

11 Forms Reports Questions And Answers

1⟩ Explain the Restricted and unrestricted procedurein Forms And reports and example as well?

2⟩ How to create the triggers in the forms?

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

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?

5⟩ How to call a report from Forms?

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

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

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

9⟩ How to restrict a parameter list with parameters?

10⟩ How to hide the report in Apps?

11⟩ How to call a URL from a menu using Oracle Forms 6i?

BE THE FIRST TO KNOW

Quick Links: