Portugal Localizations: CLE: Fiscal Gains And Losses Report Model31 completed with error 'java.sql.SQLSyntaxErrorException: ORA-01722: invalid number' (Doc ID 2598806.1)

Last updated on JULY 28, 2022

Applies to:

Symptoms

CLE: Fiscal Gains and Losses Report Model31 completed with error

ERROR
-----------------------
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the CLE: Fiscal Gains and Losses Report Model31 via SRS window.
2. Notice the error message in log file.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot submit the legal reports which will lead to penalty.

Changes

Cause

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