Are you looking for Oracle EBS interview questions? Here is the comprehensive list of questions along with their answers that will help both Experienced and Fresher candidates to crack their interviews and acquire a dream job as Oracle EBS professionals. 

Oracle E-Business Suite applications manage the issues in global business environments irrespective of the organization size. Therefore, there is a high demand for Oracle EBS professionals in the market. So, let us see what are the frequently asked questions in the Oracle EBS interviews.

Are you interested in learning Oracle EBS  from experts? 

Visit here  Oracle EBS Training 

Top Oracle EBS Interview Questions  & Answers You Must know

Q1. What are the report triggers in Oracle?

Ans: There are five main types of report triggers available in the Oracle and they are -

  • Before Report
  • After Report
  • After Parameter Form
  • Before Parameter Form
  • Between Pages

Q2. What is the purpose of applsyspub user in Oracle EBS?

Ans:  It is a gateway user used in the connection process. When you sign on to the Oracle platform, first you get connected to the public schema, applsyspub. Once the username and password get verified, you will get connected to the Apps schema where you will have to choose responsibility.

Q3. Why patches are required in Oracle EBS?

Ans: There are two types of patched - Optach and Adpatch. They are used to resolve various    issues such as 

  • Problem with Application Code
  • Production issues
  • Install new features to upgrade components

Q4. Will the modifications done in a Workday calendar comes into action after saving?

Ans: No, the changes that are made into a Workday calendar will come into action only after Building the Calendar.

Q5. What are the basic reasons for a line to get backorderd during Pick Release?

Ans: Reasons for the line to be backorderds are

  • The inventory period is closed
  • Item is not available in inventory
  • Holds are placed against the order or order line

Q6. What are the different control options in inventory?

Ans:  Following are the control options in inventory -

  • Locator control
  • Lot control
  • Serial control
  • Revision control
  • Locator and sub inventory restriction

Q7. What are the different key flex fields in Oracle Inventory?

Ans:  Following are the different flex fields in oracle inventory -

  •  Item Catalogue
  • Item Categories
  • Stock locators
  • Sales Orders
  • System Items
  •  Accounts Alias

Q8. Define various planning methods in Inventory?

Ans:  There are five planning methods in inventory -

  • Min-Max Planning
  • Kanban Planning
  • Re-order point planning
  • Periodic Automatic Replenishment
  • Subinv Replenishment Planning

Q9. What is the difference between Descriptive flexfield and Keyflexfield?

Ans:  Keyflexfield is used to uniquely identify information such as INV items, GL accounts, Fixed assets, etc that businesses need to keep track off. Descriptive flexfield used for capturing additional pieces of information from a transaction entered into Oracle EBS. 

Q10. What is the difference between Truncate the table and Drop the table?

Ans:  Drop Table removes all data, indexes, constraints, permission specifications, triggers from the table whereas Truncate Table removes all rows in the table without logging particular row deletion.

Q11. What is the flow of the service contract?

Ans: To create a service contract, you need to follow the below-given steps-

  • Create a contract based on business requirement
  • Enter the service line item as service coverage
  • Enter Line>Effectivity>Item for which service contract is needed
  • Enter sales, credit, pricelist, etc.
  • Check for QA
  • Submit approval
  • Set the status of contract as Active

Q12. How many components are present in the service contract?

Ans:  The contract lifecycle includes

  • Creation
  • Approval
  • Entitlement
  • Pricing
  • Billing
  • Managing contracts

Q13.  What is the concurrent program?

Ans:  A Concurrent program is an instance that is executed along with incompatibles and parameters.

Q14.  What is a token?

Ans:  A token is used to transfer values towards the report builder and they are usually not the case–sensitive.

Q15. Which are the types of Triggers?

Ans: There are different types of triggers associated with forms and they are

  • Key triggers
  • Error triggers
  • Message triggers
  • Query-based triggers
  • Transactional triggers
  • Navigational triggers

Q16.  Where do we use Custom.pll?

Ans:  Custom.pll is used during the process of making customized or new oracle forms. Once the custom events are enabled, Oracle will display all events that can be trapped using CUSTOM.pll.

Q17. How is the Apps schema different from other schemas?

Ans:  App schema consists of only synonyms, there is no option for creating a table in it. Whereas other schemas contain tables and objects and also allow the creation of tables. 

Q18. What are a custom top and its purpose?

Ans: Custom top is exclusively created for customers to store customized components and several custom tops can be made as per the requirement. When Oracle corporation applies patches, every module is overridden except the custom top.

Q19. What are the record group and its types?

Subscribe to our youtube channel to get new updates..!

Ans:  A record group is a data structure having a column/ row framework like a database table. There are a total of three types of record groups -

  • Query record groups
  • Non-query record groups
  • Static record group

Q20. What is the control file used for?

Ans: It is used for -

i) Database recovery

ii) identifying database and redo log files that are necessary to be opened for  the database operation

Q21. What is the role of the optimizer in Oracle?

Ans: The optimizer determines an effective and efficient way to process a SQL statement based on the data in the table avoiding excessive I/O resources. 

