Is this just on the one form, or on any form? Is one user able to access one form and another user access a different form?
This is happening when users try to access the same form. For example if user A and user B want to access 'transactions' in the receivables responsibility at the same time, only one of them is able to access transactions, and the other user is not able to open the forms.
But when one user acceses 'transactions' and the other one accesses let's say 'receipts' the problem does not occurr.
Sounds like it might be due to locking. Have you any customisations or personalizations, or anything in custom.pll?
Have two users do this, and then run the following query on the database:
2, 'Row Sh', -- Row Share
3, 'Row Ex', -- Row Exclusive
4, 'Sh', -- Share
5, 'Sh Row Ex', -- Share Row Exclusive
6, 'Ex', -- Exclusive
FROM v$locked_object vlo,
WHERE vs.sid = vlo.session_id
AND vs1.sid(+) = vs.blocking_session
AND dbo.object_id = vlo.object_id
AND vs.status = 'ACTIVE'
AND vs1.sid IS NOT NULL
ORDER BY vs.status,
Similar issue faced yesterday for a client, what we done is checked the table in form level and used below query and killed the session.
Issue resolved for us.
from dba_locks dl
--where do.object_name ='WF_NOTIFICATIONS'
and dl.lock_id1 = do.object_id
and v.sid = dl.session_id;
There are no customisations in the Custom.pll file
And the query is not returning any rows.
The query is not returning any rows.
That's interesting then; the problem points towards database lock waits, however no locks are found. I presume you ran the query at the time when a user was experiencing the "lock out" and not just randomly? The reason for asking about custom.pll is you may have had some kind of custom auditing functionality enabled.