Top 31 Oracle E-bussiness Suite Interview Questions You Must Prepare 27.Jul.2024

Q1. 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?

Some of the other components are:

  1. network infrastructure,
  2. servers,
  3. routers, and
  4. load balancing devices.

Q2. A Concurrent Program Starts To Run Based On What Criteria?

A concurrent program starts to run based on when the run is actually scheduled to start, whether or not the concurrent program has been placed on hold, depending on whether the program is compatible to run with other programs or not, and the priority of the request.

Q3. The :block.field Mechanism Is Used For? What Happens If This Mechanism Is Used In Your Value Sets?

This mechanism is only used for backward compatibility; if you use the :block.field mechanism in your value sets, your value sets will not be compatible with future releases of Oracle Applications.

Q4. What Is Oam, And What Does This Application Provide?

OAM stands for Oracle Applications Manager, and provides assistance with patch management.

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

To resolve this issue, you would need to stop all of the middle tier services to include the concurrent managers. Then you would want to stop and restart the database, last but not least you would connect SQLPLUS as APPS user and run EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT;

Q6. How Many Access Control Layers Do You Have Within Oracle Applications?

There are six access control layers, the first three layers of the stack are called core security; the first layer is function security, which is the base layer of the security stack, the second layer is data security, and the third layer is role-based access control (RBAC). Layer 4-6 is known as the administrative features; the fourth layer is called delegated administration, the fifth layer is provisioning features and the sixth layer is called self-service and approvals.

Q7. 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?

The system administrator is the one responsible for setting the priority of a concurrent request. The Concurrent:Priority user profile option is what is used when setting the priority of a concurrent request.

Q8. Why Does Oracle Use Advanced Shipment Notice (asn)?

ASN is what is used in Oracle, which records the traction that has been received into inventory. Once that occurs a logical shipping traction occurs, then the trfer of titles occurs, and the customers invoice is generated. The suppliers’ invoice can then be processed once the invoice for the customer has been generated.

Q9. Which Three Oem Components Must Be Installed, To Manage The Forms Server?

The three OEM components, which must be installed, are:

  1. The OEM Management Server,
  2. The OEM Console and
  3. The OEM Agent.

Q10. What Is Oracle Alert?

Oracle Alert, allows you to view the critical activities in your database immediately.

Q11. There Are Six Types Of Sql Statements, Name Them.

The SQL Statements are:

  1. Data Definition Language (DDL) Statements,
  2. Data Manipulation Language (DML) Statements,
  3. Traction Control Statements,
  4. Session Control Statements,
  5. System Control Statements and
  6. Embedded SQL Statements.

Q12. What Is Atp? What Support Does The Atp Provide?

ATP me Available to Promise; and has the ability to distribute from an existing inventory or backorder, to the new inventory. Once each order item has been ordered, then an estimated availability time is given.

Q13. What Is The Default Structure Name For All Descriptive Flexfields (dffs)?

The name for the default structure is called Global Data Elements.

Q14. What Configuration Takes Place When The Concurrent Processing Nodes Are Load Balanced?

This type of configuration, which takes place when the Concurrent Processing Nodes are load balanced, is known as Parallel Concurrent Processing.

Q15. Why Does Oracle Recommend Running The Concurrent Processing Node On The Application Tier?

Because of fast network connectivity between the Concurrent Processing Node, and the Database Node, Oracle suggests the Concurrent Processing Node run on the application tier, whereas before Oracle suggested the Concurrent Processing Node run on the same tier as the database node.

Q16. How Many Program Library Types? Name The Library Types?

There are two program library types, which are concurrent library and traction library.

Q17. How Many Primary Components Make Up The E-business Suite And Name Them?

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

  1. the client,
  2. forms server,
  3. web server,
  4. concurrent processor and
  5. The Oracle database.

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

Two-tier architecture is the recommended number of tiers at a minimum to be ran on Oracle Applications, because with single tier architecture, contention can happen between the application and database processing, causing performance degradation.

Q19. What Are The Key Flexfields That Are Only Used In Oracle Applications By The Accounting Flexfield And No Other Flexfield?

The key flexfields are

  1. parent,
  2. rollup group,
  3. hierarchy level, and
  4. segment qualifier information.10

Q20. Name The Products In The Oracle E-business Suite Technology Layer?

The products in the technology layer are:

  1. Oracle Application Object Library (FND),
  2. Oracle Applications DBA (AD),
  3. Oracle Common Modules (AK),
  4. Oracle Applications Utilities (AU),
  5. Oracle Workflow (WF),
  6. Oracle Alerts (ALR), and
  7. Oracle Applications Framework (FWK).

Q21. 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

The four levels are:

  1. Site which is the lowest level,
  2. Application
  3. Responsibility
  4. User (highest level).

Q22. Name The Pre-defined Type Alerts?

There are two pre-defined type alerts. Their names are periodic alerts, and event alerts.

Q23. How Would You Define Edi?

EDI stands for Electronic Data Interchange; EDI allows business documents to be trferred electronically between two organizations computers systems, over a communication network.

Q24. What Is The Purpose Of Purging Trient Data, Which Is Stored In An Oracle E-business Suite System?

When you purge data which is not needed periodically, it helps decrease backup times, reduces downtime when system upgrades are needed, as well as improve system performance and increases storage efficiency.

Q25. Difference Between Appl_top Directory And The Common_top Directory?

The COMMON_TOP Directory consists of all files and directories used by all application products, whereas, the APPL_TOP directory consists of all product files and directories, to include all core technology files and directories, and the application context file and environment files.

Q26. What Are The Seeded Business Events In The General Ledger?

The seeded business events 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.

Q27. What Are The Steps To Enable The Shorthand Entry Feature?

First you would go to the shorthand aliases window, you would then select the name and structure of the key flexfield, and thirdly you would want to check the enabled check box located in the shorthand region and then enter a prompt for the shorthand window. After you complete those steps, you would enter the maximum alias size, and then save your changes.

Q28. The Startup Threshold For Concurrent Managers Is Defined By Which Two Profile Options?

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

  1. CONC:Manager Startup Threshold Limit and the
  2. CONC:Manager Startup Threshold Time (minutes).

Q29. In Oracle There Are Background Processes, Which Processes Are The Most Important?

The background processes in Oracle which are most important are:

  1. SMON (System Monitor Process),
  2. PMON (Process Monitor Process),
  3. DBWR (Database Writer or Dirty Buffer Writer Process),
  4. LGWR (Log Writer process), and
  5. ARCH (optional archive process).

Q30. How Many Life Cycle Stages Or Phases Does A Concurrent Request Have? Name The Stages?

The life cycle stages or phases that a concurrent request goes through is three, but could be as many as four. The life cycle stages, also known as stages are:

  1. pending,
  2. running,
  3. completed, and
  4. inactive

Q31. What Is The Scope Of Oracle E-business Suite?

The scope of Oracle E-Business Suites is to provide their customers with an off the shelf solution, which allows businesses to manage all aspects of business.