Oracle Apps R12 Technical Interview Questions and Answers

Oracle Apps R12 Technical 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

Who should take this course

Any Professional with Basic Knowledge on SQL and PL/SQL