Sales Order File Locking

[t_a_pierce]

Hi List,

Does anyone know of any way of 'locking' Sales Order (Header & Detail)
records if a user is adding or amending that particular record using the
P4210?

The problem is that there is the potential for corrupt data if a user leaves
a Sales Order open while another user runs a UBE/App which updates the
record on which they are positioned.

Some JDE Apps cater for this, but some don't and we have also written some
custom Apps for which this is a problem.

The 2 avenues I seem to have open are:

1. Lock Manager (settings in the JDE.INI).
2. Checking the Business Object Reservations (P00095) which should indicate
a record in use.

Any ideas?

Tim.

 

[Larry_Jones]

Tim,

Lock Manager won't do what you want.

it appears your best choice would be to modify the offending apps/UBEs to honor Business Object Reservations.

Regards,

Larry Jones
[email protected]
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials

 

[peter_hamilton]

You just need to remember to have Object Reservations switched on (UDC 00/RR).

Note: JDE has this wonderful feature of Removing the Reservation, even if you did not, make the reservation. So, Don't remove the Reservation unless you actually made it.

Peter Hamilton
B7332 SP14, Windows NT, Unix

 

[JRev]

Larry's right on that. Applications will only get locked. UBE's do not lock applications and will not bypass locked records.

This was a big problem for us with pickslips. I explained in detail how we resolved this in the past. You could probably search the archives for locks, or UBE record-locking, or something like that, if you wanted more details. It wasn't the perfect solution, but it helps.

Ultimately, JDE needs to recognize that this can be a big problem for many UBE's that update records. From what I hear, this wasn't a problem in World because of the inherent locking on an AS/400 (or something like that).



Justin Revoredo
Amersham Biosciences
Piscataway, NJ
OW B7332 Coexistence SP11.1
AS/400 Oracle
Citrix/Fat