Q22. What are the types of validations in Oracle EBS?

Ans:  There are various types of validation. They are as follows -

None - None type is used to allow users to enter values falling under the value set of formatting rules. A segment using this value set can't use flexfield value security rules.

Table - Inputs are checked as per the values that are already present in the application table

Special - These values make use of flex field

Pair - Group of values that make use of flex fields

Independent - Input should be present in the value set defined previously

Dependent - According to the previous value, inputs are compared with the subset of values

Translatable Independent - in this validation rule, a value can be used only if there is any existence of input in the previous list

Translatable Dependent - This validation rule compares the input with the subset of values related to the previously defined list

Q23. Define the steps for customizing the form?

Ans:  You need to follow certain steps for the purpose of customizing forms. They are -

  • The first step is to copy the file template.fmb and Appsatnd.fmb and paste inside the custom directory.  By doing so, a library associated with the particular task gets copied by its own
  • Now, create forms and customize them
  • Save the created forms where you want them to locate

Q24. What is MRC ( Multiple Reporting Currency)?

Ans: MRC is a feature associated with the oracle application that helps in reporting and maintaining records related to the transaction level in several forms of functional currency.

Q25. What is Oracle EBS?

Ans:  Oracle EBS (E-Business Suite) is a collection of integrated business applications such as SCM, ERP, and CRM that help businesses in resource planning, customer relationship management, and supply chain management. 

Q26. What is the ERP system Oracle?

Ans:  Oracle ERP (Enterprise Resource Planning) is a cloud-based software solution used to manage day-to-day business activities. This amazing business management software suite includes financial management, accounting, procurement, supply chain management, and project management.

Q27. Differentiate between flexfield qualifier and segment qualifier?

Ans:  Flexfiled qualifier identifies segment in a flexfield whereas segment qualifier identifies value in a segment.

  • Types of Flex field qualifier
  • Balancing segment qualifier
  • Cost center
  • Natural account and
  • Intercompany
  • Segment qualifier allows:-
  • Budgeting, Posting
  • Account Type
  • Control Account and
  • Reconciliation flag

Q28. How to know whether Multi-org is installed or not?

Ans: SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS

If MULTI_ORG_FLAG is set to ‘Y’, its multi org else not

Q29. What is multi-org?

Ans:  It is data security functionality available in Oracle 10.6 and above that allows multiple operating units to be defined within a single installation of Oracle Applications products.  This Multi-org architecture is an application server-side enhancement that keeps each operating unit's data separate and secure.

Q30. How to “write” to the concurrent request Log and Output file?

Ans:  FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, );

Q31. What are tablespace and its types?

Ans: An Oracle 11g database requires the following tablespaces -

System Tablespace - It is created when the database is installed and holds data dictionary tables owned by the SYS account.

Undo Tablespace - It holds undo (rollback) information used to track database changes

Temporary Tablespace - It is used to sort data while it is being processed.

Q32. What are a responsibility, Menu, and Request group and how are they related?

Ans:

Responsibility - A responsibility is a set of authority that permits users to access the functionality appropriate to their roles.

Menu – A menu is a hierarchical arrangement of functions that appears in the Navigator. Every responsibility has a menu assigned to it.

Request Group –  Request group is a collection of reports/concurrent programs in order to control user access. Only a system administrator is able to create a request group.

Q33. What are the types of Concurrent Managers 25? 

Ans: There are three MASTER CONCURRENT MANAGERS:

1. Internal Concurrent Manager (ICM)- Monitors all other CMs

2. Standard Manager (SM)- Manages report running and batch jobs

3. Conflict Resolution Manager (CRM) - checks concurrent program definitions for compatibility checks.

Q34. Is it possible to submit a concurrent request directly from the operating system?

Ans:  To submit the report directly, we need to follow some steps -

  • First of all, write a Shell script.
  • Then, log in to the database
  • Run the function FND_REQUEST.Submit()

Q35. What is a Formula column?

Ans: A formula column is used to perform the user-defined computation for other columns such as placeholder columns. 

Q36. What is ABC analysis and why is it used?

Ans: ABC analysis is used to categorize items into three different classes ie' A, B, and C where A is the most valuable and C is the least. Through this analysis, it becomes easy to monitor and keep track of the valuable items.

Q37. What is the picking rule in inventory?

Ans: Picking rule is used to find out the total items for sale order on the basis of revision, Lot, Locator, and Sub inventory.

Q38.  Is it possible to change the item name once it is created?

Ans: Yes, we can change the item name at the master level.

Q39. Is inventory Master org mandatory?

Ans: Yes, inventory master-org is mandatory because we do not create a specific master-org, then the system will consider inv org as its master org.

Q40. What is the different status attributes in Item?

Ans: There are following are the attributes

  • BOM Enabled
  • Build-in WIP
  • Invoice
  • Purchasable
  • Stackable
  • Transactable
  • Customer order enabled
  • Internal Order enabled

 

These were some of the most asked Oracle EBS interview questions. We hope that the article was helpful for you in preparing for the interview.