1⟩ What is oracle d2k? why we use it?
It is a front end tool which consist of forms and reports and use plsql as a coding language
Oracle D2K
Home Oracle Oracle D2K
“Oracle D2K Interview Questions and Answers will guide us now that OracleD2K is the frontend in oracle to develop forms and the backend database oracle would be storing information and d2k will be displaying it. So learn Oracle D2K and get a better job or get preparation for a job in D2K with the help of this Oracle D2K Interview Questions with Answers guide”
28 Oracle D2K Questions And Answers
2⟩ Were you involved in any data conversion, which one?
We have done data conversion for1.Suppliers2.AP Invoices3.Customers4.AR Invoices
3⟩ Total months of effort in Oracle Apps technical work?
If you are technically strong in Oracle D2k then it will take very less or near abt one month to learn abt Oracle apps.
4⟩ Are you familiar with User exits in reports?
The best example for user exit which i used is FND FORMAT_CURRENCY.
5⟩ Do you know what are User Profiles in Apps. Any examples you can give?
User Profile : It is a set of changeable options through which your application runs.User profile can be defined at various levels. They are
1.System
2.Application
3. Responsibility
4. User
6⟩ Which Oracle Apps version you are very confident in?
As we basically use 11.5.9 version hence its better to tell that only.
7⟩ How many concurrent programs you have customized, can you name some of them?
Have to see the standra reports and possible customizations
8⟩ How to make the project as .exe file in oracle forms & reports(d2k)?
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.
9⟩ How do you run ms_batch file in forms? what could be the value system.mode?
host('c:myFile.bat');
host('c:myfile.bat);
10⟩ How to get / select the nth row from the table? how to select first n rows ,last n rows from a table?
nth salary
select salary
from table_name a
where &n=(select count(salary) from table_name b where a.salary<=b.salary);
n salaries
select 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;
11⟩ Do you know what is APPLYSYS in Oracle application database schema, what is APPS?
Applsys is a schema as apps and applsyspub.this schema contains the information about the FND or forndation tables.
12⟩ Do you know table based value sets?
yes i know.
Nav=>application-->validation-->set
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.
13⟩ Any work done in Oracle Workflow builder. Did you customize or build a new workflow?
Yes, I customized the Work Flow For Credit Memo Request approval in AR through Workflow Builder.
14⟩ Which Flexfields you have customized?
Client can customize Descriptive Flex Fields.
15⟩ Have you used lexical parameters in reports?
There is no need of using Lexical parameter in reports Deveoper.Instead We can use bind Variables as a parameter.
16⟩ Have you good knowledge on Java?
Can anybody give the meaning of this question.
i think answer is: i know java
17⟩ Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?
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.
Eg: $XAP_TOP/../reports
Generally we place the newly developed reports in Custom top. $CUSTOM_TOP/reports/US
18⟩ Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?
Directory Name:-
Move the fmb file into :-
cust_top/forms/US
Keep the new form (renamed) in au_top/forms/US
19⟩ In oracle application how do you debug or trace errors?
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.
20⟩ Are you familiar with internet architecture of Oracle Apps 11i?
There are 3 tier of Internet Architechture of Oracle Application 11i.
1. Desktop Tier
2. Database Tier
3. Application Tier.
