Oracle Apps Training Course

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.

Softcore is the Best Oracle Apps Training Institute in Hyderabad, Kukatpally delivers the best training in the Oracle Apps Technical field to showcase subject knowledge skill set in the real time to solve all the complex problems with ease.

We are one of the top most reputed Oracle Apps Technical Training Institute in Hyderabad, kukatpally where the course is provided in flexible timings only.

Oracle Apps Training Course Syllabus

  • Definition of ERP, Overview of popular ERP’S
  • 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

Application Object Library

  • Creating Users
  • WHO columns
  • Creating Responsibilities
  • Menu construction
  • Request group construction

Registration

  • 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

Profiles

  • 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

Application development

  • 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

Reports

  • Report development
  • Report registration
  • Parametric report registration
  • Reports with repeating frames

Module Overviews

  • 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

Interfaces

  • Introduction to Interfaces
  • Outbound Interfaces
    • – Using UTL_FILE package
  • Inbound Interfaces
    • – Using SQL * Loader tool

Conversions

Flex Fields

  • Overview on conversions
  • Difference between Interfaces and conversions
  • Working with staging table script
  • Developing validations package
  • Standards to be followed in conversions
  • Types of Flex Fields
    • – Descriptive Flex Fields
    • – Key Flex Fields

Value sets

  • Overview of value sets
  • Options in value sets
  • Types of value sets
  • Creation of value set
  • Overview of value set tables

XML Publisher

  • Introduction to XML Publisher
  • Generating XML file using reports
  • Creating Templates
  • Creating Data Definitions

Workflow

  • Introduction to workflow
    • Workflow builder
    • Creating Processes

Discoverer

  • Introduction to Discoverer tool
  • Discoverer Administrator
  • Creating Business Areas
  • Discoverer Desktop
  • Creating work books

P2P (procure To pay) Bussiness Flow(Tables Explaination)

O2C (Order To Cash) Bussiness Flow(Tables Explaination)

Oracle Apps Training Course in Hyderabad, Kukatpally