Oracle Apps Technical Training

 >>  Oracle Apps Technical Training

Oracle Apps Technical Training


 (5) | 1500 Ratings


Introduction


Oracle Apps Technical Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Oracle Apps Technical Modules

ERP Concepts

  • What is ERP?
  • WHY ERP?
  • ERP Vendors
  • About Oracle Application & SAP
  • About Oracle Application Projects

Types Of Project

  • Implementation of Projects
  • Up Gradation of Projects
  • Supporting Project
  • Rollout Project

Oracle Application Positions Hierarchies

  • Functional Consultant & Roles
  • Technical Consultant & Roles
  • Techno- Functional Consultant & Roles
  • Oracle Application DBA & Roles
  • Oracle Applications 11i/R12 Architecture
  • Three Tier Architecture Components

Oracle Application 11i/R12 File System

  • What is ERP?
  • WHY ERP?
  • ERP Vendors
  • About Oracle Application & SAP
  • About Oracle Application Projects

 Using AD_DD Package To Register Database Component In AOL

  • Registering Custom Concurrent Programs based on Reports
  • Sql scripts
  • PL/SQL Stored Procedures
  • Registering a Custom Report in Oracle Application with or without parameters
  • Profile Option in Oracle Applications

AIM Documentation Preparation

  • MD 70, MD120, CV 60 and TE20
  • Reports 6i/10g in Oracle Applications
  • Introduction and Usage of USER_EXITS
  • Developing a Report from scratch as per Client Requirement
  • Developing a Report based on MD 50 Document (Reports in GL, AP, PO, INV)
  • Multi-Org & MOAC Concepts in Oracle Application 11i/R12
  • Customization of Oracle Standard Reports

Flex Fields And Value Sets

  • Flex Fields and Types of Flex fields
  • Value Sets and Types of Value Sets
  • Usage of $FLEX and $PROFILE

Oracle Application Interface

  • Inbound Interface
  • About Interface and Scenarios
  • Interface Tables and Error Tables
  • Sql * Loader
  • Standard Gl Interface and Po Requisition
  • Writing Validation Programs
  • Outbound Interface

Data Migration/Data Extractions

  • Extracting data from source Instance to Repository Instance
  • Functional Concepts
  • Procure To Pay Life Cycles
  • Order to Cash Cycles
  • FA To General Ledger Cycles
  • Technical Data Flow from Front End to Back End

Slam

  • About Sub Ledger Accounting (SLA)
  • TCA in R11i and R12i
  • Banks
  • Suppliers
  • Tables in R12i and R11i
  • General Ledger in R11i and R12i with tables
  • About Multi-Org Access Control
  • MOAC Reports

XML Publisher

  • Difference between XML Publisher Report and Oracle Reports 6i/10g/11g
  • About XML Publisher Report and Template Builder
  • Creation of New Report in XML Publisher
  • Registration of XML Publisher Reports in Oracle Applications
  • Template features
  • Conditional Formatting
  • Sub Template
  • IF Condition
  • IF THEN ELSE condition
  • Oracle Discoverer 10g

Oracle Apps Forms

  • Work Discoverer Desktop
  • Form registration
  • Template.fmb
  • Appstand.fmb
  • Form development using templates
  • Form customization concepts
  • Form Registration Process
  • Custom.Pll
  • Using function Zoom_available( )
  • Using procedure Event( )
  • Real Time Live Project
  • Implementation Methodology and Supporting Process
  • Real Time Reports/Interface/conversion/Customization
  • SQL and PLSQL Performance Methodology
  • Covering Oracle Financials + Oracle India Localization Financials
  • 100% Placement assistance
  • Mock Interviews and FAQ’s
  • Resume Preparation
  • Real Time help after getting job

 

Exam & Certification

0

Course Review

(5)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Oracle Apps Technical Modules

ERP Concepts

  • What is ERP?
  • WHY ERP?
  • ERP Vendors
  • About Oracle Application & SAP
  • About Oracle Application Projects

Types Of Project

  • Implementation of Projects
  • Up Gradation of Projects
  • Supporting Project
  • Rollout Project

Oracle Application Positions Hierarchies

  • Functional Consultant & Roles
  • Technical Consultant & Roles
  • Techno- Functional Consultant & Roles
  • Oracle Application DBA & Roles
  • Oracle Applications 11i/R12 Architecture
  • Three Tier Architecture Components

Oracle Application 11i/R12 File System

  • What is ERP?
  • WHY ERP?
  • ERP Vendors
  • About Oracle Application & SAP
  • About Oracle Application Projects

 Using AD_DD Package To Register Database Component In AOL

  • Registering Custom Concurrent Programs based on Reports
  • Sql scripts
  • PL/SQL Stored Procedures
  • Registering a Custom Report in Oracle Application with or without parameters
  • Profile Option in Oracle Applications

AIM Documentation Preparation

  • MD 70, MD120, CV 60 and TE20
  • Reports 6i/10g in Oracle Applications
  • Introduction and Usage of USER_EXITS
  • Developing a Report from scratch as per Client Requirement
  • Developing a Report based on MD 50 Document (Reports in GL, AP, PO, INV)
  • Multi-Org & MOAC Concepts in Oracle Application 11i/R12
  • Customization of Oracle Standard Reports

Flex Fields And Value Sets

  • Flex Fields and Types of Flex fields
  • Value Sets and Types of Value Sets
  • Usage of $FLEX and $PROFILE

Oracle Application Interface

  • Inbound Interface
  • About Interface and Scenarios
  • Interface Tables and Error Tables
  • Sql * Loader
  • Standard Gl Interface and Po Requisition
  • Writing Validation Programs
  • Outbound Interface

Data Migration/Data Extractions

  • Extracting data from source Instance to Repository Instance
  • Functional Concepts
  • Procure To Pay Life Cycles
  • Order to Cash Cycles
  • FA To General Ledger Cycles
  • Technical Data Flow from Front End to Back End

Slam

  • About Sub Ledger Accounting (SLA)
  • TCA in R11i and R12i
  • Banks
  • Suppliers
  • Tables in R12i and R11i
  • General Ledger in R11i and R12i with tables
  • About Multi-Org Access Control
  • MOAC Reports

XML Publisher

  • Difference between XML Publisher Report and Oracle Reports 6i/10g/11g
  • About XML Publisher Report and Template Builder
  • Creation of New Report in XML Publisher
  • Registration of XML Publisher Reports in Oracle Applications
  • Template features
  • Conditional Formatting
  • Sub Template
  • IF Condition
  • IF THEN ELSE condition
  • Oracle Discoverer 10g

Oracle Apps Forms

  • Work Discoverer Desktop
  • Form registration
  • Template.fmb
  • Appstand.fmb
  • Form development using templates
  • Form customization concepts
  • Form Registration Process
  • Custom.Pll
  • Using function Zoom_available( )
  • Using procedure Event( )
  • Real Time Live Project
  • Implementation Methodology and Supporting Process
  • Real Time Reports/Interface/conversion/Customization
  • SQL and PLSQL Performance Methodology
  • Covering Oracle Financials + Oracle India Localization Financials
  • 100% Placement assistance
  • Mock Interviews and FAQ’s
  • Resume Preparation
  • Real Time help after getting job

 

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry