My Oracle Support Banner

Error Creating Occurrence - Error : ORA-01722 : Invalid Number (Doc ID 2876704.1)

Last updated on JUNE 21, 2022

Applies to:

Oracle Fusion Tax Cloud Service - Version 11.13.22.04.0 and later
Information in this document applies to any platform.

Symptoms

Following error happens when try to create an occurrence (Collections Document Updates).
This issue start happening r updating to 22B

ERROR
-----------------------
ORA-01722 : Invalid Number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Receivable -> Billing -> Collection Remittance Batches for Brazil -> Manage Collection Documents
2. Look for a Document Number (e.g 163)
3. Under Collections Document Updates. Click on Actions -> Create.
  Code = 02
4 When trying to select a value from Code LOV get following error:
ORA-01722 invalid number


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
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.