"ORA-01722: invalid number" Error in Allocation Dashboard in PO Arrival Report

(Doc ID 2392056.1)

Last updated on MAY 07, 2018

Applies to:

Oracle Retail Allocation - Version 16.0.1 and later
Information in this document applies to any platform.


When attempting to retrieve incoming orders for a department in the Allocation dashboard the following error occurs:

Steps To Reproduce:

  1. Log into Allocation.
  2. Enter search criteria – Department -100 and click on Search
  3. Notice, Dashboard error on Purchase Order arrivals – week 1, 2, 3, 4.




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