My Oracle Support Banner

Error: 'The System Could Not Process Your Request...' and 'ORA-01722: Invalid Number' When Clicking on a User Data Picker After Upgrading to Unifier 18.8.1 (Doc ID 2458775.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

After upgrading to Unifier 18.8.1, Data Pickers (User PK) is displaying the following generic system error when clicked.

ERROR
-----------------------
The system could not process your request. Logging in again may help in some cases. Contact your System Administrator if you are still having problems.

ADDITIONAL INFORMATION
------------------------
The following exception can be found in the Unifier.log file:

Error Msg = ORA-01722: invalid number at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
[wrapped] java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

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

  1. Identify a Data Picker (User PK) on a Business Process form.
  2. Open an existing BP record or create a new record.
  3. Click the Select button next to the Data Picker.

Changes

 

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
Changes
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.