Oracle Apps Technical | Introduction to ERP

By Jag - April 05, 2014
Oracle Apps Technical | Introduction to ERP

Introduction to ERP



  • 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 and SQL Developer

  • Module Overviews



  • Inventory Module flow with base tables
  • Accounts Payable module flow with base tables
  • Accounts Receivable module flow with base tables
  • Order Management module flow with base tables
  • Hire to Retire

  • 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
  • User Management
  • Responsibilities
  • Menus
  • Request Groups
  • WHO Columns

  • Reports



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

  • Forms



  • Template.fmb
  • Appstand.fmb
  • Form development using templates
  • Form customization concepts
  • Form Registration Process
  • Custom.Pll
  • Using function Zoom_available( )
  • Using procedure Event( )

  • Interfaces



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

  • Conversions



  • Overview on conversions
  • Difference between Interfaces and conversions
  • Working with staging table script
  • Developing validations package
  • Standards to be followed in conversions

  • Flex Fields



  • Types of Flex Fields
  • Descriptive Flex Fields
  • Key Flex Fields


  • PLSQL Reports and More PLSQL in Apps



  • How To Develop a PL/SQL report
  • Advantages of Developing the PL/SQL report
  • Coding standards to follow while developing the PL/SQL report
  • Usage of ERRBUF and RETCODE parameters
  • Usage of FND_FILE.PUT_LINE in PL/SQL
  • How to call a concurrent program from Backend

  • Workflows



  • Introduction to workflow
  • Workflow builder
  • Attributes
  • Creating Processes
  • Sending notifications using workflows
  • Workflow Administrator

  • XML Publisher



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

  • Discoverer



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

    You Might Also Like

    0 comments