Oracle Apps DBA Online Training

Oracle Apps DBA Online Training

  • ABOUT THE COURSE
    • Course Duration

      40 hours of live training by professionals with 5+ years of online training experience and industry experience.

      Training Materials

      1. Access to lab servers for practical sessions
      2. Support to install related software on individual laptop
      3. PowerPoint slides and career guidance in Oracle domain
      4. Soft copy of course and lab material

      What’s Needed To Join This Course?

      Student must have basic knowledge of Oracle database (SQL/PLSQL) and must be familiar with basics of oracle database. Should be familiar with data processing concepts and techniques.

      Who Are Ideal Candidates?

      Database administrators/designers, functional implementers, support engineers and freshers with basic knowledge of Oracle database can pursue this course.

      Course Info

      We train you on the latest version of the oracle database as oracle stops supporting older versions after new version is launched. We also guide you choose the right path. We also assist you with the oracle certification courses.

      Highlights Of The Course

      1. Engaging lectures by professionals and industry experts through high resolution video classes
      2. Practical examples and real time projects
      3. Overview of different applications of Oracle database courses in various industrial sectors
      4. Complete set of course material and life time access to course recordings

      Why NORTH TECH SYSTEMS?

      1. Best in class teaching style with focus on practical approach of implementation
      2. Expert lectures by professionals serving the IT industries in Oracle domain
      3. Affordable fee structure and career guidance
      4. Certification assistance after completing the course
  • CURRICULUM
    • Oracle Apps Technical Online Training

      Oracle Applications Technical Training Introduction to ERP

      1. Definition of ERP, Overview of popular ERP'S
      2. Comparison of Oracle Apps with other ERP'S
      3. Types of Roles
      4. Types of Projects
      5. AIM documentation standards
      6. Oracle Application Architecture
      7. Database structure of OA
      8. Using TOAD

      Application Object Library

      1. Creating Users
      2. WHO columns
      3. Creating Responsibilities
      4. Menu construction
      5. Request group construction

      Application development

      1. Defining concurrent program
      2. Concurrent programs with parameters
      3. Working with multiple concurrent programs
      4. Scheduling the Concurrent Program
      5. Concurrent Program incompatibilities
      6. Creating Request Set
      7. Procedure registration
      8. Value sets

      Reports registration

      1. Report development
      2. Report registration
      3. Parametric report registration
      4. Reports with repeating frames

      Module Overviews

      1. Inventory Module flow with base tables
      2. Accounts Payable module flow with base tables
      3. Accounts Receivable module flow with base tables
      4. Order Management module flow with base tables

      Form registration

      1. Template.fmb
      2. Appstand.fmb
      3. Form development using templates
      4. Form customization concepts
      5. Form Registration Process
      6. Custom.Pll
      7. Using function Zoom_available( )
      8. Using procedure Event( )

      Interfaces

      1. Introduction to Interfaces
      2. Outbound Interfaces
      3. Using UTL_FILE package
      4. nbound Interfaces
      5. Using SQLLoader tool

      Conversions

      1. Overview on conversions
      2. Difference between Interfaces and conversions
      3. Working with staging table script
      4. Developing validations package
      5. Standards to be followed in conversions

      Flex Fields

      1. Types of Flex Fields
      2. Descriptive Flex Fields
      3. Key Flex Fields

      Workflows

      1. Introduction to workflow
      2. Workflow builder
      3. Attributes
      4. Creating Processes
      5. Sending notifications using workflows

      XML Publisher

      1. Introduction to XML Publisher
      2. Generating XML file using reports
      3. Creating Templates
      4. Creating Data Definitions

      Discoverer

      1. Introduction to Discoverer tool
      2. Discoverer Administrator
      3. Creating Business Areas
      4. Discoverer Desktop
      5. Creating EUL
      6. Creating work books
  • ROADMAP
    • Oracleonline_training

  • REVIEWS
    • “The trainer is well qualified and patient. He adjusted the classes as per my convenience and did not rush to finish the course. I am happily satisfied with the institute.” – Ashok
      “The trainer is very knowledgeable and planned the course very well. Completing course from this institute triggered my thirst to learn further levels of oracle concepts.” – Bhavani Guru Swami
  • FAQ's
    • Content will be coming soon

Copyrights @2018-All rights reserved