OTB Locking Occurs When Multiple PO’s Uploaded At The Same Time With Same Dept/Class/Subclass
(Doc ID 1903905.1)
Last updated on MARCH 15, 2019
Applies to:Oracle Retail Merchandising System - Version 13.2.6 and later
Information in this document applies to any platform.
OTB (Order To Buy) table locking occurs when multiple PO’s uploaded at the same time with same Dept/Class/Subclass, even though SYSTEM_OPTIONS.OTB_SYSTEM_IND = ‘N’, the below error occurs:
Steps To Reproduce:
1. Set SYSTEM_OPTIONS.OTB_SYSTEM_IND = ‘N'.
2. Call RMSSUB_XORDER.CONSUME to create orders at the same time with same Dept/Class/Subclass using multi threading.
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