Dear Readers, Welcome to Oracle D2K Interview Questions and Answers have been designed specially to get you acquainted with the nature of questions you may encounter during your Job interview for the subject of Oracle D2K. These Oracle D2K Questions are very important for campus placement test and job interviews. As per my experience good interviewers hardly plan to ask any particular questions during your Job interview and these model questions are asked in the online technical test and interview of many IT companies.
It is a front end tool which consist of forms and reports and use plsql as a coding language
We have done data conversion for1.Suppliers2.AP Invoices3.Customers4.AR Invoices
As we basically use 11.5.9 version hence its better to tell that only.
If you are technically strong in Oracle D2k then it will take very less or near abt one month to learn abt Oracle apps.
The best example for user exit which i used is FND FORMAT_CURRENCY.
User Profile : It is a set of changeable options through which your application runs.User profile can be defined at various levels. They are
Have to see the standra reports and possible customizations
Developer/2000 doesn't make exe files. Think of your Dev 2k project like an access database, you develop the forms and reports and then when you deploy them you also install the Forms & Reports Runtimes on the clients machine. Forms, when compiled have the *.fmx extension as opposed to the normal *.fmb extension.
Developer/2000 doesn't make .exe files.
what could be the value :system.mode?
how to select first n rows ,last n rows from a table?
from table_name a
where &n=(select count(salary) from table_name b where a.salary<=b.salary);
from table_name a
where &n>=(select count(salary) from table_name b where a.salary<=b.salary);
select level,max(column name) from emp where level = n connect by prior sal > sal group by level;
Applsys is a schema as apps and applsyspub.this schema contains the information about the FND or forndation tables.
Yes, I customized the Work Flow For Credit Memo Request approval in AR through Workflow Builder.
yes i know.
we will give set name.
select type as table,"edit information" button will hilight, click that
give application name-->table name(for which u want to make table value set)-->column name-->give name of the column-->where/order by(give the condition or order either asc/desc)-->save it and use in "parameters" window in concurrent program creation.
Client can customize Descriptive Flex Fields.
Can anybody give the meaning of this question.
i think answer is: i know java
There is no need of using Lexical parameter in reports Deveoper.Instead We can use bind Variables as a parameter.
THe extension of the Oracle report will be *.rdf (Report Definition File).
You place the Oracle report on the corresponding application top in the reports folder.
Generally we place the newly developed reports in Custom top. $CUSTOM_TOP/reports/US
Move the fmb file into :-
Keep the new form (renamed) in au_top/forms/US
You can trace in Oracle application Help menu.
Start Oracle application Goto Help
Help->Diagnostics->Trace-> Regular Trace.
will ask for Apps Pass. Wil Show Not dialog Box which Gave you the path of Trace file. FTP the Trace file.
There are 3 tier of Internet Architechture of Oracle Application 11i.
1. Desktop Tier
2. Database Tier
3. Application Tier.
1. Fnd_File - PL/SQL I/O
2. Fnd_program - Concurrent Program Loaders
3. Fnd_set - Request Set Creation
4. Fnd_request - Concurrent Request Submission
5. Fnd_Submit - Request set Submission
6. Fnd_Request - Info
and so on...
The main features in Release 11i is
1.Multi Org-To support Multiple organizations.
1.Multi Currency-Defineing the multiple currencies to single organization
2.Multi Lingual-Suporting of multi Languages.
You can use srw.run_report as followssrw.run_report('module=modulename.rdf destype=screen paramform=yes');
There are eight different layout formats :
2. Form Like
3. Mailing Label
4. Form Letter
5. Group Left
6. Group Above
8. Matrix with group
What is the Format Trigger?
A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, depending upon the type of value which will be stored into it.
A format trigger is used when we want to display a particular field, if certain conditions are met.
While Submitting the request you can select schedule button and specify Run The Job Option On Specific Days and Select all Days except Sunday.
What is the difference between Frame and Repeating Frame?
Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. The end of the anchor with a symbol on it is attached to the parent object.
Since the size of some layout objects may change when the report runs (and data is actually fetched), we need anchors to define where we want objects to appear relative to one another. An anchor defines the relative position of an object to the object to which it is anchored. Positioning is based on the size of the objects after the data has been fetched rather than on their size in the editor. It should also be noted that the position of the object in the Layout editor effects the final position in the report output. Any physical offset in the layout is incorporated into the percentage position specified in the Anchor property sheet.
It indicates that whether you want to keep a object and its entire contents on the same logical page. Setting its property to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page.