Interview Questions Answers in Oracle Forms Reports, Oracle Apps Technical

Questions / { kothaswarna }

Questions Answers Category Views Company eMail

Answers / { kothaswarna }

Question { 3343 }

what is procedure like symbols of bind and lexical

Answer

Bind parameters has symbol as = :

Lexical Parameter has symbol as = &

Is This Answer Correct ?

2 Yes

1 No

Question { 3741 }

can u call procedure or function is sq l query in reports

Answer

We can call the Function in the sql query in reports but
not the Procedure.

Is This Answer Correct ?

3 Yes

0 No

Question { 3426 }

based on parameter value layout of report should change

Answer

Based on parameter value the layout of report should change
this can be done by writting the logic in the Format
Trigger.

Is This Answer Correct ?

1 Yes

0 No

Question { IBM, 18197 }

difference between place holder and formula column

Answer

The Place holder column is the column where we can define
the global variable and this variable is used in the
Formula columns for different calculations.

The formula column is used for the calculation of the
required logic for the report.

Is This Answer Correct ?

27 Yes

5 No

Question { 3879 }

can my report have different layouts

Answer

Yes report can have different layouts by clicking the
additional layout icon present in the Layout wizard

Is This Answer Correct ?

4 Yes

0 No

Question { Satyam, 6150 }

how we can validate the run-time parameters in reports 6i

Answer

By using the Validation Triggers we can Validate the run-
time parameters in reports 6i

Is This Answer Correct ?

4 Yes

0 No

Question { GE, 5528 }

How can you create Lexical parameter n Bind parameter in
Reports ?

Answer

we can create lexical parameter & bind parameter in the
report in the data model query.
The bind parameter is used as well and lexical parameter
used for ex:

select &deptno,ename,deptno from emp where empno=:empno

Is This Answer Correct ?

4 Yes

2 No

Question { GE, 11203 }

What is the use of Validation triggers in Reports?

Answer

The Validation Triggers are used to validate the data
entered int the parameter form.
If the parameter is having the number format and if the
varchar2 is entered then to restrict such situations the
VAlidation Triggers are used.

Is This Answer Correct ?

12 Yes

0 No

Question { Convergys, 6338 }

What is the usage of the confine mode in Layout Editor ?

Answer

There are 2 modes in Layout Editor .
They are 1) Confine Mode 2) Flex Mode
1) Confine Mode :- If the Confine Mode is ON then the
repeating frame can not be moved.
If the Confine Mode is OFF then the repeating frame can be
moved outside the frame.

2) Flex Mode :- If the Flex Mode is ON then the repeating
frame can be moved out.
If the Flex Mode is OFF then the repeating frame can not be
moved outside the frame.

Is This Answer Correct ?

8 Yes

8 No

Question { TCS, 36027 }

What is the Lookup's and what is the use of lookup's?

Answer

Lookups are the tables where the client expected format is
found.
For example if we get the data like 'PROJECT MANAGER' and
the client wants that in the 'project manager' then these
lookups are used.

Is This Answer Correct ?

8 Yes

20 No

Question { 7381 }

WHAT IS USE OF APPS API?

Answer

API's are the Application Programmin Interface ,it means
that these API play a role in transferring the data from
the stagging tables to the base tables once they are fired.

Is This Answer Correct ?

1 Yes

3 No

Question { IBM, 7597 }

I am insert in data to a table X .Which one is better while
writing commit statement
After each row inset or after all row insert to table.

Answer

I think its better to use the savepoint when ever u want to
save till the specific insert.

Is This Answer Correct ?

2 Yes

1 No

Question { IBM, 9107 }

While registering the concurrent program we first do the
executable concurrent program and then define it .
So why we need to give the application name twice in
executable and as well as definitions

Answer

We give the Application names twice because the application
in given in the Executable shows where the execution file
is placed & the Application given in the concurrent program
gives the information from which application the program is
going to run.

Is This Answer Correct ?

14 Yes

3 No

Question { 5388 }

how can u find the status in po?

Answer

We can find the status in the Authorization_status column
as either Approved or In Process etc.

Is This Answer Correct ?

2 Yes

0 No