Infolinks

Wednesday 16 May 2012

Oracle Forms Interview Questions & Answers



            Oracle Forms Interview Questions & Answers

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

1.Question :
------------
What is a reference trigger? Can we modify a reference trigger?

Answers:
--------
Only the comment property can be changed for a trigger referenced in the oracle forms.


Triggrer is one type of event which is occure during any dml operation.like insrt,update,delete...etc

2.Question :
------------
What are the triggers we should not modify?

Answers:
--------
Here are the form triggers that must not be changed
CLOSE_THIS_WINDOW, CLOSE_WINDOW, EXPORT, FOLDER_ACTION, KEY?COMMIT, KEY?EDIT, KEY?EXIT, KEY?HELP,LASTRECORD, MENU_TO_APPCORE, STANDARD_ATTACHMENTS, WHEN?WINDOW?CLOSED, WHEN?FORM?NAVIGATE, ZOOM .

3.Question :
------------
Shall we delete exiting triggers?

Answers:
--------
We must not delete the triggers which comes from the Templates.

4.Question :
------------
Name the directory having the FORMS source codes ( FMB files ) ?

Answers:
--------
They will be found in
/App_server/oas01/app/.../11.5.9/prodappl/ar/11.5.0/forms/US/XXXXXXXX.fmx


They (.fmb) r in AU Top's forms/<Language> folder

5.Question :
------------
What is template form?

Answers:
--------
Template Form is a form that is to be used for building a new form and this form references all the standard libraries like(FNDSQF,APPCORE,APPCORE2,APPDAYPK,CUSTOM) which are used to build a form as per the oracle standards.This Template form has been provided by Oracle only.

Navigation for this Template form is:

APPL_TOP/au_TOP/FORMS/US/TEMPLATE.fmb

6.Question :
------------
What is use of custom library?

Answers:
--------
Custom.pll is used to implement any new pl/sql code that you would need to write in customizing forms.

7.Question :
------------
Why we have to create packages instead of procedures / functions?

Answers:
--------
All related procedures and functions required for a particular task are grouped together in a package. Packages have certain advantages -
1. The first time it is referred in your code, it is loaded in memory. For subsequent reads, it reduces the Disk I/O required.
2. Packages improve performance and provide easy maintenance


All related procedures and functions required for a particular task are grouped together in a package. Packages have certain advantages -
1. The first time it is referred in your code, it is loaded in memory. For subsequent reads, it reduces the Disk I/O required.
2. Packages improve performance and provide easy maintenance

&

procedure or function is a special task which is implemented by any program.when Package is set of classes or interface which is contain more information & which is implemented in a program

8.Question :
------------
Name the directories where you have to copy your Fmb and Fmx files?

Answers:
--------
FMB has to be placed on $AU_TOP/forms/US and FMX has to be placed in the custom top!

9.Question :
------------
Can we put all the logic in the trigger?

Answers:
--------
If you are talking about FORMS trigger (event) then NO. You should not keep your logic in the trigger, rather you should right the code in a routine and to be executed based on the trigger event checks.

10.Question :
-------------
What is custom development ?

Answers:
--------
Creating a custom directory in the server like 'XXX_TOP' and creating a directory structure in the Apps server required for implementing completely customized Application like our own forms, reports etc. The above mentioned task may totally called as custom development.

11.Question :
-------------
What are the steps you have to follow to register a Form?

Answers:
--------
ftp the form (.fmx) to resp. tops/forms/us folder

ftp the form (.fmb) to $au_top/form/us folder (not mandatory but fmb's are kept here only)

add form to a function

function to menu/submenu

menu/submenu to the responsibility

responsibility to the user.

12.Question :
-------------
What are the steps you have to follow to register a custom application?

Answers:
--------
1>Register custome application in AOl
2>create a physical director structure under APPL_TOP
3>modify the enviroment file to include custom schema path
4>in the backend register the custom schema as user
5>register the user with aoL
6>add the custom schema to standard data group
7>register all the custom table with the application
8>create synonyms in apps schema for custom objects

13.Question :
-------------
How do you find out the FMB file name?

Answers:
--------
Go to the Help menu on the applications window and select About Oracle Applicaitons.

Under the title Current Form you will get the executable file name (.fmx).

Form path : /............./forms/US/XXXXXX.fmx

The fmb name is XXXXXX.fmb

14.Question :
-------------
What is Form sub function?

Answers:
--------
A subfunction is a securable subset of form functionality.A function executed from with in a form

15.Question :
-------------
How the form sub function is implemented?

Answers:
--------
Mostly through buttons or graphical elements of the form

16.Question :
-------------
What is folder form?

Answers:
--------
Folder form is adjustable form layout where you can change the postion,promt and number of feilds displayed and the default query with which the form has to be opened

17.Question :
-------------
Why we have to maintain the file names in Capital Letter?( Library/FMB)

Answers:
--------
It is not mandatory to maintain the file name in Capital letter. Oracle Apps forms/reports are by default in Capital letter. If you use the Unix version of Ora Apps then it is better to maintain your customized file name in Capital. Since Unix is case - sensitive, during registration of customized forms/reports in Ora Apps 11i there will be problem.

18.Question :
-------------
What is customization?

Answers:
--------
Customisation is changing standard oracle applications functionality to suit business requirements of implementing company

19.Question :
-------------
What is ZOOM?How it works

Answers:
--------
Zoom allows the addition of user-invoked logic on a per-block basis. For example, you may want to allow access to the Vendors form from within the Enter Purchase Order form while the user is in the PO Header block of that form. You can enable Zoom for just that block, and when the user invokes it, you can open the Vendors form. Example code here:--function zoom_available return boolean is form_name varchar2(30) := name_in('system.current_form'); block_name varchar2(30) := name_in('system.cursor_block'); begin if (form_name = 'DEMXXEOR' and block_name = 'ORDERS') then return TRUE; else return FALSE; end if; end zoom_available;


20.Question :
-------------
In one of the Standard Oracle Form(Quoting Form), the Export (File -> Export) functionality is disabled. How can I enable this Export Functionality?

Answers:
--------
Export function is disable when you intial open to the responisibility .that automatically enable when you enter into specific form and you need to export that data.Example :-Login as a Application Developer navigate to Application-->Registerand preess f11 and press ctrl+f11 then you wil get all applicatins now if you want to export all data go to the file and see The function is eabled


21.Question :
-------------
Why are views used in the data blocks of a standard form instead of mapping directly into the base tables?

Answers:
--------
This is because base tables have huge amount of data and because of which if we work directly on the base tables, it will hit the performance. Also, views are simplified versions of the base tables which are easy to understand and hence to work upon.

1 comment: