My Oracle Support Banner

SYS Numeric Query Element Is Not Honoring "Equals" Condition (Doc ID 2986949.1)

Last updated on NOVEMBER 20, 2023

Applies to:

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


When Setting up Query Conditions for any SYS Numeric Query Element, if the condition is set to "Equals" the Value returned is always = 0, but when the condition is set to "Contains" the value generated is correct.

For the query condition to return the proper value when it's set to "Equals" like it does when it's set to "Contains".

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

  1. In Company Workspace click Configuration.
  2. Open the SOV.
  3. Observe the query condition for element "Upper Form/<Data Element Name>", see that it is set to "Equals".
  4. Navigate to the Project.
  5. Open the SOV -> Create New Record.
  6. Observe the "Upper Form/Data Element Name" Data Element is populating as 0 instead of the expected value based on the condition set.


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.