Interview Questions.

Question 1. How Many Primary Components Make Up The E-commercial enterprise Suite And Name Them?

Answer :

There are five primary components which make up the E-Business Suite. The additives are:

the patron,
forms server,
net server,
concurrent processor and
The Oracle database.
Question 2. E-business Suite Architecture Has Many Other Components Aside From The Primary Components, What Are Some Of The Other Components Which Is Part Of The E-business Suite Architecture?

Answer :

Some of the alternative components are:

community infrastructure,
servers,
routers, and
load balancing devices.
Oracle 10g Interview Questions
Question 3. Why Does Oracle Recommend Running The Concurrent Processing Node On The Application Tier?

Answer :

Because of fast community connectivity between the Concurrent Processing Node, and the Database Node, Oracle suggests the Concurrent Processing Node run on the utility tier, while earlier than Oracle recommended the Concurrent Processing Node run at the identical tier because the database node.

Question 4. Recommended By Oracle, What Is The Suggested Number Of Tiers The Architecture Should Have And Why?

Answer :

Two-tier structure is the recommended range of ranges at a minimum to be ran on Oracle Applications, due to the fact with single tier architecture, competition can appear among the utility and database processing, causing performance degradation.

Oracle 10g Tutorial
Question five. What Configuration Takes Place When The Concurrent Processing Nodes Are Load Balanced?

Answer :

This kind of configuration, which takes place when the Concurrent Processing Nodes are load balanced, is called Parallel Concurrent Processing.

Oracle 9i Interview Questions
Question 6. Difference Between Appl_top Directory And The Common_top Directory?

Answer :

The COMMON_TOP Directory consists of all documents and directories used by all software merchandise, whereas, the APPL_TOP directory includes all product files and directories, to encompass all core technology documents and directories, and the application context document and environment files.

Question 7. What Is Atp? What Support Does The Atp Provide?

Answer :

ATP method Available to Promise; and has the ability to distribute from an existing inventory or backorder, to the new inventory. Once every order object has been ordered, then an predicted availability time is given.

Oracle 9i Tutorial Oracle 8i Interview Questions
Question 8. Why Does Oracle Use Advanced Shipment Notice (asn)?

Answer :

ASN is what is utilized in Oracle, which records the transaction that has been acquired into inventory. Once that takes place a logical delivery transaction happens, then the switch of titles occurs, and the clients invoice is generated. The providers’ invoice can then be processed once the bill for the patron has been generated.

Question nine. If After Cloning, All Of The Concurrent Managers Did Not Start, How Would You Resolve The Issue?

Answer :

To solve this issue, you will need to stop all the center tier offerings to encompass the concurrent managers. Then you will need to stop and restart the database, final but not least you would join SQLPLUS as APPS person and run EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT;

Oracle 11g Interview Questions
Question 10. A Concurrent Program Starts To Run Based On What Criteria?

Answer :

A concurrent program begins to run primarily based on while the run is absolutely scheduled to start, whether or now not the concurrent program has been positioned on preserve, depending on whether or not this system is well suited to run with other programs or now not, and the concern of the request.

Oracle 8i Tutorial
Question eleven. When The Priority Of A Concurrent Request Is Set; Who Is Responsible For Setting Up The Concurrent Request, And By Using What User Profile Option?

Answer :

The gadget administrator is the only chargeable for setting the concern of a concurrent request. The Concurrent:Priority person profile alternative is what's used whilst setting the concern of a concurrent request.

Oracle apps Interview Questions
Question 12. How Many Life Cycle Stages Or Phases Does A Concurrent Request Have? Name The Stages?

Answer :

The lifestyles cycle stages or stages that a concurrent request is going thru is three, but might be as many as four. The lifestyles cycle stages, also known as stages are:

pending,
going for walks,
completed, and
inactive
Oracle 10g Interview Questions
Question 13. The Startup Threshold For Concurrent Managers Is Defined By Which Two Profile Options?

Answer :

The two profile options, which define the startup threshold for concurrent managers are:

CONC:Manager Startup Threshold Limit and the
CONC:Manager Startup Threshold Time (minutes).
Oracle 11g Tutorial
Question 14. What Is Oam, And What Does This Application Provide?

Answer :

OAM stands for Oracle Applications Manager, and gives help with patch management.

Question 15. What Is The Purpose Of Purging Transient Data, Which Is Stored In An Oracle E-commercial enterprise Suite System?

Answer :

When you purge records which isn't wished periodically, it enables decrease backup instances, reduces downtime whilst gadget upgrades are wanted, as well as improve device performance and increases storage performance.

