Ora-01722: Invalid Number
(Doc ID 735146.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Purchasing - Version 11.5.10.2 to 11.5.10.4 [Release 11.5]Information in this document applies to any platform.
REPORT:POXACTPO.RDF - Purchasing Activity Register
Symptoms
-- Problem Statement:
On 11.5.10.2 in Production:
When run POXACTPO module: Purchasing Activity Register the following error occurs:
ERROR
ORA-01722: invalid number
select trunc ( poh . creation_date ) Creation_date , pdt . type_name PO_TYPE , poh.type_lookup_code PO_TYPE_CODE , poh . segment1 PO_NUMBER , ppf . full_name BUYER , POV. vendor_name VENDOR , poh .currency_code PO_CURRENCY , NVL ( SUM ( DECODE ...
Changes
Numbering Setup was was:
Receipt:Manual and Numeric.
PO:Manual and Alphanumeric.
Recently Changed to be Automatic numbering and Numeric
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |