Interview Question on Oracle Apps

1) Tell me about urself?

2) How did u go about implementing the open item interface?

3) What validation have u performed on this interface?

4) How do u import serialized items?

5) How many segmets were used for this interface?

6) What are the tables involved in this interface?

7) How did u go about implementing the sales tax interface?

8) How many reports have u customized?

9) How did u go about customizing the Journals Line Report?

11 How to register a report in Apps?

12 How many types of value sets are there?

13 If I want to display values like A,B,C , which value set should I use?

13)How do u rate urself in PL/SQL?

14) What is pragma restrict, have u heard about pragma?
Ans Its used to check the purity level of the functions ie. the extent to which the function is free of side effects.

15) Have u written any packages?

======================================================

1) Tell me about urself?

2) Tell me about the bugs in project u have encountered? How do u get bugs?

3) How many forms have u developed?

4) Which version of W.F have u used?

5) What customization have u done in W.F?

6)What did u do in Item Interface table?

7)What all Item Attributes have u populated?
Ans
8)What Item Catageroies have u used?
Ans Purchase and Inventory Items
9)What columns have u used in this interface?

10) What customization have u done in forms?

11) How to register a form?

12) How many triggers have u written in forms?

13) How do u call reports from forms?

14) How do u display messages in forms?

15)How many types of value sets are there?

16) Have u registered any PL/SQL procedures in Apps? How do u go about it?
Ans To use the PL/SQL in apps two out prameteres are mandatory retcode and errbuff
Retcode can have values like 0,1,2
17) How to register a report in Apps?


==========================================================
2) How much do u rate urself in PL/SQL?

3) What is autonoumous transaction?

4) What are Indexes and types of Indexes?
Ans Simple Index, Binary Index and Function Index.
5) What is difference between Primary Key and Unique Key?
Ans Unique key can be null but primary key cannot be null
6) What is Data Dictionary?
Ans Its the meta data about the objects of the database, its the data about data.
7) How do u eleminate duplicate records from the table? (Concept)
Ans Delete from tablename a where rowid>(select min (rowid) from tablename b where a.colname=b.colname);
8)What are the attributes of a cursor?
Ans %isopen, %found, %notfound, %count.
9) What is difference between Delete and Truncate?
Ans Delete keeps the rollback info but truncate doesn't. So rollback the delete statement but truncate cannot be rollbacked.
10) What are the different types of Exceptions?
Ans User Defined exceptions and predefined exceptions
User Defined exceptions are defined explecitly by the user in the declare section and called in the begin section
and the code is written exception section.
Eg]-
Declare
...
myexception exception;
Begin
...
raise myexception;
Exception
when myexception then
PL/SQL code..
End

Predefined exceptions are oracle defined exceptions like no data found, too many rows, invalid cursor, value_error, dup_val on index
11) What is a transaction? How does it end?
Transaction is a series of SQL statements which can be succeeded and failed as a unit.
It ends with commit or rollback.
12) What is DBMS packages? How many of them have u used?
DBMS packages are used
13) What are post functions?

14) What are the different tyes of canvases?
Ans Content, Tab, Stacked, Horizontal toolbar, Vertical toolbar
15) Difference between pre querry and post querry?
Ans pre querry fires before the querry is executed and post querry is fired after the querry is executed
16) What are the different SRW packages?
Ans SRW.Reference, SRW.Userexit, SRW.Runreport, SRW.SetAttr, SRW.Getpagenum,SRW.Message.....
17) How do u define SRW.message?
Ans SRW.message(msg no, msg string);
18) What is an anchor? What are the different types of anchor?
Ans Anchor is an object which is used to attach two different objects like frames to keep its relative position with respect to each other. Types of anchor are horizontal and vertical.
19) What are the types of Master Detail relation? What is isolated MD relation?
Ans Isolated, Non Isolated and Cascade.
Isolated- Master record can be deleted without deleting the detail record.
Non Isolated- Master record cannot be deleted without deleting the detail record.
Cascade- When the master record is deleted the detail record is deleted automatically.
20) What is object group?
Ans Object group is a container for a grooup of objects like canavas, block and window they can be grouped to create an object group
21) What are various block coordination properties?
Ans Immediate, Deffered with autoquerry, Deffered with No-autoquerry
Immediate- When u querry the master record the detail will be automatically querried
Deffered with autoquerry- Unless and Untill u navigate to the detail block it will not be querried.
Deffered with No-autoquerry- U have to explicitlly querry both master and detail block.
22) How to open form from form?
Ans It can be opened from
Call- Existing form is kept in background.
Open- It opens a new form and u can navigate between them.
New- It replaces the orginal form.
23) What are different item level triggers?
Ans pre-text-item, when-new-item-instance, key-next-item, when-validate-item, post-text-item.
24) What is flex mode?
Ans When the flex mode is on the objects can be moved outside its parent frames( across frames)
25) What is the difference between key-next-item and post-item?

26)How do u used DDL in forms?
Ans Forms_DDL, Exec_SQL
Forms_DDL:- Only database the database u are connected to
Exec_SQL:- Another database, and u can also call non-oracle procedure.
27)What is are record groups?
Ans Its a internal oracle forms datastructure, which can be used in LOV's to populate the querries at runtime.
Types:-
Querry record group:- Querried from the database
Non querry record group:- its created and changed programmatically
Static querry record group:- Harcoded values
28) What is property class and visual attributes?Whats the difference?
Ans Property class is a named object that consist of a list of properties and their setting, it cannnot be changed programatically.
Visual Attributes are properties like fonts, colours, patterns for forms and menu object, it can be changed programatically
29) What are different report triggers and give the order of execution?
Before Parameter trigger
After Parameter trigger
Before report trigger
Between Pages trigger
After report trigger
30) Different types of reports?
Form like
Tabular
Group above
Group left
Maliling lablel
Matrix
Form letter
Matrix with group
31) What is matrix report?
Ans Its a cross tab report.
It contains four groups they are:-
Cross product
Column
Row
Cell value
32) How to call report form a form?
Run_product
33) Different types of parameters in report?
User Parameter and System parameter
System paramters:-
Destype
Desname
Desformat
Decimal
Copies
Currency
Background
Mode
Orientation
Printjob
Thousands
34) What is lexical parameter, bind parameter and user exit?
Ans
35) How do u define paramteres in Concurrent Request?
Ans
36) What are profiles? What is its order?
Ans Its a set of changable options which define a behavior of ur application
Its order in sense of Generic is
Site, Application,Resposibility and User

37) What are different value sets?
Ans Independent, Dependent, Pair, None, Translate Independent, Translate Dependent, Special, Table
38) What is custom.pll? What does ZOOM do?
Ans Its a library used in forms which can be used for customization purpose. It contains the procedure
Style, Event and Zoom
Zoom is used to call another form from a form.
39) What is DFF and KFF?

Related Articles to Read