Oracle Forms

Hi All,

I'm facing a problem in my ERP with stock updation.

Suppose there are 2 users connected to my ERP. Everybody entered Material Requisition for some items. There is an item with code (10001) having quantity available 100.

User 1 wants 100 quantity of this item
User 2 also wants 100 quantity of this item.

As there is only 100 available quantity for this item. so only one user should be able to save his MR and another user should receive a message like "Requested Quantity not available.......!!"

Everyone can file Requisition for many items in a single MRN. But the problem is

untill user 1 doesn't COMMIT his changes user 2 cannot see stock updation changes. So MR may be saved for both of these user which must not happen.

This is the only case if both users attempting for requisition of same item at same time.

Please suggest what should I do in this scenario.............!!

For ur reference I'm working on following versions

Forms [32 Bit] Version 6.0.8.8.0 (Production)
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Oracle Toolkit Version 6.0.5.34.1 (Production)
PL/SQL Version 8.0.6.0.0 (Production)
Oracle Procedure Builder V6.0.7.2.1 Build #228 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 6.0.7.0.0 - Production
Oracle Virtual Graphics System Version 6.0.5.34.0 (Production)
Oracle Tools GUI Utilities Version 6.0.5.32.0 (Production)
Oracle Multimedia Version 6.0.5.34.0 (Production)
Oracle Tools Integration Version 6.0.5.32.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.1
Oracle CORE Version 4.0.6.0.0 - Production

Thanks & Regards
Manoj