Sales Order Locks Lines With Multi-Users and Gapless Numbering Until Record Saves (Doc ID 365756.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
OEXOEORD.fmb
OEXOETEL.fmb

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

Symptoms

On 11.5.10.2 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.

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

STEPS
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::

UPDATE FND_DOC_SEQUENCE_USERS SET NEXTVAL = NEXTVAL + 1
WHERE
USER_ID = :B2 AND DOC_SEQUENCE_ID = :B1

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
********************************************************************************

Changes

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

Cause

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