- What is custom development ?
- What is customization?
- Compare Custom development & customization. When they are used and Why ?
- What are the steps you have to follow to register a custom application?
- How do you find out the FMB file name?
- Name the directory having the FORMS source codes ( FMB files ) ?
- What is template form?
- What are the steps you have to follow to register a Form?
- What is a Form function?
- What is Form sub function?
- How the form sub function is implemented?
- What is folder form?
- Name the directories where you have to copy your Fmb and Fmx files?
- Why we have to maintain the file names in Capital Letter? ( Library/FMB)
- What is naming convention for Data base trigger?
- What is naming convention for unique Constraint?
- What is naming convention for Primary key Constraint?
- Can we put all the logic in the trigger?
- What is item handler package?
- What is event handler package?
- What is table handler package?
- What are the standard libraries available in template form?
- What is who column and how you set the values?
- What is use of custom library?
- How can you change the default menu bar action?
- What is use of APPCORE library?
- What is a reference trigger? Can we modify a reference trigger?
- Why we have to create packages instead of procedures / functions?
- Can you comment your form? How?
- Which form objects we should not use?
- What is use of APPDAYPK library?
- What is use of FNDSQF library?
- Can we change the profile value ? How ?
- Can we modify all the trigger?
- What are the triggers we should not modify?
- Shall we delete exiting triggers?
- What is custom development?
Custom development is new
development, In order to provide new functionality , which is not available in
Oracle Application, we are going for custom development.
- What is customization?
Customization is not a new
development. The existing form will be modified as per our requirement. This
may be cosmetic change or navigation change or functionality change.
- Compare Custom development & customization. When they are used and Why?
Custom development.
a. New development
b. Template form has to use
c. The required functionality is not provided by oracle in that
case we have to go for custom development.
Customization.
a. Tailoring the existing application
b. Same source file has to use
c. The existing functionality is not fully satisfy our
requirement, Then we are going for
customization.
- What are step you have to follow to register a custom application?
1. Register your Application
2. Create directory structure
3. Set the Environment variable for directory
4. Create the schema
5. Attach your application
& Schema with standard data group
6. Create the table, views, and trigger in your schema.
7. Create synonym for table to APPS schema
8. Built the form
9. Register the form
10. Create form function
11. Create the menu
12. Attach the menu to the responsibility
13. Attach the responsibility to the user
- How do you find out the FMB name?
Select menu bar Help menu of the
form, then select About Oracle Application menu, that will show the FMB of the
form.
- Name the directory having the FORMS source codes ( FMB files ) ?
AU_TOP forms directory.
- What is template form?
Template form is a form, which
have standard functionality of the oracle application, like menu bar, tool bar
action and some standard trigger. All forms in oracle application will be
developed using this form, To get standard appearance oracle application
provide this form.
- What are step you have to follow to register a Form?
- Create the function.
- Attach the function to a form function
- Attach the form function to menu.
- What is a Form function?
Form function is nothing but form.
Oracle Apps treats all the forms as function.
- What is Form sub function?
Sub function is a non-form
function. Sub function will created based on form function. By using this we
can restrict functionality of the form.
- How the form sub function is implemented?
By using parameter and profiles.
- What is folder form?
Folder form is a special form,
here the user allow changing the appearance of the form as he/she like. The
user can rearrange the fields, resize the fields. This changes will be
permanent belongs to the user.
- Name the directories where you have to copy your Fmb and Fmx files?
All FMB files will be coped in
AU_TOP form directory. FMX will be copied to corresponding Prod_Top form
directory.
e.x
all GL forms fmx will be coped in GL_Top form directory.
- Why we have to maintain the file names in Capital Letter? ( Library/FMB)
Some of operation system will have
case sensitivity, those OS may not able to get the correct file, for avoiding
case sensitivity problem we have to maintain the file name in UPPER case.
- What is naming convention for Data base trigger?
Tablename_Ti. ( “i” = 1,2,3…..)
- What is naming convention for unique Constraint?
Tablename_Ui (“i” = 1,2,3….)
- What is naming convention for Primary Constraint?
Tablename_PK
- Can we put all the logic in the trigger?
No, Create a package, put all the
logic in package. Call the package from the trigger.
- What is item handler package?
Item handler package is a package.
This package will take care of the item validation, navigation. Each block can
have one package with the name of block name.
- What is event handler package?
Event handler package is a
package. This package will take care of the various event of the form, like
post query, pre query, when new record instance etc. Each form has event
handler package with the name of form name.
- What is table handler package?
Table handler package is a
package. This package will take care of the insert, update and delete operation
of view-based block. Each form can have one package with the name of form name.
- What are the standard libraries available in template form?
1.APPCORE, 2. APPDAYPK, 3. FNDSQF
, 4.CUSTOM
- What is who column and how can you set the values?
Who columns are database columns,
which gives the history of the record. ( it will gives created user name with
date and last modified user name with date of the record).
By using fnd_standard.set_who
procedure we can set the value.
- What is use of custom library?
By using this library we have to
do cosmetic and navigation change in form customization.
- How can you change the default menu bar action?
By using APPCORE library
- What is use of APPDAYPK library?
By using this library you can
change the functionality of menu action and tool bar actions, and you can add
custom help files in the application.
- What is a reference trigger? Can we modify a reference trigger?
Reference trigger is a trigger,
definition of the trigger will be in some other file.
We can, But Oracle Application
advise against modifying the reference trigger. Because this change will affect
the whole application.
- Why we have to create packages instead of procedure / function?
If we create procedure/function,
this will be compiled every call of the procedure/function, But if you create
package it will not complied every call, It will increase performance of the
application.
- Can you comment your form? How?
Yes.
- You can give comment of the from in Form module “comment window”.
- By using FND_Standard.Form_info procedure you can comment your form, this is in Pre_Form trigger.
- Which form objects we should not use?
1. Activex, Vbx, Ocx, Ole
2. Timer
3. Mouse Trigger
4. Open_Form
5. Combo Box
6. Test_io, Host built-in
- What is use of APPDAYPK library?
By using this library you can
display calendar window in date field LOV.
- What is use of FNDSQF library?
This library will tack care of
concurrent program, profile options and flex filed behavior.
- Can we change the profile value? How?
Yes.
By using FNDSQF library we can
change the profile values.
- Shall we modify all the triggers?
No, we should not do any
modification in certain form level trigger.
- What are the triggers we should not modify?
1.
Close_this_window.
2.
Close_window
3.
Export
4.
Folder_Action
5.
Key-Commit
6.
Key-Edit
7.
Key-Exit
8.
Key-Help
9.
Lastrecord
10.
Menu_to_Appcore
11.
Standard_Attachment
12.
When_window_closed
13.
When_form_navigate
14. Zoom
- Shall we delete exiting triggers?
We should not delete any form
level trigger. But Oracle application not encouraging deletion of any trigger.
