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.
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'.
"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'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!