ItemCre Fails to Be Processed in SIM When the Unit_Cost Is Larger Than Numeric (12,4)
(Doc ID 2455623.1)
Last updated on MAY 27, 2020
Applies to:Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.
When a new item is created in the Oracle Retail Merchandising System (RMS) with the numeric value of ITEM_SUPP_COUNTRY.UNIT_COST larger than (12,4), the Oracle Store Inventory Management (SIM) will fail to process the ItemCre message sent from RMS.
Steps to Create:
1. From RMS, Create a new Item and make sure that the ITEM_SUPP_COUNTRY.UNIT_COST value is higher than NUMERIC (12,4)
For example: 1,234,567,890.0000 .
2. RMS will send the ItemCre message to SIM.
Notice that the SIM will fail to process the message with the following error;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!