Oracle E-Bussiness Suite Interview Questions & Answers

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

    Answer :

    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.
  2. 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 other components are:

    1. network infrastructure,
    2. servers,
    3. routers, and
    4. load balancing devices.
  3. Oracle 10g Interview Questions

  4. Question 3. Why Does Oracle Recommend Running The Concurrent Processing Node On The Application Tier?

    Answer :

    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.

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

    Answer :

    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.

  6. Oracle 10g Tutorial

  7. Question 5. What Configuration Takes Place When The Concurrent Processing Nodes Are Load Balanced?

    Answer :

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

  8. Oracle 9i Interview Questions

  9. Question 6. Difference Between Appl_top Directory And The Common_top Directory?

    Answer :

    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.

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

    Answer :

    ATP means 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.

  11. Oracle 9i Tutorial
    Oracle 8i Interview Questions

  12. Question 8. Why Does Oracle Use Advanced Shipment Notice (asn)?

    Answer :

    ASN is what is used in Oracle, which records the transaction that has been received into inventory. Once that occurs a logical shipping transaction occurs, then the transfer 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.

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

    Answer :

    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;

  14. Oracle 11g Interview Questions

  15. Question 10. A Concurrent Program Starts To Run Based On What Criteria?

    Answer :

    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.

  16. Oracle 8i Tutorial

  17. Question 11. 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 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.

  18. Oracle apps Interview Questions

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

    Answer :

    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
  20. Oracle 10g Interview Questions

  21. 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:

    1. CONC:Manager Startup Threshold Limit and the
    2. CONC:Manager Startup Threshold Time (minutes).
  22. Oracle 11g Tutorial

  23. Question 14. What Is Oam, And What Does This Application Provide?

    Answer :

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

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

    Answer :

    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.

  25. Oracle Apps ERP Interview Questions

  26. 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 levels are:

    1. Site which is the lowest level,
    2. Application
    3. Responsibility
    4. User (highest level).
  27. Question 17. What Is Oracle Alert?

    Answer :

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

  28. Oracle 7.3 Interview Questions

  29. Question 18. Name The Pre-defined Type Alerts?

    Answer :

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

  30. Oracle 9i Interview Questions

  31. Question 19. Name The Products In The Oracle E-business Suite Technology Layer?

    Answer :

    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).
  32. Question 20. Which Three Oem Components Must Be Installed, To Manage The Forms Server?

    Answer :

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

    1. The OEM Management Server,
    2. The OEM Console and
    3. The OEM Agent.
  33. Oracle ADF Interview Questions

  34. Question 21. There Are Six Types Of Sql Statements, Name Them.

    Answer :

    The SQL Statements are:

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

    Answer :

    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).
  36. Question 23. How Many Access Control Layers Do You Have Within Oracle Applications?

    Answer :

    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.

  37. Oracle general ledger (GL) Interview Questions

  38. Question 24. How Many Program Library Types? Name The Library Types?

    Answer :

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

  39. Oracle 8i Interview Questions

  40. Question 25. What Is The Default Structure Name For All Descriptive Flexfields (dffs)?

    Answer :

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

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

    Answer :

    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.

  42. Oracle Application Framework Interview Questions

  43. Question 27. What Are The Steps To Enable The Shorthand Entry Feature?

    Answer :

    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.

  44. Oracle 11g Interview Questions

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

    1. parent,
    2. rollup group,
    3. hierarchy level, and
    4. segment qualifier information.10
  46. Question 29. What Are The Seeded Business Events In The General Ledger?

    Answer :

    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.
  47. Oracle Apps Functional Interview Questions

  48. Question 30. How Would You Define Edi?

    Answer :

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

  49. Question 31. What Is The Scope Of Oracle E-business Suite?

    Answer :

    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.