Oracle D2k Interview Questions with Answers
Question: 1. What Is Oracle D2k? Why We Use It?
Answer:
It is a the front quit tool which includes paperwork and reports and use plsql as a coding language.
Question: 2. Which Oracle Apps Version You Are Very Confident In?
Answer:
As we essentially use eleven.Five.9 version consequently its higher to inform that handiest.
PL/SQL Interview Questions
Question: three. Were You Involved In Any Data Conversion, Which One?
Answer:
We have executed statistics conversion for
Suppliers
AP Invoices
Customers4.AR Invoices.
Question: four. Total Months Of Effort In Oracle Apps Technical Work?
Answer:
If you are technically sturdy in Oracle D2k then it’s going to take very less or near abt one month to analyze abt Oracle apps.
Question: 5. Are You Familiar With User Exits In Reports?
Answer:
The great example for person go out which i used is FND FORMAT_CURRENCY.
PL/SQL and Informatica Interview Questions
Question: 6. Do You Know What User Profiles In Apps Are. Any Examples You Can Give?
Answer:
User Profile: It is a set of changeable options thru which your software runs. User profile can be described at numerous levels.
They are:
System
Application
Responsibility
User
Question: 7. How To Make The Project As .Exe File In Oracle Forms & Reports (d2k)?
Answer:
Developer/2000 doesn’t make exe documents. Think of your Dev 2k mission like an access database, you increase the forms and reviews after which whilst you install them you furthermore mght installation the Forms & Reports Runtimes at the consumer’s gadget. Forms, while compiled have the *.Fmx extension instead of the regular *.Fmb extension.
Developer/2000 doesn’t make .Exe files.
Oracle apps Interview Questions
Question: eight. Do You Know What Applysys Is In Oracle Application Database Schema, What Is Apps?
Answer:
Applsys is a schema as apps and applsyspub.This schema incorporates the statistics about the FUND or basis tables.
Question: nine. Any Work Done In Oracle Workflow Builder. Did You Customize Or Build A New Workflow?
Answer:
Yes, I customized the Work Flow For Credit Memo Request approval in AR via Workflow Builder.
Oracle Apps ERP Interview Questions
Question: 10. Do You Know Table Based Value Sets?
Answer:
Yes i know.
Nav=>application–>validation–>set
we will supply set call.
Select kind as desk, “edit statistics” button will spotlight, click on that supply application name–>table name(for which u need to make table cost set)–>column name–>deliver name of the column–>where/order via(supply the situation or order either asc/desc)–>keep it and use in “parameters” window in concurrent application introduction.
Question: eleven. Which Flex Fields You Have Customized?
Answer:
Client can customise Descriptive Flexfields.
Oracle ADF Interview Questions
Question: 12. Have You Used Lexical Parameters In Reports?
Answer:
There isn’t any want of the use of Lexical parameter in reviews Deveoper.Instead We can use bind Variables as a parameter.
PL/SQL Interview Questions
Question: 13. In Oracle Application How Do You Debug Or Trace Errors?
Answer:
You can hint in Oracle utility 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 direction of Trace record. FTP the Trace file.
Question: 14. Are You Familiar With Internet Architecture Of Oracle Apps 11i?
Answer:
There are three tier of Internet Architecture of Oracle Application 11i:
Desktop Tier
Database Tier
Application Tier
Question: 15. Which Oracle Applications Pl/square Standard Apis You Are Familiar, Have You Used Most Of Them?
Answer:
Fnd_File – PL/SQL I/O
Fnd_program – Concurrent Program Loaders
Fnd_set – Request Set Creation
Fnd_request – Concurrent Request Submission
Fnd_Submit – Request set Submission
Fnd_Request – Info
Oracle Forms And Reports Interview Questions
Question: 16. What Are The New Features In Release 11i?
Answer:
The essential functions in Release 11i is
Multi Org-To support multiple businesses.
Multi Currency-Defining the a couple of currencies to unmarried company
Multi Lingual-Supporting of multi Languages.
Question: 17. What Is The Page Protect In Reports?
Answer:
It shows that whether you want to maintain a object and its entire contents on the identical logical page. Setting its assets to ‘sure’ if the object and its complete contents can’t match in the page it’ll be moved to next logical web page.
Oracle Apps DBA Interview Questions