My Oracle Support Banner

Locking Issue When Updating the NF Status (Doc ID 2449290.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3.2 and later
Information in this document applies to any platform.

Symptoms

 Locking issue is noted when updating the NF status.


Steps To Reproduce:

  1. Create one ShipInfo for Transfer 1 for any item.
  2.  Do not commit the session.
  3.  Open another session and create a second ShipInfo for Transfer 2 for any other item.
  4. Observe the error in second ShipInfo message: Table FM_FISCAL_DOC_HEADER with key values of FM_FISCAL_DOC_HEADER_SQL.UPDATE_STATUS, -54 is locked by another user.

Same issue is seen when receiving the receive count.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.