Oracle Apps R12 Technical & Financials Interview Q&A Videos

Oracle Apps R12 Technical & Financials Interview Questions and Answers

• What is ERP

• What is Architecture of ERP

• What are the Different Types of API'S for Customer Interface

• What are the Parameters in PLSQL Stored Procedures

• What are the Steps Required for Customizing the Form

• What are the Steps Required for Attaching Report with Oracle Applications

• What is Data Link

• In which Tables the Flexfields are Stored

• What is the Difference Between Key Flexfield and Descriptive Flexfield

  
  

• Which Procedure should be called to enable a Descriptive Flexfield

  
  

• What is the Difference between Flexfield Qualifier and Segment Qualifier

  
  

• Where do the Concurrent Request Logfile and Output file go

  
  

• What is Apps Schema. Differentiate Apps Schema and other Schemas

  
  

• What is the Purpose of US Folder in Appl Directory

  
  

• Explain Custom.pll, forms, reports, sql loader, control file

  
  

• When will we use custom.pll

  
  

• How do you find whether Multiorg is Installed

  
  

• What are the Data Handlers

  
  

• What are the Steps for Customizing the Standard Oracle Report

  
  

• Difference between Bind Parameter and Lexical Parameter

  
  

• How to find the Report short name for customizing the report

  
  

• what is the structure of visappl

  
  

• How to migrate the custom tables from 11.5.10 to r12

  
  

• What is the Difference between Conversion and Interface

  
  

• How to register a table and columns through backend

  
  

• Explain the Functions fnd_req, submit_req

  
  

• What are Cursors, where we have to use

  
  

• Explain about the Report triggers

  
  

• What is token

  
  

• What are the Steps Required for Registering the Report into Apps

  
  

• What are Security Attributes, Profiles

  
  

• What are the Steps for Developing the Flexfields

  
  

• What are Profile Options. At what level we setup the profile options

  
  

• How can you know the form(fmb) name

  
  

• What is the Relation between Responsibility, Menu and Request Group

  
  

• What is a Function, Appl_top

  
  

• What are the Supported Version of Forms and Reports Used for Developing an Oracle Apps Release 11i/r12

  
  

• What is the responsibility, request group, dff

  
  

• What is a Data Group and where we have to use

  
  

• What is Responsibility

  
  

• What is E Business Suite

  
  

• What are Different Types of Responsibilities

  
  

• What is a Template

  
  

• What is the adhoc report

  
  

• What is Value Set

  
  

• What are the Different Validations Types

  
  

• What is Multi Org Structure

  
  

• What is the Maximum number of records we can display in one page in xml reports

  
  

• What is Primary Ledger

  
  

• How can we call standard interface program

  
  

• Where can you find the release name from backend

  
  

• Tell me what are the base tables  in AR Module

  
  

• Where do we create tables, sequence

  
  

• Where do we create views, procedures and new profile options

  
  

• What is Formula Column and Summary Column

  
  

• TCA (Trading Community Architecture)

  
  

• What is Flex Mode and Confine Mode 

  
  

• What is Place holder Column

  
  

• What is Apps Architecture

  
  

• What are the API's

  
  

• Difference between Application Developer and System Administrator

  
  

• Use of Triggers in Forms and Types of Triggers 

  
  

• What is TCA (Trading Community Architecture)

  
  

• Difference Between Inbound and Outbound Interfaces 

  
  

• Form Personalization

  
  

• What is MRC (Multiple Reporting Currency)

  
  

• What are the Different Types of Interfaces

  
  

• What is the Difference between Operating Unit and Inventory Organization

  
  

• What is Item Validation Organization

  
  

• What is XML Report. Difference between BI Publisher and XML

  
  

• How do you Display the Company Logo

  
  

• What is a Data Template

  
  

• Name Some Business Cases in BI Reports

  
  

• What is the Role of Work Flow in Oracle Applications

  
  

• How We Can Download the Work Flow Files from Oracle Applications without Backend

  
  

• What are the Steps Involved in Developing of Oracle Work Flow

  
  

• What is Work Flow and Benefit's of Using Work Flow

  
  

• What is Performer in Oracle Work Flow

  
  

• Where do you Register Data and Layout Templates

  
  

• What does Lexical Section Contains

  
  

• How Do You Move Your Layout and Data Template Across Instances

  
  

• How many flex fields are there in Oracle Financials

  
  

• What are the benefits of flex fields

  
  

• What is segment qualifier

  
  

• Implication of dynamic inserts

  
  

• What is key flex field qualifier

  
  

• Types of key flex field qualifiers

  
  

• What is short hand aliases

  
  

• What is a period in oracle general ledger and types of periods

  
  

• What is value set security type

  
  

• What are the types of value sets

  
  

• What are the cross validating rules

  
  

• What is a value set and value set list types

  
  

• What are the types of flex fields

  
  

• Difference between key and descriptive flex fields

  
  

• What are the essential components of GL primary ledger

  
  

• What are concepts used during definition

  
  

• How many types of conversion rates are there in general ledger

  
  

• What is retained earnings account

  
  

• What is the purpose of translation adjustment account

  
  

• Different statuses of accounting periods

  
  

• What is a adjusting period and its implication

  
  

• What are the steps for creating primary ledger

  
  

• Ledger options

  
  

• What are the journal types

  
  

• Integrating journal entries with general ledger module

  
  

• Define Accounting cycle

  
  

• What is accounts payable

  
  

• What is the meaning of invoice

  
  

• P2P cycle flow

  
  

• Sample process flow for p2p cycle

  
  

• Pay cycle

  
  

• How many types of purchase orders and agreements are there

  
  

• Difference between AP invoice and AR invoice

  
  

• What is invoice

  
  

• Types of invoice

  
  

• Difference between standard invoice and mixed invoice

  
  

• What is pre payment in AP

  
  

• Types of AP invoices

  
  

• Difference between debit memo and credit memo

  
  

• What is invoice validation process

  
  

• Explain the receipt routing methods

  
  

• What are the purchasing modes in receiving

  
  

• What are the different matching levels, explain them

  
  

• What is payment terms and how to define payment terms

  
  

• What are the different types of transaction types in receivables

  
  

  
  

Who should take this course

Any Professional with Basic Knowledge on SQL, PL/SQL and Financials Concepts