Oracle Human Resources Implementation Guide

1 Oracle HRMS ImplementationGuideRelease No. A58331 01 Enabling the Information Age Oracle HRMS Implementation Guide , Release No. A58331 01 Copyright E Oracle Corporation 1997 All rights reserved. Printed in the Contributors: Louise Raffo and Robert RoseContributors: Peter Attwood, John Cafolla, Juliette Fleming, Michael O Shea and JohnThuringerThis software was not developed for any use in nuclear, aviation, mass transit, medical,or other inherently dangerous applications. It is the customer s responsibility to takeall appropriate measures to insure the safe use of such applications if the programs areused for such software/documentation contains proprietary information of Oracle Corporation; itis provided under a license agreement containing restrictions on use and disclosure and isalso protected by copyright law.

2 Reverse engineering of the software is this software/documentation is delivered to a Government Agency of theDepartment of Defense, then it is delivered with Restricted Rights and the followinglegend is applicable:Restricted Rights LegendUse, duplication, or disclosure by the Government is subject to restrictionsas set forth in subparagraph (c)(1)(ii) of DFARS 7013, Rights inTechnical Data and Computer Software (October 1988). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA this software/documentation is delivered to a Government Agency not within theDepartment of Defense, then it is delivered with Restricted Rights, as defined in 14, Rights in Data General, including Alternate III (June 1987).

3 The information in this document is subject to change without notice. If you find anyproblems in the documentation, please report them to us in writing. Oracle Corporationdoes not warrant that this document is error part of this document may be reproduced or transmitted in any form or by any means,electronic or mechanical, for any purpose, without the express written permission ofOracle , Oracle Alert, Oracle Financials, SQL*Forms, SQL*Plus, SQL*QMX, SQL*Re-port, and SQL*ReportWriter are registered trademarks of Oracle CorporationOracle Application Object Library, Oracle Applications, Oracle Applications WindowManager, Oracle Assets.

4 Oracle Bills of Material, Oracle Business Manager, OracleEngineering, Oracle General Ledger, Oracle Government Financials, Oracle HumanResources, Oracle Inventory, Oracle *Mail, Oracle Manufacturing, Oracle MasterScheduling/MRP, Oracle Order Entry, Oracle Payroll, Oracle Payables, Oracle Personnel, Oracle Project Accounting, Oracle Purchasing, Oracle Receivables, Oracle TrainingAdministration and Oracle Work in Process are trademarks of Oracle Corporation. iContentsContentsPrefacePreface i.. About This User s Guide ii.

5 Finding the Latest Information ii.. Assumptions iii.. Do Not Use Database Tools to Modify Oracle Applications Data iii.. Finding Your Way Around the System iv.. Other Information Sources iv.. About Oracle viii.. Thank You ix.. Chapter 1 Planning Your Implementation1 1.. Implementing Oracle HRMS1 2.. Implementation Flowcharts1 4.. Implementation Checklists1 13.. Basic Administration Checklist1 13.. Work Structures Checklist1 14.. Compensation and Benefits Checklist1 15.. People and Assignments Checklist1 16.

6 Career Management Checklist1 17.. Specific Business Functions Checklist1 18.. Control Checklist1 19.. ii Oracle HRMS Implementation GuideChapter 2 Implementation Steps2 1.. Implementation Steps: Basic Administration2 2.. Implementation Steps: Administration2 17.. Implementation Steps: Application Data Export (ADE) and Hierarchy Diagrammers2 19.. Implementation Steps: Work Structures2 20.. Implementation Steps: Compensation and Benefits2 29.. Implementation Steps: People and Assignments2 37.

7 Implementation Steps: Recruitment2 42.. Implementation Steps: Career Management2 43.. Implementation Steps: Specific Business Functions2 48.. Implementation Steps: Control2 56.. Appendix ATechnical EssaysA 1.. How DateTrack WorksA 2.. Behavior of DateTracked FormsA 2.. Table Structure for DateTracked TablesA 4.. Creating a DateTracked Table and ViewA 6.. How to Create and Modify DateTrack History ViewsA 8.. What Happens When You Request DateTrack HistoryA 8.. DateTrack History in Forms 2A 9.

8 DateTrack History in Forms 4A 9.. Rules for Creating or Modifying DateTrack History ViewsA 10. List of DateTrack History ViewsA 12.. The FastFormula Application DictionaryA 13.. Entities in the DictionaryA 13.. Defining New Database ItemsA 16.. Extending Security in Oracle Human ResourcesA 25.. Security ProfilesA 25.. Security ProcessesA 30.. Securing Custom TablesA 33.. Creating Control Totals for the Batch Element Entry ProcessA 35.. IntroductionA 35.. APIs in Oracle HRMSA 39.. API OverviewA 39.

9 Understanding the Object Version Number (OVN)A 42.. API ParametersA 44.. API ParametersA 54.. API FeaturesA 69.. Flexfields with APIsA 70.. Alternative APIsA 74.. iiiContentsAPI Errors and WarningsA 75.. Example PL/SQL Batch ProgramA 77.. WHO Columns and Oracle AlertA 80.. API User HooksA 81.. Using APIs as Building BlocksA 103.. Handling Object Version Numbers in Oracle Forms 104.. HRMS Table Locking LadderA 110.. Balances in Oracle PayrollA 115.. Overview of BalancesA 115.. Latest BalancesA 116.

10 Balance DimensionsA 118.. Initial Balance Loading for Oracle PayrollA 122.. IntroductionA 122.. Differences from Release 9A 122.. StepsA 123.. OverviewA 123.. Latest BalancesA 125.. Setup an Element to Feed Initial BalancesA 126.. Setup the Initial Balance ValuesA 127.. Running the Initial Balance Upload ProcessA 130.. Balance Initialization StepsA 135.. Including Balance Values in ReportsA 138.. The Balance FunctionA 138.. Including Balance Values in Reports ( Only)A 141.. AdvantagesA 141.