1. Human Capital Management Fundamentals Implementation Guide
  2. Understanding Record Reservation

Understanding Record Reservation

To prevent loss of data when two users simultaneously attempt to update the same record in the database, you can activate record reservation. When you activate record reservation for a particular program, only one user at a time can access a record in the table that the program uses for data storage. For example, assume that record reservation has been activated for the employee master group of programs (P0801). User 1 is updating salary information for an employee in the Employee Basic Compensation program (P0801CMP). At the same time, User 2 opens the Basic Compensation program and attempts to access the same employee record. User 2 receives an error message indicating that the employee record is reserved. The system prevents User 2 from gaining access to the record. The record remains reserved until User 1 saves any changes and closes the program.

Note: Two significant limitations to record reservation exist: you can activate record reservation only for those programs that are designed to use it and programs that do not use record reservation can update reserved records.

Only programs that are designed for record reservation can use this feature. In JD Edwards EnterpriseOne Human Capital Management software, these programs include:

  • Employee/Personal (P0801EMP)

  • Employee Organizational Assignments (P0801ORG)

  • Employee Basic Compensation (P0801CMP)

  • Employee Eligibility, NDT, and Participation (P0801ELI)

  • Employee Payroll (P0801PRL)

  • Employee National and Fiscal Data - Australia (P75A0801)

  • Employee National and Fiscal Data - Canada (P0801CA)

  • National/Fiscal Data - Regional Information (P76M0801)

  • Employee National and Fiscal Data - USA (P0801US)

If you activate record reservation for any of the programs in the employee master group, you activate it for all the programs.