My Oracle Support Banner

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.

Symptoms

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

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.