Using View OKE_DTS_RECEIVABLES_V Gives Invalid Number Error ORA-01722 After 19c Upgrade
(Doc ID 2918084.1)
Last updated on OCTOBER 09, 2023
Applies to:
Oracle Project Contracts - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to use the view OKE_DTS_RECEIVABLES_V for a simple DML (Data Manipulation Language), after upgrade to 19C database, the following error occurs:
ERROR
-----------------------
ORA-01722: invalid number
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect via a SQLPLUS/SQLdeveloper/Any other tool for Database connection
2. Check the view OKE_DTS_RECEIVABLES_V
3. Use a simple query with this view for example:
select count(*) from oke_dts_receivables_v;
Error Starting at line :785 in command -
Error Report -
ORA-01722: Invalid Number
Changes
Database upgrade to version 19C.
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 |