Oracle Apps ERP Interview Questions
Question 16. When Setting Up A Profile Option, Most Profiles Use The Security Hierarchy Type. What Are The Four Levels At Which These Profile Options Can Be Set At Going From The Lowest Level, To The Highest Level?

Answer :

The four degrees are:

Site that is the bottom level,
Application
Responsibility
User (highest degree).
Question 17. What Is Oracle Alert?

Answer :

Oracle Alert, permits you to view the critical sports on your database right now.

Oracle 7.3 Interview Questions
Question 18. Name The Pre-described Type Alerts?

Answer :

There are  pre-defined type indicators. Their names are periodic alerts, and occasion alerts.

Oracle 9i Interview Questions
Question 19. Name The Products In The Oracle E-business Suite Technology Layer?

Answer :

The products in the technology layer are:

Oracle Application Object Library (FND),
Oracle Applications DBA (AD),
Oracle Common Modules (AK),
Oracle Applications Utilities (AU),
Oracle Workflow (WF),
Oracle Alerts (ALR), and
Oracle Applications Framework (FWK).
Question 20. Which Three Oem Components Must Be Installed, To Manage The Forms Server?

Answer :

The 3 OEM additives, which must be installed, are:

The OEM Management Server,
The OEM Console and
The OEM Agent.
Oracle ADF Interview Questions
Question 21. There Are Six Types Of Sql Statements, Name Them.

Answer :

The SQL Statements are:

Data Definition Language (DDL) Statements,
Data Manipulation Language (DML) Statements,
Transaction Control Statements,
Session Control Statements,
System Control Statements and
Embedded SQL Statements.
Question 22. In Oracle There Are Background Processes, Which Processes Are The Most Important?

Answer :

The historical past strategies in Oracle which might be most essential are:

SMON (System Monitor Process),
PMON (Process Monitor Process),
DBWR (Database Writer or Dirty Buffer Writer Process),
LGWR (Log Writer procedure), and
ARCH (non-compulsory archive process).
Question 23. How Many Access Control Layers Do You Have Within Oracle Applications?

Answer :

There are six get right of entry to manage layers, the primary three layers of the stack are referred to as middle security; the primary layer is characteristic security, which is the bottom layer of the safety stack, the second one layer is data security, and the 0.33 layer is role-based get right of entry to control (RBAC). Layer four-6 is referred to as the administrative capabilities; the fourth layer is referred to as delegated administration, the fifth layer is provisioning functions and the sixth layer is known as self-service and approvals.

Oracle popular ledger (GL) Interview Questions
Question 24. How Many Program Library Types? Name The Library Types?

Answer :

There are  software library types, which are concurrent library and transaction library.

Oracle 8i Interview Questions
Question 25. What Is The Default Structure Name For All Descriptive Flexfields (dffs)?

Answer :

The name for the default structure is known as Global Data Elements.

Question 26. The :block.Area Mechanism Is Used For? What Happens If This Mechanism Is Used In Your Value Sets?

Answer :

This mechanism is simplest used for backward compatibility; if you use the :block.Subject mechanism on your fee sets, your price sets will now not be well suited with future releases of Oracle Applications.

Oracle Application Framework Interview Questions
Question 27. What Are The Steps To Enable The Shorthand Entry Feature?

Answer :

First you will visit the shorthand aliases window, you will then select the name and structure of the important thing flexfield, and thirdly you'll want to test the enabled test container placed in the shorthand location after which input a activate for the shorthand window. After you entire the ones steps, you will input the most alias size, after which save your modifications.

Oracle 11g Interview Questions
Question 28. What Are The Key Flexfields That Are Only Used In Oracle Applications By The Accounting Flexfield And No Other Flexfield?

Answer :

The key flexfields are

parent,
rollup organization,
hierarchy degree, and
phase qualifier facts.10
Question 29. What Are The Seeded Business Events In The General Ledger?

Answer :

The seeded commercial enterprise activities are:

Period Re-opened,
Journal Import Completed,
Account Disabled,
Period Opened,
Period Closed,
Journal Import Started,
Posting Completed,
Secondary Ledger Deleted,
Reporting Currency Deleted, and
Accounting Setup Completed.
Oracle Apps Functional Interview Questions
Question 30. How Would You Define Edi?

Answer :

EDI stands for Electronic Data Interchange; EDI permits commercial enterprise documents to be transferred electronically among two businesses computer systems systems, over a verbal exchange network.

Question 31. What Is The Scope Of Oracle E-commercial enterprise Suite?

Answer :

The scope of Oracle E-Business Suites is to provide their clients with an off the shelf answer, which permits agencies to manage all components of enterprise.