Oracle Apps R12 Technical Course +Interview Questions
4.6 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10 students enrolled

Oracle Apps R12 Technical Course +Interview Questions

Oracle Apps R12 Technical Online Training Course + Interview Questions and Answers with Live Meeting Support
4.6 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10 students enrolled
Created by koduru sridevi
Last updated 11/2019
English
Price: $34.99
30-Day Money-Back Guarantee
This course includes
  • 25.5 hours on-demand video
  • 1 article
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Oracle Apps R12 Technical Course
  • Oracle Apps R12 Technical Interview Questions Explained through Videos
Requirements
  • Basic Knowledge on SQL and PLSQL
Description

Oracle Apps Technical Course + Interview Questions Explained Clearly through Videos Course Bundle with Live Meeting Support to clear your queries on every Sunday. You will receive the meeting link for the support session on every Friday to your Udemy registered mail id through Udemy educational announcement mails.


1. Oracle Apps R12 Technical Course

2. Interview Questions on Oracle Apps R12 Technical Explained through Videos

Please find the below details

1. Oracle Apps R12 Technical Online Training Videos  

Oracle Apps R12 Technical is the Enterprise Resource Package (ERP) package. It has designed on the base of Generally Acceptable Accounting Principles (GAAP). This Oracle Application has the business software or else application software of the Oracle Corporation.

Oracle Apps Technical Course is a collection of complete end-to-end solutions that serve businesses with their own functionality. Oracle Apps Technical Video Tutorials Course provides an in-depth explanation on the technical module of data integration. This module makes you understand the architecture, table relations, designing reports and forms using Oracle Apps.

From oracle apps technical course content, you get a clear idea of

Types of Roles, Application Object Library, Application Development, Registration of Custom Objects, Interfaces and Conversions, Flex fields, Profiles, Value Sets, Multi-org Concepts, Functional Modules Overview, Reports and Forms in Oracle Applications and development of XML Reports.

There are incredible job opportunities for the desired aspirants with highest paid salary range. It will be a great career advantage by taking Oracle Apps Technical Course.

Who should take this oracle Apps technical course

Any Professional with Basic Knowledge on SQL and PL/SQL


2. Oracle Apps Technical Interview Questions are Clearly Explained through 40+ Videos

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

Who this course is for:
  • Any Professional with Basic Knowledge on SQL and PLSQL
Course content
Expand all 65 lectures 25:16:49
+ Oracle Apps R12 Technical Course
28 lectures 16:30:55

Introduction to oracle apps technical, The details of the training contents explained 

Preview 32:54
  • Definition of ERP

  • Introduction to Oracle Applications

  • Types of Data

Definition of ERP Introduction to Oracle Applications Types of Data
36:07
  • Functional Consultant and Roles

  • Technical Consultant and Roles

  • DBA and Roles

  • Types of Projects

Functional Consultant and Roles Technical Consultant and Roles DBA and Roles
40:43
  • Oracle Application Architecture

  • Data Base Structure of Oracle Applications

  • Introduction to Rice Components

Preview 48:18
  • System Administration and Application Object Library (AOL)

  • Defining Application Users and Assigning the Responsibilities

  • Creating Responsibilities

System Administration and Application Object Library (AOL) Defining Application
51:14
  • FND Tables and Understanding AOL and its Components

  • Registration of Tables

  • Using AD_DD Package

  • Procedures to Register Database Tables in AOL Module

FND Tables and Understanding AOL and its Components Registration of Tables Usi
29:48
  • Report Registration Steps

  • Register the Report in AOL Module

  • Executable Creation of Reports

Report Registration Steps Register the Report in AOL Module Executable Creatio
39:17
  • Defining the Concurrent Program

  • Creation of Request Group

Defining the Concurrent Program Creation of Request Group
33:03
  • Register the Parametric Report in AOL Module

  • Introduction to Report Parameters

  • Types of Parameters

  • Creating Value Sets

  • Value Set Default Types

