Errors Generated While Using UserService Webservice
(Doc ID 2734727.1)
Last updated on DECEMBER 11, 2020
Applies to:Primavera Web Services - Version 184.108.40.206 to 220.127.116.11 [Release 19.12]
Information in this document applies to any platform.
After upgrading from P6 18.8. 8 to 19.12.8, it was noticed that an unexpected error is generated while using the P6 web service UserService - ReadUser method with Filters.
The error is generated only for UserService - ReadUser, only in these cases:
1. While using the filters with the exact date ( 1=1 AND LastUpdateDate ='2019-04-28T09:44:25')
2. While using the filters with the date bigger than a value 1=1 AND LastUpdateDate > TO_DATE('2019-04-28 09:44:25' , 'yyyy-mm-dd hh24:mi:ss')
3. While using the filters with the name but with a conversion ( 1=1 AND Name=UPPER('client.name'))
The filter works as expected only while using the filters with the exact name value without any conversion ( 1=1 AND Name='CLIENT.NAME')
All these filters indicated above are working as expected in P 18.104.22.168 version and even in P6 22.214.171.124 version but for other web services.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Try to use the UserService webservice with a Filter defined in different ways as indicated above
2. Notice the error
Due to this issue, users cannot use the filters for this UserService web service correctly.
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