Best Oracle Apps Technical Online Training

Oracle Apps Technical Training

Oracle Apps Technical provides a basic understanding of database, file system, and architecture used in Oracle application release 11i. It details about multi-tier architecture used to provide user the Intranet or Internet, and also the relationship between Oracle applications and the Oracle database. It comprises of Oracle technical, Oracle workflow, and Oracle form developer and report developer.

 

❯ Introduction to ERP

  • ERP definition
  • Overview
  • Types of projects
  • Types of roles
  • Database structure

❯ Application object library

  • Creating users
  • Constructing menu
  • Creation of responsibilities
  • Constructing request group
  • WHO columns

❯ Application development

  • What is concurrent program
  • Parameters of concurrent program
  • Multiple concurrent programs
  • Scheduling the concurrent program
  • Request set creation
  • Registering the procedure
  • Value sets

❯ Oracle application positions hierarchies

  • Functional consultant
  • Roles of functional consultant
  • Technical consultant
  • Roles of technical consultant
  • Techno-functional consultant
  • Roles of techno-functional consultant
  • Oracle application DBA
  • Roles of Oracle application DBA
  • Architecture of Oracle applications 11i/R12
  • Three-tier architecture components

❯ Oracle application interface

  • What is interface
  • Interface tables
  • Error tables
  • Inbound interface
  • SQL*Loader
  • Outbound interface

❯ Conversions

  • What is conversion
  • Conversion approach
  • Difference between interface/conversion/data migration
  • Conversion package standards
  • API’s approach
  • Interface table approach

❯ Oracle apps technical

  • Case study
  • Exercises
    sample applications

❯ Flex fields

  • What is a flex field
  • Types of flex fields
    • Descriptive
    • Key

❯ Technical architecture

  • Software used in application building
  • Overview of three-tier architecture
  • User tier
  • Architecture of user tier
  • Architecture of application tier
  • Architecture of database tier
  • Tools used

❯ Application access, navigations, and commands

  • Overview of application access
  • Overview of user
  • Overview of responsibility
  • Overview of menu and data
  • Overview of basic features and navigation

❯ Oracle apps forms

  • Form registration
  • Form development using templates
  • Form customization concepts
  • Form registration process
  • Work discoverer desktop
  • Real-time live project
  • Implementation methodology
  • Supporting process
  • Real-time reports

❯ Overview of table and form relationship

  • Overview
  • Different types of tables
  • Different types of columns in a table
  • Finding tables
  • Finding primary and foreign keys of a table

❯ Overview of multi-organization

  • Need of the organization
  • Parts of the organization
  • Technical impact of the organization

❯ Registration of custom objects

  • Form registration
  • Table registration
  • Report registration
  • Host script
  • PL/SQL program

❯ Registration of reports

  • Development of report
  • Registration of report
  • Parametric report registration
  • Reports with repeating frames

❯ Form registration

  • fmb
  • fmb
  • PII
  • Concept of form customization
  • Process of form registration
  • Using function Zoom_available( )
  • Using procedure Event( )

❯ Workflows

  • Introduction
  • Workflow builder
  • Creating processes
  • What are attributes
  • Sending notifications

❯ XML publisher

  • Overview
  • Template builder
  • Sub-template
  • Template features
  • Oracle reports: 6i/10g/11g
  • Difference between XML publisher and oracle reports
  • Conditional formatting
  • IF condition
  • IF THEN ELSE condition
  • Oracle discoverer 10g
  • Creating data definitions

❯ Generating XML file using reports

 



Oracle Apps Technical Online Training Placement in Various Cities: