My Oracle Support Banner

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 MARCH 18, 2019

Applies to:

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


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.


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

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

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


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

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