Error "There Is a Problem With Json Data" When Viewing Cash Flow Curves & Tables : ORA-OO920-Invalid Relational Operator

(Doc ID 2345921.1)

Last updated on FEBRUARY 02, 2018

Applies to:

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

Symptoms

The Cash Flow curves and tables are not populating with data when attempting to open and view the Cash Flow in a Project/Shell. There is also error text displayed.

ERROR
-----------------------

"<Unifier URL> says: there is a problem with json data"

Unifier log files return: ORA-OO920-Invalid Relational operator

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

  1. Log into the Unifier environment
  2. Navigate to Project/Shell where you wish to view the Cash Flow and open the item
  3. Click on red text in Project Cash Flow Curves section to see the error
  4. Visually confirm that curves and curve detail in the bottom section don't populate

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms