Warehouse To Store Transfer (WMS) Integration Creating Duplicate Seq_nbr In WMS
(Doc ID 2906386.1)
Last updated on NOVEMBER 02, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.
On : 19.1 version, Merch - RMS Interfaces
Warehouse to Store Transfer (WMS) integration creating duplicate seq_nbr in WMS
1. Customer creates order with two lines.
2. Order is sent to WMS but immediately errors with ORA-00001: unique constraint (ADMIN.ORDER_DTL_UKEY) violated
3. Issue is tracked down to order details are sent with duplicate seq_nbr for each lines in WMS.
Customer facing an issue in UAT (Test) testing wherein WMS is not accepting 1 item being sent on 2 lines from RMS. The order gets created but does not get populated with any items. Error seen is:
Exception in process_stgdtl: Exception creating dtls for order: ORA-00001: unique constraint (ADMIN.ORDER_DTL_UKEY) violated,12346688-T
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