DSD Receipt - SIOCS Publishes Store Country As ORIGIN COUNTRY (Doc ID 2979658.1)

Last updated on OCTOBER 12, 2023

Applies to:

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

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