PurgeItem.sh Batch Fails with "ORA-01722: Invalid Number" Error (Doc ID 2062157.1)

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.


The issue described in this document is known to Oracle, and a fix is already scheduled for future release.
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:

  1. Ensure that items exist in "Deleted" status in SIM database table STORE_ITEM.
  2. Run "PurgeItem.sh" batch.
  3. 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms