SBL-SCR-00128 Script Compilation Errors While Trying To Compile In One Environment (Doc ID 1931610.1)

Last updated on JULY 05, 2023

Applies to:

Symptoms

When we are trying to perform a full compilation in one of our environments, we are receiving the below errors:

"Script compilation failed at line 52 in procedure 'MeterReadFailureCheck':
Semantic Error around line 115:Type mismatch: L: Number; R: chars
(SBL-SCR-00128) "

"Script compilation failed at line 44 in procedure 'ConcatMeterReads':
Semantic Error around line 44:Type mismatch: L: Number; R: chars
(SBL-SCR-00128)."

However, the same compilation is running successfully in one environment (SCCTST1) but not in the other one (SFSDEV). Both the environments are on 8.1.1.11.

We have done a GET in our local environment for the BS and the compilation runs successfully.

SFSDEV is a new environment that we have been handed over and this is the first full compilation that we were trying to run.

Cause

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