Sales Order Locks Lines With Multi-Users and Gapless Numbering Until Record Saves

(Doc ID 365756.1)

Last updated on JANUARY 25, 2018

Applies to:

Oracle Order Management - Version to [Release 11.5.10]
Information in this document applies to any platform.

***Checked for relevance on 09-June-2015***


On in Production:
When attempting to have multiple users access the Sales Order forms and enter orders concurrently,
the first user is able to access the order lines, but the other users get locked out of lines until the first
user saves and exits.

Locking occurs in sales order lines with multiple instances, (users), not allowing concurrent access to the lines forms.

The issue can be reproduced at will with the following steps:
1. User A logs in as Order Management Super User and opens Sales Order Forms
2. User B logs in as Order Management Super User and opens Sales Order Forms
3. User A fills out order header, and enters the Lines Form
4. User B fills out order header, and tries to enter the lines forms. User B cannot enter the
lines zone until User A saves the record and exits.

See the following problem in the trace file taken::


On this update, there is a very long wait for a user seen in the elapsed time:

call count cpu elapsed disk query current rows
------------ -------- --------- ------------- ----------- ----------- ------------ -----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.17 192.48 2 3 2 1
Fetch 0 0.00 0.00 0 0 0 0
------------ -------- --------- ------------- ----------- ----------- ------------ -----------
total 2 0.17 192.48 2 3 2 1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 175 (recursive depth: 1)

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited --------------- ------------------
db file sequential read 2 0.00 0.00
enqueue 66 4.18 192.36


Instance is using Gapless Numbering system setup in Sales Order Document Sequences.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms