Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

What Is The Page Protect In Reports?

Answer»

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.

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.

2.

What Are The New Features In Release 11i?

Answer»

The main features in Release 11I is

  1. MULTI Org-To support MULTIPLE organizations.
  2. Multi Currency-Defining the multiple CURRENCIES to single organization
  3. Multi Lingual-Supporting of multi Languages.

The main features in Release 11i is

3.

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

Answer»
  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

4.

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

Answer»

There are 3 TIER of INTERNET Architecture of ORACLE Application 11i:

  1. DESKTOP Tier
  2. Database Tier
  3. Application Tier

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

5.

In Oracle Application How Do You Debug Or Trace Errors?

Answer»
  • 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.

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

6.

Have You Used Lexical Parameters In Reports?

Answer»

There is no NEED of using LEXICAL parameter in REPORTS Deveoper.Instead We can USE bind Variables as a parameter.

There is no need of using Lexical parameter in reports Deveoper.Instead We can use bind Variables as a parameter.

7.

Which Flex Fields You Have Customized?

Answer»

CLIENT can CUSTOMIZE DESCRIPTIVE FLEXFIELDS.

Client can customize Descriptive Flexfields.

8.

Do You Know Table Based Value Sets?

Answer»

Yes i know.

NAV=>application–>validation–>set

we will give set name.

Select type as table, “edit information” button will highlight, 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.

Yes i know.

Nav=>application–>validation–>set

we will give set name.

Select type as table, “edit information” button will highlight, 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.

9.

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 through WORKFLOW Builder.

Yes, I customized the Work Flow For Credit Memo Request approval in AR through Workflow Builder.

10.

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 contains the INFORMATION about the FUND or foundation TABLES.

Applsys is a schema as apps and applsyspub.this schema contains the information about the FUND or foundation tables.

11.

How To Make The Project As .exe File In Oracle Forms & Reports (d2k)?

Answer»

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 client’s machine. Forms, when compiled have the *.fmx extension as OPPOSED to the NORMAL *.fmb extension.

Developer/2000 doesn’t make .exe files.

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 client’s machine. Forms, when compiled have the *.fmx extension as opposed to the normal *.fmb extension.

Developer/2000 doesn’t make .exe files.

12.

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

Answer»

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

User Profile: It is a set of changeable options through which your application runs. User profile can be defined at various levels.

They are:

13.

Are You Familiar With User Exits In Reports?

Answer»

The best EXAMPLE for user EXIT which i USED is FND FORMAT_CURRENCY.

The best example for user exit which i used is FND FORMAT_CURRENCY.

14.

Total Months Of Effort In Oracle Apps Technical Work?

Answer»

If you are technically strong in Oracle D2K then it will take very less or near ABT one month to learn abt Oracle apps.

If you are technically strong in Oracle D2k then it will take very less or near abt one month to learn abt Oracle apps.

15.

Were You Involved In Any Data Conversion, Which One?

Answer»

We have done data CONVERSION for

We have done data conversion for

16.

Which Oracle Apps Version You Are Very Confident In?

Answer»

As we BASICALLY use 11.5.9 version HENCE its BETTER to TELL that only.

As we basically use 11.5.9 version hence its better to tell that only.

17.

What Is Oracle D2k? Why We Use It?

Answer»

It is a FRONT END TOOL which consists of forms and reports and use PLSQL as a coding language.

It is a front end tool which consists of forms and reports and use plsql as a coding language.