Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-1

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. 

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:
  1. How To Find Last Query Executed On The Oracle Form | Oracle Forms Interview Questions.
  2. How To Find Oracle Forms(fmb/fmx) Version
  3. Oracle Forms 6i Tutorial
  4. Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-2
  5. Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-3
  6. Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-4

COMMENTS

Name

Account Payables,1,Advance Table In OAF,1,AME,1,AOL Concepts,19,AP Holds,1,Apps Initialization,1,Blanket Purchase Orders,1,Blanket Releases,1,Careers,9,Common Errors and Solutions,2,Concurrent Programs,10,Contract Purchase Orders,1,Corporate Culture,3,Corporate Ladder,3,Customer Interface,3,Customization,1,De-Normalization,1,EAM,1,EBS Tutorials,10,Education,16,Emterprise Asset Management,1,English,1,Enterprise Asset Management,1,Entrepreneur,1,Error Fixes,1,Executables,2,Extension,1,fnd_user,1,FNDLOAD,1,Global Agreements,1,Guest Posts,7,Handy Scripts,63,Health Tips,1,Important Apps Queries,1,Infographic,3,Interview Preparation,62,Interview Q/A,68,Inventory Org ID,1,Iproc,4,Iprocurement,4,IT,3,jDeveloper,1,Job Search,1,Key Tables In Oracle Apps,5,Learning English,1,MDS,1,Metadata Tables,2,Multi Org Architecture,2,Normalization,1,O2C,1,OAF Interview,50,OAF Personalization,1,OAF Tutorials,52,Operating Unit,1,Oracle 10g,1,Oracle 11g,1,Oracle Access Manager,1,Oracle ADF,1,Oracle Alerts,2,Oracle AP,12,Oracle Apex,1,Oracle APIs,4,Oracle Application Object Library,19,Oracle Applications,10,Oracle Approvals Management,1,Oracle Apps,4,Oracle Apps DBA,2,Oracle Apps Interviews,36,Oracle Apps Tips,9,Oracle Apps Tutorials,98,Oracle AR,18,Oracle Assets,2,Oracle BAM,1,Oracle BI Publisher,1,Oracle BPEL,1,Oracle BPM,1,Oracle Dabase Structure,2,Oracle Database Architecture,2,Oracle Database Key Tables,3,Oracle EAM,2,Oracle EBS,5,Oracle Financials,2,Oracle Forms And Reports,17,Oracle Forms Interview Questions,6,Oracle Forms Tutorials,6,Oracle GL,4,Oracle Holds,1,Oracle HRMS,10,Oracle Human Resources,1,Oracle Inventory,4,Oracle Payables,1,Oracle Payroll,1,Oracle POTutorials,1,Oracle Purchasing,7,Oracle Reports Interview,9,Oracle Reports Tutorials,3,Oracle SOA,1,Oracle System Administrator,4,Oracle Workflow,4,Order Management,2,Organization ID,3,Organizations,3,Performance Tuning,2,Personalization,1,PL/SQL Block,1,PL/SQL Interview Questions,11,PL/SQL Scripts,44,PL/SQL Tutorials,53,Planned Purchase Orders,1,PO,1,PO Action History,1,PO_ACTION_HISTORY,1,POracle Purchasing,1,PR,1,Procedures And Functions,2,Profile Options,2,Purchase Orders,1,Purchase Requisition,2,Receipts,1,Request Groups,1,Responsibility,1,Shell Script,1,SOA Tutorials,4,Social Media,1,Software Industry,2,Software Tools,1,SQL And PL/SQL Interview,38,SQL Interview,52,SQL Scripts,38,SQL Tutorials,43,Standard Purchase Orders,1,Troubleshooting,1,Unexpected error,1,Unix/Linux Commands,3,User,1,Value Sets,1,Weblogic,1,XML Publisher,4,
ltr
item
Oracle Apps Guy: Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-1
Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-1
Oracle Apps Guy
https://www.oracleappsguy.com/2011/07/oracle-forms-interview-questions.html
https://www.oracleappsguy.com/
https://www.oracleappsguy.com/
https://www.oracleappsguy.com/2011/07/oracle-forms-interview-questions.html
true
4186973960539901882
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy