Last updated on OCTOBER 02, 2015
Applies to:Oracle Retail Store Inventory Management - Version 14.1.1 and later
Information in this document applies to any platform.
This article will be updated as official patch becomes available.
In the Store Inventory Management (SIM) application, we find that the PurgeItems.sh batch fails with "ORA-01722: invalid number" error.
Steps to Reproduce:
- Ensure that items exist in "Deleted" status in SIM database table STORE_ITEM.
- Run "PurgeItem.sh" batch.
- Note that the batch aborts with the following error:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms