Interview Questions.

Q1. Have You Used Lexical Parameters In Reports?

There isn't any want of the use of Lexical parameter in reports Deveoper.Instead We can use bind Variables as a parameter.

Q2. In Oracle Application How Do You Debug Or Trace Errors?

You can hint in Oracle application Help menu.

Start Oracle utility Goto Help.

Help->Diagnostics->Trace-> Regular Trace.

Will ask for Apps Pass. Wil Show Not dialog Box which Gave you the path of Trace document. FTP the Trace file.

Q3. Do You Know What User Profiles In Apps Are. Any Examples You Can Give?

User Profile: It is a fixed of changeable options through which your software runs. User profile can be described at diverse tiers.

They are:

System

Application

Responsibility

User

Q4. Any Work Done In Oracle Workflow Builder. Did You Customize Or Build A New Workflow?

Yes, I custom designed the Work Flow For Credit Memo Request approval in AR thru Workflow Builder.

Q5. 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 challenge like an get entry to database, you expand the forms and reviews and then whilst you install them you furthermore may install the Forms & Reports Runtimes on the client’s gadget. Forms, while compiled have the *.Fmx extension instead of the ordinary *.Fmb extension.

Developer/2000 doesn’t make .Exe files.

Q6. What Is Oracle D2k? Why We Use It?

It is a front cease device which includes forms and reviews and use plsql as a coding language.

Q7. Are You Familiar With Internet Architecture Of Oracle Apps 11i?

There are 3 tier of Internet Architecture of Oracle Application 11i:

Desktop Tier

Database Tier

Application Tier

Q8. Which Oracle Apps Version You Are Very Confident In?

As we basically use 11.Five.Nine version consequently its better to tell that simplest.

Q9. Do You Know What Applysys Is In Oracle Application Database Schema, What Is Apps?

Applsys is a schema as apps and applsyspub.This schema carries the facts approximately the FUND or basis tables.

Q10. Which Flex Fields You Have Customized?

Client can personalize Descriptive Flexfields.

Q11. Are You Familiar With User Exits In Reports?

The quality example for person go out which i used is FND FORMAT_CURRENCY.

Q12. Were You Involved In Any Data Conversion, Which One?

We have performed facts conversion for

Suppliers

AP Invoices

Customers4.AR Invoices.

Q13. Total Months Of Effort In Oracle Apps Technical Work?

If you're technically strong in Oracle D2k then it's going to take very less or close to abt one month to learn abt Oracle apps.

Q14. What Is The Page Protect In Reports?

It shows that whether or not you need to maintain a object and its whole contents at the identical logical page. Setting its assets to ‘sure’ if the item and its entire contents cannot match inside the page it is going to be moved to next logical page.

Q15. Which Oracle Applications Pl/square Standard Apis You Are Familiar, Have You Used Most Of Them?

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

Q16. What Are The New Features In Release 11i?

The important capabilities in Release 11i is

Multi Org-To help multiple groups.

Multi Currency-Defining the multiple currencies to unmarried employer

Multi Lingual-Supporting of multi Languages.

Q17. Do You Know Table Based Value Sets?

Yes i recognize.

Nav=>application–>validation–>set

we will deliver set name.

Select type as table, “edit facts” button will highlight, click that deliver application name–>desk call(for which u want to make table price set)–>column call–>provide call of the column–>where/order with the aid of(provide the situation or order both asc/desc)–>shop it and use in “parameters” window in concurrent program introduction.