record-reservation-in-purchase-date-revisions-program

The JD Edwards EnterpriseOne software provides the record reservation capability within the Purchase Date Revisions program (P43100). Record reservation ensures data integrity and prevents data loss. To avoid simultaneous processing of the same records, the system reserves (locks) records for processing by any other program. Thus, the system does not allow you to edit a record that has been locked by a different user or application.

When a program that uses record reservation is interrupted, orphaned reservation records might remain in the Business Object Reservation table (F00095). An interruption can occur, for example, when technicians are working with a server, or when a workstation shuts down without warning. If an interruption stops Purchase Date Revisions program 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).

When performing a requested or promised date revision for a purchase order from the Purchasing Date Revisions (P43100), purchase order is reserved based on order number, order type, and order company. When another user attempts to update the same order that was reserved, then system generates an error.

To activate this additional record reservation feature, you must define a UDC code P43100 in UDC (00/RR), with the Special Handling Code field set to 1.

Note: If two or more users attempt to perform date revision using Purchase Date Revisions program (P43100) or order revision using Purchase Order program (P4310), PO Receipts program (P4312), Purchase Order Approvals program (P43081) for an order with the same item and branch/plant combination at the same time, one or more of the users may get a transaction error.