Register the Parametric Report in AOL Module Introduction to Report Parameters
48:55
  • Developing a Report from Scratch as per Client requirement

  • Default Report Styles

  • Customization of Oracle Standard Reports

Developing a Report from Scratch as per Client requirement Default Report Style
31:04
  • Introduction to Forms

  • Form registration in Oracle Applications

Introduction to Forms Form registration in Oracle Applications
25:26
  • Creating Functions in AOL Module

  • Creation of New Menu

  • Oracle Application Default Menus

Creating Functions in AOL Module Creation of New Menu Oracle Application Defau
35:01
  • Introduction to Template.FMB

  • Appstand.FMB

  • Introduction to Predefined Objects in Template.FMB

Introduction to Template.FMB Appstand.FMB Introduction to Predefined Objects i
36:29
  • Creating of New Template

  • Creating of New Block, Canvas in Template

  • Registration Steps for Template

Creating of New Template Creating of New Block, Canvas in Template Registratio
45:50
  • Overview of Flex Fields

  • Types of Flex Fields

  • Introduction to Key and Descriptive Flex Fields

Overview of Flex Fields Types of Flex Fields Introduction to Key and Descripti
27:32
  • Steps for Creation of DFF

  • Flex Field Tables and Relations

Steps for Creation of DFF Flex Field Tables and Relations
41:44
  • Overview of Profiles Options

  • Different Levels in Setting Profiles

  • Some Important Profile Options

  • Steps in Setting Profile Options

Overview of Profiles Options Different Levels in Setting Profiles Some Importa
25:53
  • Multiple Organization Concepts

  • Introduction to Multi Org

  • What is Multi Org and Why we need it

  • Defining Multi Org Structure

Multiple Organization Concepts Introduction to Multi Org What is Multi Org and
44:18

Defining Multi Org Structure Continued in this Session

Defining Multi Org Structure Continued in this Session
53:48
  • Multi Org Tables

  • Overview of Procure to Pay (P2P Cycle)

  • Overview of Order to Cash (O2C Cycle)

  • Overview of Important Tables in PO, Inventory, OM, AP, AR, GL

Multi Org Tables Overview of Procure to Pay (P2P Cycle) Overview of Order to C
28:45
  • Introduction to Interfaces

  • Difference between Interfaces and Conversions

  • Types of Interfaces

  • Inbound Interfaces

  • Using SQL * Loader

Introduction to Interfaces Difference between Interfaces and Conversions Types
33:01
  • Working with Staging Table Scripts

  • Developing Validations Package

  • Interface Tables and Error Tables

Working with Staging Table Scripts Developing Validations Package Interface Ta
39:48
  • Introduction to Conversions

  • Conversion Flow

Introduction to Conversions Conversion Flow
23:08
  • Introduction to AIM Documentation

  • Preparation of AIM Documents

Introduction to AIM Documentation Preparation of AIM Documents
28:20
  • Introduction to Business Documents

  • Preparation of MD 50 and MD 70 Documents

Preview 08:47
  • Functional Flows of GL, AP, AR, 

  • Back End Tables

Functional Flows of GL, AP, AR,  Back End Tables
30:24
  • Introduction of XML Reports

  • Developing XML Reports

Introduction of XML Reports Developing XML Reports
24:11
  • Steps for Registering the XML Reports in AOL Module

  • Back End Tables

Steps for Registering the XML Reports in AOL Module Back End Tables
47:07
+ Oracle Apps R12 Interview Questions Videos
36 lectures 08:45:54

What is ERP

Architecture of ERP

Preview 21:52

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

What are the Parameters in PLSQL Stored Procedures

What are the Different Types of API'S for Customer Interface What are the Param
13:20

What are the Steps Required for Customizing the Form

What are the Steps Required for Attaching Report with Oracle Applications

What are the Steps Required for Customizing the Form What are the Steps Require
12:44

What is Data Link

In which Tables the Flexfields are Stored

What is Data Link In which Tables the Flexfields are Stored
16:12

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 Key Flexfield and Descriptive Flexfield Which Pr
16:16

What is the Difference between Flexfield Qualifier and Segment Qualifier

