1. What is use of APPCORE library?
The APPCORE Contains packages & procedures for forms to support menu, toolbar and other standard behaviours.
2. What is use of APPDAYPK library?
The APPDAYPK library contains the packages that control the Oracle Applications Calendar feature. The calendar (or the date picker) is a utility that oracle apps provide to pick the dates for a date type field.
3. What is use of FNDSQF library?
It contains the routines for handling Message Dictionary, felxfields, prpfiles, concurrent processing, mulicurrency, WHO etc.
The APPCORE Contains packages & procedures for forms to support menu, toolbar and other standard behaviours.
2. What is use of APPDAYPK library?
The APPDAYPK library contains the packages that control the Oracle Applications Calendar feature. The calendar (or the date picker) is a utility that oracle apps provide to pick the dates for a date type field.
3. What is use of FNDSQF library?
It contains the routines for handling Message Dictionary, felxfields, prpfiles, concurrent processing, mulicurrency, WHO etc.
4. Which are the Oracle forms triggers which should not be modified?
Following are some of the form triggers that must not be modified.
CLOSE_THIS_WINDOW,
CLOSE_WINDOW,
EXPORT,
FOLDER_ACTION,
KEY-COMMIT,
KEY-EDIT,
KEY-EXIT,
KEY-HELP,
LAST-RECORD,
MENU_TO_APPCORE,
STANDARD_ATTACHMENTS,
WHEN-WINDOW-CLOSED,
WHEN-FORM-NAVIGATE,
ZOOM .
5. Where does the FMB files(Forms source code) reside in Server? or What is the location of .FMB files in a server?
$AU_TOP/forms/US
6. What is template form?
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.
Navigation for this Template form is:
$AU_TOP/FORMS/US/TEMPLATE.fmb
7. What is use of custom library?
Custom.pll is used to implement any new pl/sql code that you would need to write in customizing forms.
8. Name the directories where you have to copy your Fmb and Fmx files?
FMB has to be placed on $AU_TOP/forms/US and FMX has to be placed in the custom top!
9. What are the steps you have to follow to register a Form?
ftp the form (.fmx) to $CUSTOM_TOP/forms/US folder in server.
ftp the form (.fmb) to $AU_TOP/form/US folder (not mandatory but fmb's are kept in this location)
add form to a function
Add this function to menu/submenu
Assign responsibility to this menu/submenu
And add this responsibility to the user.
10. Why are views used in the data blocks of a standard form instead of mapping directly into the base tables?
Because base tables have huge amount of data due to 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.
Other Articles Related To Oracle Forms:
Following are some of the form triggers that must not be modified.
CLOSE_THIS_WINDOW,
CLOSE_WINDOW,
EXPORT,
FOLDER_ACTION,
KEY-COMMIT,
KEY-EDIT,
KEY-EXIT,
KEY-HELP,
LAST-RECORD,
MENU_TO_APPCORE,
STANDARD_ATTACHMENTS,
WHEN-WINDOW-CLOSED,
WHEN-FORM-NAVIGATE,
ZOOM .
5. Where does the FMB files(Forms source code) reside in Server? or What is the location of .FMB files in a server?
$AU_TOP/forms/US
6. What is template form?
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.
Navigation for this Template form is:
$AU_TOP/FORMS/US/TEMPLATE.fmb
7. What is use of custom library?
Custom.pll is used to implement any new pl/sql code that you would need to write in customizing forms.
8. Name the directories where you have to copy your Fmb and Fmx files?
FMB has to be placed on $AU_TOP/forms/US and FMX has to be placed in the custom top!
9. What are the steps you have to follow to register a Form?
ftp the form (.fmx) to $CUSTOM_TOP/forms/US folder in server.
ftp the form (.fmb) to $AU_TOP/form/US folder (not mandatory but fmb's are kept in this location)
add form to a function
Add this function to menu/submenu
Assign responsibility to this menu/submenu
And add this responsibility to the user.
10. Why are views used in the data blocks of a standard form instead of mapping directly into the base tables?
Because base tables have huge amount of data due to 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.
Other Articles Related To Oracle Forms:
- How To Find Last Query Executed On The Oracle Form | Oracle Forms Interview Questions.
- How To Find Oracle Forms(fmb/fmx) Version
- Oracle Forms 6i Tutorial
- Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-2
- Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-3
- Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-4
COMMENTS