Oracle HRMS/Payroll Techno Functional Training

Prerequisites

• Basics in Computer Science
• Good Business Process Understanding
• Basic SQL, PL/SQL
• Fundamentals of ERP.

Target Job Roles

• Oracle Application Techno Functional Consultant.
• Oracle Application Programmer Analyst.

• Oracle Certified Professional – Oracle Applications.

Offerings

• Independent Consultants
• IT Consulting Companies.

Format

• Online (Web & Audio Conference)
• On – Site at your facility.

Overview.

Duration

Contents

• Logon and off of Oracle Applications
• Using forms menus
• Entering data using forms
• Searching forms
• Accessing Online Help

Introduction to R12 Oracle Applications

• R-12 E-Business Suite Overview
• Understanding the R-12 Architecture
• Understanding Oracle Application File System
• Understanding Rapid Install

Fundamentals of System Administration

• Application Security Overview
• Function Security
• Data Security
• Profile Options
• Standard request submission (SRS)

Fundamentals of Flexfields

• Basics of Flexfields
• Define Value sets
• Define Key Flexfields
• Define Descriptive Flexfields
• Flex field enhancements in R12
• Creating EIT and SIT (Difference Between EIT and SIT)

Overview.

Duration

Contents

• Identifying the different workers in your enterprise
• Defining people
• Describing person types
• Describing the key workforce concepts in Oracle HRMS
• Identifying components of the assignment
• Using assignments

Introduction to Recording People Information

• Understanding how to represent your workforce using Oracle HRMS
• Recording people information
• Using Windows and Templates

Set Up People Information

• Defining person types
• Understanding system and user person types
• Identifying assignment statuses
• Defining contract information
• Defining user assignment statuses
• Identifying contracts
• Creating contracts
• Defining additional information

Collective Agreements

• Identifying collective agreements
• Defining collective agreements
• Defining entitlement items
• Defining derived factors
• Defining eligibility profiles
• Using collective agreements
• Processing collective agreements

Entering People Information

• Understanding the hiring process
• Hiring a new person
• Placing a contingent worker
• Entering personal information
• Entering statutory information
• Entering additional personal information

Entering Assignment Information

• Entering assignment information
• Entering supervisor Information
• Entering payroll information
• Entering information for statutory reports
• Maintaining multiple assignment
• Entering contract information
• Entering contingent worker assignment information

Managing Schedules and Availability

• HRMS and CAC Integrated Availability Features
• Managing availability
• Recording schedule information
• Defining schedules
• Defining calendar events

Reporting and Analyzing Workforce Information

• Using Standard Reports
• Using Statutory Reports
• Using Discoverer Reports
• Using HRMS Reports
• Using HRMS Reports for Daily Business Intelligence

Terminating

• Ending assignments
• Ending secondary assignments
• Terminating assignments
• Terminating employment
• Ending contingent worker placements

Reinstating or Rehiring

• Canceling terminations
• Rehiring
• Understanding Back-to-Back Employment

Overview.

Duration

Contents

• Support in R12 Installation and Media Pack delivery except shipment and HD Expenses.
• Introduction to Rice Components.
• Introduction to  SQL – PLSQL
• Introduction to Inbound and Outbound Interfaces.
• Working with Open Interfaces, Conversions.
• Designing Pre-Interfaces or Staging Tables.
• Loading Data from different flat files into Pre-Interface Tables.
• Standards to follow while writing an interface program
• Explanation of Seeded interfaces.
• Introduction of Reports and Reports Builder.
• Definition of Report Triggers.
• Working with Bind and Lexical parameters.
• Reports with multiple queries (Groups in Reports).
• Customizing Report Triggers.
• Working with Summary Columns, formula Columns, Format triggers etc.
• Registering Reports.
• Introduction to XML.
• Oracle BI Publisher.
• Introduction XML Publisher Administrator.
• Registering XML and Rtf Templates.
• Introduction to Appstand and Template.fmb
• Creating new Forms using Template.fmb
• Working with different Types of canvases.
• Creating LOV’s and attaching to form fields.
• Generating .fmx and form Registration.
• Introduction to SQL Loader.
• Different Formats of Control files.
• Different Formats of Data files.
• Using Direct load and indirect Load.
• Registering SQL Loader Scripts.
• Introduction to Oracle Alerts.
• Introduction to Oracle Forms Personalization.
• Introduction to  Oracle Application Framework (OAF) Personalization.