I have two users attempting to use an Oracle Forms application at the same time. They are in two different forms, but both forms refer to the same data blocks and tables on the database (Payee, Recipient, Voucher, Accounting, etc.) Both users have the appropriate privileges on the tables, and which ever user saves first is able to commit their changes, but the second user receives the FRM-01031 when attempting to save.
My initial assumptions are 1.) that the first user's commit is locking the tables and 2.) it should be entirely possible for more than one user to use this application at a time. But I don't know what setting to change to fix this, or the potential problems resulting from such a change and how to account for them. The form's Isolation mode is Read Committed and only one data block has Immediate locking mode, the rest are automatic.
I've inherited this application and the original developer is long gone. I'm primarily a Java developer by trade, and have had no formal training in Oracle Forms, just an intermediate knowledge level of PL/SQL, a copy of Oracle Developer Advanced Forms & Reports: Development Standards and Techniques, a good amount of curiosity, and a general lack of fear when working in my local environment.
If anyone can point me to some good references or even in the general direction of where I should be looking to resolve this issue, the help would be greatly appreciated.
Thanks!