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 and later
Information in this document applies to any platform.


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

ORA-01722 : Invalid Number

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


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

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