My Oracle Support Banner

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!

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