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 OCTOBER 09, 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:

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


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