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

Rating Distribution

• 1 stars: 1 votes
• 2 stars: 0 votes
• 3 stars: 6 votes
• 4 stars: 3 votes
• 5 stars: 5 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!