DSD Receipt - SIOCS Publishes Store Country As ORIGIN COUNTRY
(Doc ID 2979658.1)
Last updated on OCTOBER 12, 2023
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 23.2 and laterInformation in this document applies to any platform.
Symptoms
On : 23.2 version, Shipping and Receiving
DSD Receipt - SIOCS publishes Store Country as ORIGIN COUNTRY
At SIOCS, once doing a DSD Receipt where the PO is created and received on the fly, SIOCS is creating a message under MPS_STAGED_MESSAGE which contains the Store country code in the field originatingCountryID instead of the Supplier Item Country code.
It's causing failures when integrating into MFCS since MFCS is looking at Item/Supp/Country and checking for a Country that is not existing - so fails the processing.
ERROR
-----------------------
Which after integrated to MFCS it fails with: "La relation article/fournisseur/pays d'approvisionnement n'existe pas : 100050005-2010-FR"
Basically stating the relationship does not exist at MFCS since what is there is the 100050005/1010/CN
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use a Store setup with FR as the country.
2. Do a DSD receipt for an item/Supplier having at Item/Supp/Country only one country which is "CN".
3. SIOCS in this case is generating the below message:
<?xml version="1.0" encoding="UTF-8"?> <DsdReceiptDeo> <fromLocationId>2010</fromLocationId> <toLocationId>181</toLocationId> <receiptNumber>3</receiptNumber> <invoiceNumber>1212</invoiceNumber> <originatingCountryId>FR</originatingCountryId> <currencyCode>EUR</currencyCode> <deptId>100</deptId> <receiptDate>2023-09-05T08:17:06Z</receiptDate> <lineItems> <itemId>100050005</itemId> <unitQty>36.0000</unitQty> <useUnavailable>false</useUnavailable> </lineItems> </DsdReceiptDeo>
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, its causing failures when integrating into MFCS.
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 |