My Oracle Support Banner

Error ORA-01722: Invalid Number When Trying To Printout Using RTF Template (Doc ID 2578552.1)

Last updated on APRIL 09, 2020

Applies to:

Primavera Unifier - Version 17.12.0.0 and later
Information in this document applies to any platform.

Symptoms

On Unifier : 17.12.0.0 version, Unifier User Mode

When attempting to print in PDF using a Custom Print RTF Template the preview window remains blank/empty and is not returning the expected data.

The following error is written to the log files.

ERROR IN LOG FILES
-----------------------
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create a business process
  2. Go to Configuration-> Custom Templates
  3. Create a new Custom Print with an Internal model and download the XML file
  4. Open Microsoft Word, load the XML in BI publisher plugin and start designing the RTF
  5. Load the RTF back to Unifier on the Custom Print Template
  6. Deploy
  7. Go back to business process record and try to print to the Custom Print Template

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.