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 220.127.116.11 [Release 19.9 to 19.12]
Primavera Unifier - Version 19.12 to 18.104.22.168 [Release 19.12]
Information in this document applies to any platform.
On : 22.214.171.124 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.
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
- 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
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