Oracle Forms Interview Questions
What is who column and how you set the values?
Answer posted by thangs on 2005-05-20 17:01:08: columns tracking the audit trial(user) information. created_by, creation_date, last_updated_by, last_updated_date, last_update_login
WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the W...
Its actually not at the Form level, It should be at the Block Level. And function is Fnd_Standard.Set_who
What are the important libraries in template.Fmb ?
There are mainly 3 packages are their in custom form
APPCORE
APPDAYPK
FNDSQF
There are mainly two type of library in Template.fmb[a] Core Lib [b] Application specific libraries CORE Libraries are:1. APPCORE.pll : This is used for Application Standards specific uses 2. FNDSQF.p...
Which program is required to be executed after defining messages in the Oracle applications?
The program 'Generate Messages' must be run.
How to show Apps standard calendar in query mode ?. Can anyone tell me how to show calendar in query mode in standard/custom forms. It is working fine in insert mode.Regardssatish shrivastava
1. Create one text item2. Goto text item properties -> goto lov section -> SELECT 1. Subclass information->text-item-date &nb...
Define a Key-listval trigger for that item and use calendar.show;
Calendar will be shown next to the field in query node. Hope I answered your question correctly.
Name the directory having the forms source codes ( fmb files ) ?
The sorce codes (FMB files) are present in $AU_TOP/forms.  - Under this directory, there are language folders like US, PTB etc where the language specific forms are stored. - Once the forms are comp...
$AU_TOP/forms/US is the path u can find it.
Cheers,
Bonthu N Reddy.
What is use of fndsqf library?
Answer posted by thangs on 2005-05-20 17:05:36: routines for handling message dictionary, felxfields, prpfiles, concurrent processing, mulicurrency, who etc
This Library used in form for the following function and related to them:
Desc Flexfield,
Currency,
Concurrent Request Submission,
Record History,
Message Dictionary
-Thanks
S Jain
Routines for handling Message Dictionary, felxfields, prpfiles, concurrent processing, mulicurrency, WHO etc
How do I customize forms in ap.Can I also customize reports in po. Thank u.
You can customize any form by modifiying Custom.pll or by Form personlization.
List the built-in routine for controlling window during run-time?
How to use Java file host command in Oracle forms 4.5
HOST('unix command <full path of file>',NO_SCREEN);
What is the standard program for PO while entering the data from interface tables to basetables? Explain briefly
"Import Standard Purchase Order" Concurrent Program
Get records into a block with scroll bar
How can I get more than one record from a table appeared in a block with scroll bar.
follow these steps:..........1. go to the property of that block2. choose Records->number of records displayed=10(now 10 records come at a time in block u can give any no of record here...
Shall we delete exiting triggers?
we can delete existing trigger using
drop trigger trigger_name;
and we can enable and disable the trigger aslo using
alter trigger trigger_name disable/enable
We must not delete the triggers which comes from the Templates.
Hi pls let me know the steps for how to register the reports in oracle application.
Thanks & Regards,
SenthilS
1.we will develop the report through report 6i.2.we will move that report from local machine to oracle apps serverfor example if it Po module the path is PO/11.5/reports/us/xx.rdf3.we will create exec...
When you are moving a cursor on a form what are the possible triggers that are going to be fired?
If you are moving from a item of first block to the item of another block in a form then following trigger will be fired.post-textwhen-validate-item (fired only when the status of the textitem has bee...
Which form objects we should not use?
Did you attach the form to menu. And both calling form and new form should be attached to the menu and that menu should be accessible by the responsibility which you are using
hi iam working in TCS kolkata,actually i want to navigate from form1 to form2 when button pressed,so i have written the following code in WHEN_BUTTON_PRESSED trigger of form1,DECLARElv_trip_name VARCH...
What is naming convention for unique constraint?
The naming convention for unique Constraint may be Uk.
How can you change the default menu bar action?
How can i enable the export in file menu of default menu bar?I tried APP_SPECIAL.ENABLE('FILE.EXPORT',PROPERTY_ON ); in pre-form and new-form instance trigger but its not working .Is there anything which i have to do other than this to make it enabled.
E.g. To Disable default Create Record Icon(+). Use the following in WHEN-NEW-RECORD-INSTANCE at form level.
APP_SPECIAL.ENABLE('FILE.NEW', PROPERTY_OFF ) ;
To know about detail about default menu, copy FNDMENU.mmb from $AU_TOP/resource/US.
--DM.
Can you comment your form? How?
Yes, we can give comments to our form. To give comments, go to the Module's property sheet, under General heading you can see COMMENTS property, we can provide form comments here. Also change history done to the FORM can be mentioned here.
What are the steps you have to follow to register a form?
=>we will down load template.fmb from au_top resource folder.then we will delete block name from window,datablock,canvas.=> change the proeprty class for window,canva...
Form Registration Steps r :-
1) First put the form in corresponding module like GL / AP / AR in appropriate Server Directory.
2)Register from with Application Object Library ( A.O.L ).
3) Attach Form With Function.
4)Attach Function With Menu.
5)Attach Menu With Responsibility.
Cheers,
Bonthu.
User Panel
Categories
Ads
Interview Coaching
Connect
Ads
Interview Question
Career Counselling
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, click "Subscribe".
making products that suits customer needs
Modifying standard application to meet the business requirement.