Understanding Record Reservation (Release 9.2 Update)

If the business has many transactions every day and you work with various programs to efficiently manage the accounts, you can limit user access to the programs after the accounts receivables details have been entered in the system, to preserve data integrity. Having multiple users who update data at the same time can result in inaccuracies.

JD Edwards EnterpriseOne provides you with record reservation capability which, when activated, enables only one user at a time to update individual records. After one user finishes updating a detail line, another user can access the line to continue updating information. Record reservation helps ensure the integrity of data.

When a program that uses record reservation is interrupted, orphaned reservation records might remain in the Business Object Reservation table (F00095). This can occur, for example, when technicians are working with a server, or when a workstation shuts down without warning. If an interruption stops one of the programs before it releases the reservations that it creates, you cannot update the records until the orphaned reservations are removed.

You can use the Remove Business Object Reservation program (P00095) to release unwanted record reservations. This program stores reservation information in the Business Object Reservation table (F00095).

By accessing the user-defined code (UDC) table 00/RR for record reservations, you can activate record reservation for a particular program by entering 1 in the Special Handling field.You can activate record reservation for these JD Edwards EnterpriseOne Accounts Receivable programs:

  • Standard Invoice Entry (P03B11)

  • Speed Status Change (P03B114)

  • Standard Receipts Entry (P03B102)

  • Draft Entry (P03B602)

  • Create Automatic Debit Batch (R03B571)

  • Known Invoice Match With Amount (R03B50D)

  • Known Invoice Match Without Amount (R03B50E)

  • Balance Forward Match (R03B50B)

  • Invoice Selection Match (R03B50A)

  • Combination Invoice Match (R03B50F)

For example, by entering 1 in the Special Handling field in the 00/RR UDC table for F03B11, record reservation will be activated for invoices.