Using view OKE_DTS_RECEIVABLES_V gives Invalid Number Error ORA-01722 After 19c Upgrade
(Doc ID 2918084.1)
Last updated on JANUARY 10, 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:
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 |