Oracle apps R12 interview Question and Answers

  Here are some common Oracle E-Business Suite R12 interview questions along with brief answers to help you prepare for your interview:

  1. What is Oracle E-Business Suite R12, and how is it different from previous versions?

    Answer: Oracle E-Business Suite R12 is an integrated suite of business applications that includes modules for financials, supply chain management, human resources, and more. R12 introduced major enhancements like a unified web-based interface and significant updates to various modules.


  3. Explain the purpose of the Chart of Accounts in Oracle E-Business Suite.

    Answer: The Chart of Accounts is a structured list of ledger accounts used to record financial transactions. It helps organize and categorize financial data for reporting and analysis purposes.


  5. What is the difference between a Key Flexfield (KFF) and a Descriptive Flexfield (DFF)?

    Answer: A Key Flexfield is a mandatory structure that uniquely identifies an entity, such as an account code, while a Descriptive Flexfield captures additional information about the entity for customization and additional details.


  7. How does Multi-Org support multiple operating units in Oracle Apps R12?

    Answer: Multi-Org allows organizations to represent multiple operating units, divisions, or business entities within a single instance of Oracle E-Business Suite while maintaining data segregation and distinct business rules.


  9. What is a Concurrent Program, and how do you create one in Oracle E-Business Suite?

    Answer: A Concurrent Program is a background process that performs specific tasks. To create one, you define the program, specify parameters, attach a concurrent program executable, and associate it with a request group.


  11. Explain the purpose of the AutoConfig utility in Oracle E-Business Suite R12.

    Answer: AutoConfig is a utility used for configuring and managing the configuration of Oracle E-Business Suite R12. It helps automate the process of creating and maintaining configuration files.


  13. How do you set up data security for users and responsibilities in Oracle Apps R12?

    Answer: Data security in Oracle Apps R12 is set up using data security profiles, data security policies, and data security rules, which restrict access to specific data based on user roles and responsibilities.


  15. What are Profile Options in Oracle E-Business Suite, and how are they used?

    Answer: Profile Options are parameters used to customize and control the behavior of the Oracle E-Business Suite. They allow you to set preferences and configurations for various aspects of the application.


  17. Explain the purpose of a Request Set in Oracle E-Business Suite, and how do you create one?

    Answer: A Request Set is a collection of concurrent requests that can be run simultaneously. To create one, you define a request set, add concurrent requests to it, and specify their parameters.


  19. What are the major components of the Procure-to-Pay (P2P) cycle in Oracle E-Business Suite?

    Answer: The P2P cycle includes steps like requisitioning, purchasing, receiving, invoicing, and payment. Each of these steps is typically supported by different modules in Oracle E-Business Suite, like Purchasing, Payables, and Inventory.

Comments

Post a Comment

Popular posts from this blog

Accounting entries of P2P cycle in Oracle R12

 The Procure-to-Pay (P2P) cycle in Oracle R12 involves various transactions that generate accounting entries as goods and services are purchased, received, and paid for. Below is a detailed breakdown of the typical accounting entries generated during each step of the P2P cycle: 1. Purchase Order Creation When a Purchase Order (PO) is created, there are no accounting entries recorded immediately. The creation of a PO is a commitment to purchase and does not impact the financials until the goods or services are received. 2. Receipt of Goods or Services (Receiving Transaction) When goods or services are received, accounting entries are generated to reflect the receipt in inventory or as an expense. The entries depend on whether the receipt is for inventory or direct charge (expense) items. a. Inventory Receipt (Accrual-Based) Dr. Inventory Material (Asset) Reflects the increase in inventory. Cr. Accrual (Receiving Inventory or Purchase Price Variance Account) Represents the liability...
Read more

Multi Org in Oracle ERP R12

Image
Multi-Org means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. There are Hierarchy Flow of Multi-Org -  1. Business Group - This is highest level in the Organization Structure. The Business group secures HR     Information. Multiple set of books can share same business group.  2. Legal Entity - It is a legal Business purpose, At this Level we prepared income tax reports.  3. Ledger - It is use to secure Journal and Ledger Balances of a company. A Ledger is a collection of   Currency, chart of account, calendar and accounting Methods.  4. Operating Unit - It is a strategic business unit, At this level we partition and secure sales and purchase   transaction data.  5. Inventory Organization - An Organization for which you track Inventory transactions and balances   and/or an Organization that manufactures or distributes products. ...
Read more

Accounting entries of O2C cycle in Oracle R12

 The Order-to-Cash (O2C) cycle in Oracle R12 involves various transactions that generate accounting entries as goods or services are sold, shipped, invoiced, and payment is collected. Below is a detailed breakdown of the typical accounting entries generated during each step of the O2C cycle: 1. Sales Order Creation When a Sales Order (SO) is created, no accounting entries are generated. The order creation is a commitment from the customer and does not affect the financials until the goods or services are delivered or invoiced. 2. Shipping of Goods (Shipping Transaction) When goods are shipped to the customer, accounting entries are generated to reflect the reduction in inventory and the recognition of the Cost of Goods Sold (COGS). Dr. Cost of Goods Sold (COGS) Reflects the cost of the goods that are shipped to the customer. Cr. Inventory (Asset) Reduces the inventory account to reflect the goods leaving the inventory. 3. Invoicing the Customer (Invoice Creation) When an invoice is...
Read more