The Best College Academy of Our Small City

Latest News - QUIS NOSTRUM - Exercitationem ullam corporis suscipit laboriosam

google-site-verification: googlecef74b51d74c11f3.html

google-site-verification: googlecef74b51d74c11f3.html

Oracle Apps Technical

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
    • Labels: ,

    Oracle Apps HRMS Functional

    Course objective:

    This is course Oracle Apps HRMS Functional is targeted for ERP entust. Which is heavyly used in the current job market.

    What is ERP?

    • Understanding Multi-Org Concept in Oracle Application
    • Oracle Application Object Library (AOL)
    • Creating Application Users
    • Functional Security and Application Security
    • Creating role based Responsibilities
    • Creating Custom Menus, Request Groups, Data Groups
    • Creating and managing Concurrent Programs and Reports
    • Standard request submission (SRS)
    • Profile Options in Oracle Applications
    • Value Sets and Flex fields in Oracle Applications
    • KFF and DFF
    • Overview of Alerts and Workflow

    Introduction to Oracle HRMS

    • KFFs and DFFs in HRMS
    • SITs and EITs in Oracle HRMS
    • HR Lookups
    • Work Structures
    • Business Group, Organization and Locations
    • Representing Financial Reporting Structure
    • Representing Legal and Government Reporting Structures
    • Defining Organization Information for Government Mandated Reporting
    • Representing Grades and Their Relationship to Pay
    • Representing Jobs and Positions
    • Position Hierarchies
    • Peope Form, Assignment Form, Address, Contact, Termination Form etc..

    Introduction to Payroll Processing

    • Defining Payment Methods
    • Defining Payroll, Attach Payment Methods, Time Periods
    • Elements, Element Links and Entries
    • Deductions and Earnings Templates
    • Making Batch Element Entry (BEE)
    • Assignment Sets, Element Sets
    • Payroll Process (Payroll Process, PrePayments, Costing, Transfrer to GL, NACHA, Direct Depost etc..)
    • Difference Between Rollback, Retries, and Reversals
    • Balances
    • Reasons for Adjusting Balances

    How to create Data Loader Sheets

    • Recording Exchange Rates
    • Quick Pay
    • Fast Formulas
    • Important Payroll Tables

    Absence Management

    • Introduction
    • Setting Up Absence Management
    • Managing Absences
    • Understanding the Accrual Plan Structure
    • Setting UP PTO Accrual Plans
    • Administering Accrual Plans
    • Adapting the Predefined Accrual Formulas
    • Changing the Net Calculation Rules

    Self Service HR

    • Introduction to SSHR
    • Functions and Features of SSHR
    • Fundamentals of SSHR
    • Self-Service Basics
    • User Access and Security
    • User Access to People

    Configuring SSHR

    • Functions, Menus, and Responsibilities
    • Configuring Functions
    • Configuring Web Page Layouts

    Approvals

    • Using SSHR
    • Common SSHR Functions
    • Employee Directory

    Self Service Personalization

    • Documentation
    • Introduction to AIM Methodology
    • MD 50
    • MD 70
    • BR 100
    • BP 80 - Future Process Model
    • RD 50 - Requirements Definition
    • MD 120
    Labels: , , ,
    Subscribe to: Posts (Atom)