Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle Apps R12 Technical Interview Questions and Answers
Rating: 3.8 out of 5(15 ratings)
87 students

Oracle Apps R12 Technical Interview Questions and Answers

Oracle Apps R12 Technical Interview Questions and Answers Videos Explained
Created byKoduru Sridevi
Last updated 6/2021
English

What you'll learn

  • Oracle Apps R12 Technical Interview Questions

Course content

1 section • 48 lectures • 10h 35m total length
  • What is ERP, Architecture of ERP21:52

    What is ERP

    Architecture of ERP

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

    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 Form12:44

    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 Stored16:12

    What is Data Link

    In which Tables the Flexfields are Stored

  • What is the Difference Between Key Flexfield and Descriptive Flexfield Which Pr16:16

    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 Where18:26

    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 Pu8:06

    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 c15:04

    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 Handlers13:23

    How do you find whether Multiorg is Installed

    What are the Data Handlers

  • What are the Steps for Customizing the Standard Oracle Report Difference betwee11:06

    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 struct6:24

    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 bet12:47

    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_r19:28

    How to register a table and columns through backend

    Explain the Functions fnd_req, submit_req

  • What are Cursors, where we have to use11:15

    What are Cursors, where we have to use

  • Explain about the Report triggers What is token17:23

    Explain about the Report triggers

    What is token

  • What are the Steps Required for Registering the Report into Apps21:47

    What are the Steps Required for Registering the Report into Apps

  • What are Security Attributes, Profiles What are the Steps for Developing the Fl17:27

    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 yo15:59

    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 F11:59

    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 Oracl11:30

    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 Responsibility16:40

    What is a Data Group and where we have to use

    What is Responsibility

  • What is E Business Suite What are Different Types of Responsibilities23:03

    What is E Business Suite

    What are Different Types of Responsibilities

  • What is a Template What is the adhoc report20:10

    What is a Template

    What is the adhoc report

  • What is Value Set What are the Different Validations Types17:03

    What is Value Set

    What are the Different Validations Types

  • What is Multi Org Structure What is the Maximum number of records we can displa13:38

    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 program17:43

    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 tabl12:05

    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 ne16:36

    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)10:16

    What is Formula Column and Summary Column

    TCA (Trading Community Architecture)

  • What is Flex Mode and Confine Mode What is Place holder Column11:36

    What is Flex Mode and Confine Mode 

    What is Place holder Column

  • What is Apps Architecture What are the API's13:09

    What is Apps Architecture

    What are the API's

  • Difference between Application Developer and System Adminstrator12:55

    Difference between Application Developer and System Administrator

  • Use of Triggers in Forms and Types of Triggers What is TCA (Trading Community A11:50

    Use of Triggers in Forms and Types of Triggers 

    What is TCA (Trading Community Architecture)

  • Difference Between Inbound and Outbound Interfaces Form Personalization11:48

    Difference Between Inbound and Outbound Interfaces 

    Form Personalization

  • What is MRC (Multiple Reporting Currency What are the Different Types of Interf10:56

    What is MRC (Multiple Reporting Currency)

    What are the Different Types of Interfaces

  • What is the Difference between Operating Unit and Inventory Organization What i13:58

    What is the Difference between Operating Unit and Inventory Organization

    What is Item Validation Organization

  • What is XML Report. Difference between BI Publisher and XML9:08

    What is XML Report. Difference between BI Publisher and XML

  • How do you Display the Company Logo8:59

    How do you Display the Company Logo

  • What is a Data Template9:02

    What is a Data Template

  • Name Some Business Cases in BI Reports11:15

    Name Some Business Cases in BI Reports

  • What is the Role of Work Flow in Oracle Applications8:12

    What is the Role of Work Flow in Oracle Applications

  • How We Can Download the Work Flow Files from Oracle Applications without Backend9:18

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

  • What are the Steps Involved in Developing of Oracle Work Flow9:28

    What are the Steps Involved in Developing of Oracle Work Flow

  • What is Work Flow and Benefit's of Using Work Flow7:56

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

  • What is Performer in Oracle Work Flow9:15

    What is Performer in Oracle Work Flow

  • Where do you Register Data and Layout Templates10:12

    Where do you Register Data and Layout Templates

  • What does Lexical Section Contains8:11

    What does Lexical Section Contains

  • How Do You Move Your Layout and Data Template Across Instances8:25

    How Do You Move Your Layout and Data Template Across Instances

Requirements

  • Knowledge on SQL and PLSQL

Description

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

Who this course is for:

  • Any Professional with Knowledge on SQL and PLSQL