My Oracle Support Banner

Line Item Data Picker Not Filtering Date Values, Instead Throwing 'Internal Server Error' (Doc ID 2748617.1)

Last updated on MARCH 23, 2021

Applies to:

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

Symptoms

On : 19.12.6.0 version, Unifier Application

Line Item Data Picker not filtering Values

A data picker where the Line items are filtered based on a Date Value: When it fetches the data from the picker it does not filter for the condition value, rather it throws an internal error for the picker Value itself. 

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

Internal Server Error

Unifier Log has below error:

error.java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected

STEPS
-----------------------

  1. Sign into Unifier
  2. Go to any Business Process (BP) - Data Picker Configurations - enter a query condition for a Data Element (DE) as 'greater than or equals' with value 'Today'
  3. Create BP record Line Item for the DE having the data picker value to fetch the date
  4. Observe the Error

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.