Where do the Concurrent Request Logfile and Output file go

What is the Difference between Flexfield Qualifier and Segment Qualifier Where
18:26

What is Apps Schema. Differentiate Apps Schema and other Schemas

What is the Purpose of US Folder in Appl Directory

What is Apps Schema. Differentiate Apps Schema and other Schemas What is the Pu
08:06

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

When will we use custom.pll

Preview 15:04

How do you find whether Multiorg is Installed

What are the Data Handlers

How do you find whether Multiorg is Installed What are the Data Handlers
13:23

What are the Steps for Customizing the Standard Oracle Report

Difference between Bind Parameter and Lexical Parameter

What are the Steps for Customizing the Standard Oracle Report Difference betwee
11:06

How to find the Report short name for customizing the report

what is the structure of visappl

How to find the Report short name for customizing the report what is the struct
06:24

How to migrate the custom tables from 11.5.10 to r12

What is the Difference between Conversion and Interface

How to migrate the custom tables from 11.5.10 to r12 What is the Difference bet
12:47

How to register a table and columns through backend

Explain the Functions fnd_req, submit_req

How to register a table and columns through backend Explain the Functions fnd_r
19:28

What are Cursors, where we have to use

What are Cursors, where we have to use
11:15

Explain about the Report triggers

What is token

Explain about the Report triggers What is token
17:23

What are the Steps Required for Registering the Report into Apps

What are the Steps Required for Registering the Report into Apps
21:47

What are Security Attributes, Profiles

What are the Steps for Developing the Flexfields

What are Security Attributes, Profiles What are the Steps for Developing the Fl
17:27

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

How can you know the form(fmb) name

What are Profile Options. At what level we setup the profile options How can yo
15:59

What is the Relation between Responsibility, Menu and Request Group

What is a Function, Appl_top

What is the Relation between Responsibility, Menu and Request Group What is a F
11:59

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 are the Supported Version of Forms and Reports Used for Developing an Oracl
11:30

What is a Data Group and where we have to use

What is Responsibility

What is a Data Group and where we have to use What is Responsibility
16:40

What is E Business Suite

What are Different Types of Responsibilities

What is E Business Suite What are Different Types of Responsibilities
23:03

What is a Template

What is the adhoc report

What is a Template What is the adhoc report
20:10

What is Value Set

What are the Different Validations Types

What is Value Set What are the Different Validations Types
17:03

What is Multi Org Structure

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

What is Multi Org Structure What is the Maximum number of records we can displa
13:38

What is Primary Ledger

How can we call standard interface program

What is Primary Ledger How can we call standard interface program
17:43

Where can you find the release name from backend

Tell me what are the base tables  in AR Module

Where can you find the release name from backend Tell me what are the base tabl
12:05

Where do we create tables, sequence

Where do we create views, procedures and new profile options

Where do we create tables, sequence Where do we create views, procedures and ne
16:36

What is Formula Column and Summary Column

TCA (Trading Community Architecture)

What is Formula Column and Summary Column TCA (Trading Community Architecture)
10:16

What is Flex Mode and Confine Mode 

What is Place holder Column

What is Flex Mode and Confine Mode  What is Place holder Column
11:36

What is Apps Architecture

What are the API's

What is Apps Architecture What are the API's
13:09

Difference between Application Developer and System Administrator

Difference between Application Developer and System Administrator
12:55

Use of Triggers in Forms and Types of Triggers 

What is TCA (Trading Community Architecture)

Preview 11:50

Difference Between Inbound and Outbound Interfaces 

Form Personalization

Difference Between Inbound and Outbound Interfaces  Form Personalization
11:48

What is MRC (Multiple Reporting Currency)

What are the Different Types of Interfaces

What is MRC (Multiple Reporting Currency) What are the Different Types of Inter
10:56

What is the Difference between Operating Unit and Inventory Organization

What is Item Validation Organization

What is the Difference between Operating Unit and Inventory Organization What i
13:58
+ Study Material
1 lecture 00:00

Study Material

Study Material
00:00