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 and later
Information in this document applies to any platform.


 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.


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

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