My Oracle Support Banner

RMSSUB_FULFILORD Throws "Duplicate Transaction Level Items Exist For Customer Order" Error (Doc ID 2775130.1)

Last updated on MAY 12, 2021

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 to 14.1.3 [Release 14.1]
Information in this document applies to any platform.

Symptoms


Customer orders do not accept a payload with the same items appearing two times with distinct unit retail. RMS throws UNIQUE_ITEM_PER_CO error.

Error
-----------------------
UNIQUE_ITEM_PER_CO - Duplicate transaction level items exist for Customer order no %s1, Fulfill order no %s2.

What is Working
-----------------------

Store Inventory Management (SIM) integrates the payload with no error.

Steps to Recreate
-----------------------
Consider a promotion BOGO-half-off where the client buys one gets the second item 50% off.

For example, item A with unit retail of 89.99, the second piece costs 49.99.

Order Management System (OMS) deals with this scenario by generating the payload to be consumed by Fuilfill WebService:
 ...



But the Fulfillment WebService does not accept this payload and fails with the following error message: UNIQUE_ITEM_PER_CO.




Changes

 

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
Changes
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.