Oracle Apps R12 Technical Training Bundle (Technical, D2K..)
3.8 (4 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.
12 students enrolled

Oracle Apps R12 Technical Training Bundle (Technical, D2K..)

Oracle Apps R12 Technical Training Bundle Includes SQL&PL/SQL, D2K(Forms&Reports 10g), Oracle Apps R12 Technical Course
3.8 (4 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.
12 students enrolled
Created by koduru sridevi
Last updated 8/2018
English
Current price: $46.99 Original price: $59.99 Discount: 22% off
30-Day Money-Back Guarantee
This course includes
  • 35.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Will be Learning SQL & PL/SQL
  • Will be Learning D2K Course

  • Will be Learning Oracle Apps R12 Technical Course

Requirements
  • Knowledge on ERP
Description


Oracle Apps R12 Technical Training Course Bundle includes SQL&PL/SQL, D2K (Forms & Reports 10g), Oracle Apps R12 Technical Course

SQL & PL/SQL Course Details

This course covers Introduction to RDBMS, Introduction to SQL, Oracle data types, classification of sql, DDL and DML Commands, Integrity Constraints, SQL Functions, Character Functions, Number Functions, Date  Functions, Group Functions, Joins, Sub Queries and Clauses, Database Objects, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages. 


Oracle D2K (Forms and Reports 10g) Course Details

From this course you will get a clear idea of 

Forms 10g and Role in Oracle Apps, Fundamentals of D2K, Creation of Data blocks Through wizard and Manually, Creation of Different Types of Canvases and Working with Canvases, Types of windows and working with windows and changing windows properties, Different types of Triggers, Working with Triggers and Applying to Different Controls, Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using Alerts, Creation of Editors, Types of Editors and Calling editors through Code, Creating and Using Object Groups . Creating and Using Object Libraries, Creation of Lov through wizard and Manually, Working with Lov Properties, Creation of Record Groups Based On Query and Using Static Values, Creation of Master-Detail Data Blocks, Parameters, Creation of Menus and attaching menus to Forms, Working with Procedures, Functions and Packages in Forms, Usage of PL/SQL Libraries in Forms and Attached Libraries, Reports 10g, Introduction to Reports . Fundamentals of Reports . Advantages, Features and role of Reports in D2K, Creation of Different types of Reports . Creation of Reports with different Parameters . User Parameters . System Parameters, Working with Formula Columns . Working with Summary Columns . Working with Place Holder Columns, Working with Data links, Developing Reports Manually, Reports in Triggers, Creation of Layout in Reports . Drill Down Reports . Calling Reports from Forms . Calling Reports from Reports.

Who should take this oracle D2K Course

PL/SQL Developer Forms Developer Application Developer Report Developer System Analyst Technical Consultant Business Intelligence Developer


Oracle Apps R12 Technical Course Details

Oracle Apps 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. The 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 this course, 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

The following software or industry professionals were deserved to take this Oracle Apps technical training.

senior architecture and developers java and non java background. senior IT Software professionals Freshers

The following job roles will get benefited from this course:

Functional Consultants Technical Consultants Business Analysts Finance Functional Implementers End Users Candidates interested in taking up a career under Oracle Related Jobs and Positions in the Industry

Who this course is for:
  • Any Graduate
Course content
Expand all 71 lectures 35:24:07
+ D2K (Oracle Forms & Reports 10g) Course
19 lectures 09:41:32
  • Oracle D2K | Oracle Forms and Reports Demo Session
Preview 20:36
  • Introduction to Forms 10g and Role in Oracle Apps
  • Fundamentals of D2K
Introduction to Forms 10g and Role in Oracle Apps, Fundamentals of D2K
22:20
  • Creation of Data blocks Through wizard and Manually
  • Creation of Different Types of Canvases and Working with Canvases
  • Types of windows and working with windows and changing windows properties
Creation of Data blocks Through wizard and Manually
35:15
  • Different types of Triggers
  • Working with Triggers and Applying to Different Controls
Different types of Triggers
38:58
  • Creation of alerts and Calling of Alerts 
  • Changing Properties at runtime and Re-using Alerts
Creation of alerts and Calling of Alerts
34:30
  • Creation of Editors, Types of Editors and Calling editors through Code
Creation of Editors, Types of Editors and Calling editors through Code
19:09
  • Creating and Using Object Groups
  • Creating and Using Object Libraries
Creating and Using Object Groups, Creating and Using Object Libraries
16:53
  • Creation of Lov through wizard and Manually
  • Working with Lov Properties
  • Creation of Record Groups Based On Query and Using Static Values
Creation of Lov through wizard and Manually
38:02
  • Creation of Master-Detail Data Blocks
Creation of Master-Detail Data Blocks
36:04
  • parameters
parameters
32:02
  • Creation of Menus and attaching menus to Forms
Creation of Menus and attaching menus to Forms
36:10
  • Working with Procedures, Functions and Packages in Forms
  • Usage of PL/SQL Libraries in Forms and Attached Libraries
Working with Procedures, Functions and Packages in Forms
34:21
  • Introduction to Reports
  • Fundamentals of Reports
  • Advantages, Features and role of Reports in D2K
Preview 23:52
  • Creation of Different types of Reports
  • Creation of Reports with different Parameters
  • User Parameters
  • System Parameters
Creation of Different types of Reports
37:33
  • Working with Formula Columns
  • Working with Summary Columns
  • Working with Place Holder Columns
Working with Formula Columns, Working with Summary Columns
38:30
  • Working with Data Links
Working with Data Links
34:09
  • Developing Reports Manually
Developing Reports Manually
33:46
  • Reports in Triggers
Reports in Triggers
17:43
  • Creation of Layout in Reports
  • Drill Down Reports
  • Calling Reports from Forms
  • Calling Reports from Reports
Creation of Layout in Reports, Drill Down Reports
31:39
+ Oracle Apps R12 Technical Course
28 lectures 16:22:36
  • Demo Session on Oracle Apps R12 Technical Course
Preview 24:35
  • 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
40:43
  • Oracle Application Architecture
  • Data Base Structure of Oracle Applications
  • Introduction to Rice Components
Oracle Application Architecture, Data Base Structure of Oracle Applications
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)
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
29:48
  • Report Registration Steps
  • Register the Report in AOL Module
  • Executable Creation of Reports
Report Registration Steps, Register the Report in AOL Module
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
Developing a Report from Scratch
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
35:01
  • Introduction to Template.FMB
  • Appstand.FMB
  • Introduction to Predefined Objects in Template.FMB
Introduction to Template.FMB, Appstand.FMB
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
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
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
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
44:18
  • Defining Multi Org Structure Continued in this Session
Defining Multi Org Structure Continued
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)
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
33:01
  • Working with Staging Table Scripts
  • Developing Validations Package
  • Interface Tables and Error Tables
