In The Requisition Summary Form, Requisition Number List Of Values Gives ORA-01722 (Doc ID 848855.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Purchasing - Version: 11.5.10 to 12.0.6 - Release: 11.5 to 12
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Using Core Purchasing, upon attempting to use the list of values for requisition number, it is giving an error.

Error:
ORA-01722: Invalid Number
FRM-40502: Oracle error: unable to read the list of values.

Replication Steps:
1. Login to the E-Business Suite - select Purchasing Super User or equivalent.
2. Proceed to the Requisitions Summary form
3. Attempt to use the list of values for the requisition number.
4. Error is encountered.

Other:
Numeric numbering is being used on the system, and has always been used.

Cause

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