My Oracle Support Banner

Errors Generated While Using UserService Webservice (Doc ID 2734727.1)

Last updated on DECEMBER 11, 2020

Applies to:

Primavera Web Services - Version 19.12.8.0 to 19.12.11.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

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.8.8.0 version and even in P6 19.12.8.0 version but for other web services.

OriginalSql = SELECT * FROM (SELECT users.curr_id CurrencyId,users.office_phone OfficePhone,users.user_id UserId,users.prof_id ProfileId,users.create_user CreateUser,users.create_date CreateDate,users.email_addr EmailAddress,users.user_name UserName,users.update_user LastUpdateUser,users.actual_name ActualName,users.all_rsrc_access_flag AllResourceAccessFlag,users.report_user_flag ReportingFlag,users.update_date LastUpdateDate FROM users WHERE ( 1 = 1 AND users.update_date > TUPPER(O_DATE('2019-04-28) 0UPPER(9:44:25','yyyy-mm-dd) hUPPER(h24:mi:ss'))) order by users.user_id asc) WHERE rownum <=10000001, Error Msg = ORA-00904: "TUPPER": invalid identifier
  



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.

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.