My Oracle Support Banner

PRIMARY_MANU_CTRY_IND Is Not Getting Updated to Y in RMS Base Tables when Uploaded to RMS (Doc ID 2431606.1)

Last updated on AUGUST 08, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

PRIMARY_MANU_CTRY_IND is not getting updated to Y in RMS Base Tables when Uploaded to RMS.
The PRIMARY_MANU_CTRY_IND in SVC_ITEM_SUPP_MANU_COUNTRY is 'Y', but on uploading to RMS, the ITEM_SUPP_MANU_COUNTRY table has PRIMARY_MANU_CTRY_IND as 'N'.

Errors:
"This item was not submitted successfully"
"Country Of Manufacture is required for this item."

Steps to Reproduce:
1. Upload the provided data into staging table for item creation using item induction.
2. Upload item into RMS.
3. Verify the process status in SVC_ITEM_MASTER, some items have failed to approve in RMS.
4. Note the above error and observe one Supplier has PRIMARY_MANU_CTRY_IND = N. Four other suppliers are set to 'Y'.

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!


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