F00095 Record/Object Reservation in EnterpriseOne Interactive Application

Purpose of Document

This document provides a list of interactive applications which use the record/object reservation routine to maintain higher integrity for certain transactions.

This document is intended for the EnterpriseOne Developer and system administrator who will be implementing and troubleshooting the F00095 Record/Object Reservation in EnterpriseOne Interactive Applications.

Overview

The purpose of Record Reservation is to maintain higher integrity by preventing other users/processes from accessing a certain table simultaneously by recording data into the F00095 (Business Object Reservation table). By implementing this constraint, two different processes do not compete to update/delete a certain table at the same time.

The Record Reservation functionality will typically be implemented for applications which have to update critical information or within an application which updates transactions created by another application. This functionality is implemented by using Business Functions that can be called to reserve a record.

Refer to <Document 1289755.1> - E1: BSFN: Record Reservations Related Business Functions in EnterpriseOne to understand how record reservation related business functions can be implemented.

List of Applications and Routines

• Column Explanation

• Application: Calling interactive application ID and it's description
• UDC 00/RR: Whether routine is calling the business function Validate Application Id
• F00022: Whether routine reads UDC 00/RR based on table name RRESERVE or a specific application ID
• Reserve by: Business Function which validates and reserves record
• Generic Key: Key to reserve based on Target Table
• Apps: Application which is calling Reserve by
• Name Object (Target): Target table which reserves record
• Detail Error: Whether a certain application shows a detailed error by calling the business function Set Object Reservation Text Substitution Error
• Remove by: Business function which deletes a record from F00095

• Object Reference

• F20111 - Expense Report Header
• F30006 - Work Center Master File
• F3002 - Bill of Material Master File
• F3003 - Routing Master File
• F31171 - Parts List - Extension
• F31172 - Routing Instruction - Extension
• F40500 - Commodity Structure Definitions
• F40540 - Item Commodity Structure Relationship
• F40G03 - Grower Harvest
• F40G032 - Harvest Estimate Freeze Detail
• F4101 - Item Master
• F4211 - Sales Order Detail File
• F4277720 - Fulfillment Rules Header
• F43092 - Purchase Order Receipt Routing File
• F4311 - Purchase Order Detail File
• F43E11 - Requisition Detail
• F43121 - Purchase Order Receiver File
• F44H201 - Lot Master
• F44H501 - Sales Master Table
• F49T211 - Sales Order Detail File - Secondary Tag Table
• F4801 - Work Order Master File

• Business Function Called Reference

• N0000604 - ValidateApplicationId (Validate Application Id)
• X00022 - GetNextUniqueKeyID (Get Next Unique Key ID)
• N0000602 - F00095ReserveObject (F00095 Reserve Object)
• B0000603 - SetReservationError (Set Object Reservation Text Substitution Error)
• N0000602 - F00095RemoveReservation (F00095 Remove Business Object Reservation)
• Others can be found through P98652 - [Business Function Search] by copying and pasting the description into the Description field as it appears in the above table.

Enhancement in EnterpriseOne application release 9.1: