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 2021.
Are you interested in learning Oracle EBS from experts? Visit here Oracle EBS Training
Ans: There are five main types of report triggers available in the Oracle and they are -
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.
Ans: There are two types of patched - Optach and Adpatch. They are used to resolve various issues such as
Ans: No, the changes that are made into a Workday calendar will come into action only after Building the Calendar.
Ans: Reasons for the line to be backorders are
Ans: Following are the control options in inventory -
Ans: Following are the different flex fields in oracle inventory -
Ans: There are five planning methods in inventory -
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.
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.
Ans: To create a service contract, you need to follow the below-given steps-
Ans: The contract lifecycle includes
Ans: A Concurrent program is an instance that is executed along with incompatibles and parameters.
Ans: A token is used to transfer values towards the report builder and they are usually not the case–sensitive.
Ans: There are different types of triggers associated with forms and they are
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.
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.
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.
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 -
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
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.
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 the 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
Ans: You need to follow certain steps for the purpose of customizing forms. They are -
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.
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.
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.
Ans: Flexfiled qualifier identifies segment in a flexfield whereas segment qualifier identifies value in a segment.
Ans: SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to ‘Y’, its multi org else not
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.
Ans: FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, );
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.
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.
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.
Ans: To submit the report directly, we need to follow some steps -
Ans: A formula column is used to perform the user-defined computation for other columns such as placeholder columns.
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.
Ans: Picking rule is used to find out the total items for sale order on the basis of revision, Lot, Locator, and Sub inventory.
Ans: Yes, we can change the item name at the master level.
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.
Ans: There are following are the attributes
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.