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

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 0 votes
• 3 stars: 0 votes
• 4 stars: 1 votes
• 5 stars: 0 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!