My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.