Contact Premier Online Trainings Today
Premier Online Trainings

Oracle Apps Technical

  • Home
  • Oracle Apps Technical
Courses Overview
Premier Online Trainings Institute provides best Oracle Apps Technical training in Hyderabad, Banglore by our Highly Professional certified trainers.

Oracle Apps technical training module makes you understand the oracle architecture, workflow, xml publisher, flex-fields, designing reports and forms using Oracle Apps. It helps connect your business to cloud efficiently. We provide live oracle technical training classes all over India including Hyderabad, Bangalore and Chennai. Oracle Apps Technical is ERP package (Enterprise Resource Planning) designed on the basis of Generally Acceptable Accounting Principles [GAAP]. Oracle Applications comprise the application software or business software of the oracle corporation. Descriptive Flex Fields capture business information and add attribute columns. Qualifiers identify segments and in QA framework MDS defines the personalization reports. The key feature of oracle apps technical training is in-depth explanation in technical module of data integration.

* We also provide Online Training for Normal Track, Fast Track and Weekend Batches
Course Curriculum
  • Comparison of Oracle Apps with other ERP’S
  • Types of Roles
  • Types of Projects
  • AIM documentation standards
  • Oracle Application Architecture
  • Database structure of OA
  • Using TOAD
  • Creating Users
  • WHO columns
  • Creating Responsibilities
  • Menu construction
  • Request group construction
  • Table Registration
  • Table Registration using AD_DD package
  • View Registration
  • Sequence Registration
  • New Application/New Module Development
  • Form Registration
  • Form Functions
  • Non-Form Functions
  • Report Registration
  • Registration of SQL*Plus files
  • Registration of SQL*Loader files
  • Registration of PL/SQL procedure
  • Overview of profile options
  • Different levels in Setting profiles
  • Steps in setting a profile option
  • Some important profile options
  • Some important API’s of profiles
  • Defining concurrent program
  • Concurrent programs with parameters
  • Working with multiple concurrent programs
  • Scheduling the Concurrent Program
  • Concurrent Program incompatibilities
  • Creating Request Set
  • Procedure registration
  • Value sets
  • Report development
  • Report registration
  • Parametric report registration
  • Reports with repeating frames
  • Accounts Payable module flow with base tables
  • Accounts Receivable module flow with base tables
  • Order Management module flow with base tables
  • Purchase order Module flow with base tables
  • General Ledger Module flow with base tables
  • Outbound Interfaces
  • Using UTL_FILE package
  • Using SQL * Loader tool
  • SQL * Loader Concepts
  • Data File
  • Control File.
  • Bad File.
  • Discard File.
  • Log File.
  • Commands in Sql * Loader
  • Registration Of control File in Oracle Apps
  • Overview on conversions
  • Difference between Interfaces and conversions
  • Working with staging table script
  • Developing validations package
  • Standards to be followed in conversions
  • Form’s personalization: need and benefits
  • Use validate feature to confirm conditions and strings
  • Form Personalization v/s Form Customization
  • Types of Flex Fields
  • Descriptive Flex Fields
  • Key Flex Fields
  • Overview of value sets
  • Options in value sets
  • Types of value sets
  • Creation of value set
  • Overview of value set tables
  • Introduction to XML Publisher
  • Generatin XML file using reports
  • Creating Templates
  • Creating Data Definitions
  • Introduction to workflow
  • Workflow builder
  • Creating Processes
  • Introduction to Discoverer tool
  • Discoverer Administrator
  • Creating Business Areas
  • Discoverer Desktop
  • Creating work books