Shelf Replenishment Report Fails with the Error ORA-01722: INVALID NUMBER and User Cannot See Details

(Doc ID 2091104.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.2 and later
Information in this document applies to any platform.


The Shelf Replenishment Report fails with the error ORA-01722: INVALID NUMBER.

Steps to Recreate:

  1. Create a shelf replenishment product group.
  2. Create sequencing for the same set of items.
  3. Create an end of day shelf replenishment.
  4. Complete the activity.
  5. Log in to PC and print the completed replenishment.
  6. Observe that the Shelf Replenishment Report fails with the error: ORA-01722: invalid number


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