Working with Staging Table Scripts, Developing Validations Package
39:48
  • Introduction to Conversions
  • Conversion Flow
Introduction to Conversions, Conversion Flow
23:08
  • Introduction to AIM Documentation
Introduction to AIM Documentation
28:20
  • Introduction to Business Documents
Introduction to Business Documents
08:47
  • Functional Flows of GL, AP, AR
Functional Flows of GL, AP, AR
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
Steps for Registering the XML Reports in AOL Module
47:07
+ Oracle SQL & PL/SQL Course
24 lectures 09:19:59
  • Introduction to RDBMS
  • Introduction to SQL
Preview 23:18
  • Oracle data types
  • classification of sql
Oracle data types
23:11
  • DDL and DML Commands
DDL and DML Commands
22:46
  • DDL and DML Commands Continued
DDL and DML Commands Continued
22:36
  • Integrity Constraints
Integrity Constraints
23:43
  • SQL Functions
  • Character Functions
  • Number Functions
SQL Functions, Character Functions, Number Functions
23:56
  • SQL Functions Continued
  • Date Functions 
  • Group Functions
SQL Functions Continued, Date Functions, Group Functions
19:45
  • Joins
Joins
27:33
  • Sub Queries and Clauses
Sub Queries and Clauses
26:41
  • Database Objects
Database Objects
23:00
  • Database Objects Continued
Database Objects Continued
20:14
  • DCL and TCL Commands
DCL and TCL Commands
22:44
  • Introduction to PL/SQL
Preview 21:40
  • Data Types and PL/SQL Blocks
Data Types and PLSQL Blocks
23:51
  • Looping Structures
Looping Structures
22:54
  • Looping Structure While and Nested Loops
Looping Structure While and Nested Loops
22:45
  • Looping Structure While and Nested Loops Continued
Looping Structure While and Nested Loops Continued
25:43
  • Conditional Statements 
Conditional Statements
25:18
  • Cursors
Cursors
27:57
  • Exceptions
Exceptions
25:20
  • Exceptions Continued
Exceptions Continued
19:07
  • Procedures
Procedures
24:21
  • Functions
Functions
19:39
  • Packages
Packages
21:57