Locking Issue When Updating the NF Status
(Doc ID 2449290.1)
Last updated on MARCH 04, 2019
Applies to:Oracle Retail Fiscal Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
Locking issue is noted when updating the NF status.
Steps To Reproduce:
- Create one ShipInfo for Transfer 1 for any item.
- Do not commit the session.
- Open another session and create a second ShipInfo for Transfer 2 for any other item.
- 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