DSD Receipt Message Fails In Error Hospital During Subscription At MFCS Side (Doc ID 3015885.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

When attempting to create Direct Store Delivery (DSD) on the fly receipt messages from SOCS,the following error occurs on RIB-RMS.
javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_DSD.CONSUME(?,?,?,?)}: [E]The following item-supplier-country of supply relationship does not exist: 101000229-5-MX.

Steps To Recreate:
1. Go to 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.Make sure store.locale_country ='MX' is different than the Supplier_item_country.country_id='US'.
4. The DSDReceiptDesc message gets generated in MPS_STAGED_MESSAGE table and fails in RIB-RMS with the above error message.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.