My Oracle Support Banner

Project/Shell Creation Type Record: When Clicking On Send the Following Alert Pops Up: file://shell/api.xml: 128: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number (Doc ID 2755853.1)

Last updated on MARCH 01, 2021

Applies to:

Primavera Unifier Cloud Service - Version 20.12 to 20.12.2.0 [Release 20.12]
Primavera Unifier - Version 20.12.1.0 to 20.12.2.0 [Release 20.12]
Information in this document applies to any platform.

Symptoms

On Unifier : Version 20.12

When using a Project/Shell Creation type Business Process (BP) record, and trying to Send it through the Terminal status to the next step in the workflow:

Expected Result

The record should be able to be sent to the next step in the workflow without incident.

Actual Result

The following Alert pops up:

file://shell/api.xml: 128: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Something similar to the following is found written to the Unifier log files:

#c<unifier:/studio/bp/service/RollupRecord> a(errorMsg) ====>
[file:///shell/api.xml:128: java.sql.SQLSyntaxErrorException: 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.