Eric Lehti
VIP Member
I invite some crowdsourcing support from you to encourage Oracle to fix this P4210 issue. not high enough priority yet for them to agree to fix it.
At A92 cume 1, in P4210 Sales Order Entry, when you press F17 function key to display the 40ADDR video (Order Address Information), shipping to Texas, and press Enter key here, you are locking the F0075 state record with HELD UPDATE.
And that F0075 record remains locked until you either end your sales order entry session or until you lock another F0075 state record by shipping to a different state (with the F17 key in P4210) That is due to design in P4210 in that XF0075 is called with the @@LOCK field set to Y.
Any other sales order entry people attempting to ship to that same state by pressing F17 inside P4210 will have to wait until the first user releases that state record.
You can confirm this with DSPRCDLCK F0075 and also reviewing sales order entry job logs.
Solution: put 'N' in @@LOCK just prior to calling XF0075.
Simple fix.
Oracle recommended talking to:
Open World and Collaborate make sure to speak to our Product Strategy people Kevin Klimek and Sue Brown as they help drive the direction of the product.
At A92 cume 1, in P4210 Sales Order Entry, when you press F17 function key to display the 40ADDR video (Order Address Information), shipping to Texas, and press Enter key here, you are locking the F0075 state record with HELD UPDATE.
And that F0075 record remains locked until you either end your sales order entry session or until you lock another F0075 state record by shipping to a different state (with the F17 key in P4210) That is due to design in P4210 in that XF0075 is called with the @@LOCK field set to Y.
Any other sales order entry people attempting to ship to that same state by pressing F17 inside P4210 will have to wait until the first user releases that state record.
You can confirm this with DSPRCDLCK F0075 and also reviewing sales order entry job logs.
Solution: put 'N' in @@LOCK just prior to calling XF0075.
Simple fix.
Oracle recommended talking to:
Open World and Collaborate make sure to speak to our Product Strategy people Kevin Klimek and Sue Brown as they help drive the direction of the product.
