Line Item Data Picker Not Filtering Date Values, Instead Throwing 'Internal Server Error'
(Doc ID 2748617.1)
Last updated on MARCH 14, 2022
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
-----------------------
- Sign into Unifier
- 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'
- Create BP record Line Item for the DE having the data picker value to fetch the date
- 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 |