Course Content

• Considering Applications and HRMS Architecture

  • Identifying Oracle HRMS applications

  • Identifying HRMS naming conventions

  • Recognizing HRMS database objects

  • Identifying legislative components, tables, and views in HRMS

• Reviewing Applications security model and HRMS customer needs

  • Restricting what people see

  • Security capabilities

  • Using security tools

• Understanding Date Track and dated entities

  • Date Track terminology

  • Date Track modes

  • Controlling Date Track access

• Recognizing HRMSi and eBusiness Intelligence

  • Main HRMSi components

  • HRMS online transaction processing (OLTP)) and relational data

  • HRMS is Discoverer workbooks and End User Layer

  • Business Views

  • Core HRMS setup for HRMSi reports

  • Data Warehouse components of HRMS

• Identifying HRMS interfaces with Oracle Applications

  • Recognizing shared entities

  • Considering configuration options and HR development direction

• Tracking personal data

  • Following basic HRMS processes and data

  • Relating people, work structures, and compensation

• Examining structures for extending data: flex fields and other information types

  • Key flex fields in HRMS

  • Descriptive flex fields

  • Other flex fields: protected, soft-coded legislative, developer

  • SIT and EIT: where available and how to configure

• Understanding HRMS globalization features

  • Multiple language support

  • Profiles in a global implementation

  • Currency, including the Euro as a functional currency

  • Language, localizations, applications, and character sets

  • Business groups and data partitions

• Identifying the HRMS Business process approach

  • Understanding API parameters

  • Processing with APIs

• Running Data Pump and APIs

  • Setting up Data Pump

  • Examining Data Pump processes

• Considering Mass Information exchange (MIX) interface utilities

  • Batch element entry (BEE)

  • System data extract

• Recognizing Application Technology group (ATG) data loading tools

• Discussing Payroll interfaces and the generic Payroll Interface Kit

• Understanding and using Application Data Exchange (ADE)

  • Installing and configuring ADE

  • Using ADE options and styles

  • Running and troubleshooting ADE

  • System data extract

• Understanding extension restrictions

• Using Custom library with Oracle applications: Common and HRMS-specific event points

• Extending validation with API User Hooks: hook conventions and restrictions

  • Implementing hooked code

  • Registering user hooked code with the preprocessor

• Extending HRMS with FastFormula Defining FastFormula functions

• Examining database item components

  • Considerations for creating database items

  • Examining the FastFormula Application Dictionary

• Calling FastFormula from PL/SQL

  • Setup

  • Understanding formula requirements, framework, and engine calls and processes

  • Designing formula calls

• Using Forms Configurator and People Management templates & Extending HRMS security with the custom WHERE clause in security profiles