My Oracle Support Banner

DSD Message Fails in Error Hospital During Subscription at RMS Side (Doc ID 2215454.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to send Direct Store Delivery (DSD) on the fly receipt messages from Retail Store Inventory Management (RSIM) to Retail Merchandising System (RMS) the following error occurs:

javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_DSD.CONSUME(?,?,?,?,?)}: [E] The following item-supplier-country of sourcing relationship does not exist: xxxxxx-zzzz-CC.

Steps To Reproduce:

 
Pre-Req:


1. Log in to Store Inventory Management (SIM) and create an on the fly Direct Store Delivery (DSD) (Main Menu > Shipping/Receiving > DSD Receiving > Create Receipt).
2. Choose the supplier from the select supplier dialog.
3. Add the required items with appropriate quantities and click on confirm.
4. The DSD receipt message gets generated in MPS_STAGED_MESSAGE table.

 

 <Internal Only>

     Note: For 14.1.x, issue will be recreated only when <Patch 24599066> is applied in environment otherwise item will not be added as it shows error: Vendor does not source this item in SIM application.

 <Internal Only>

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.