My Oracle Support Banner

Web Service Calls That Include the 'filterCondition' Data Tag Are Not Filtering Records in the XML Response (Doc ID 2407507.1)

Last updated on AUGUST 03, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

When performing a Web Service call and using the filterCondition data tag, all rows for the records in the BP are returned.

EXPECTED BEHAVIOR

The XML response should only return records based on the specified filterCondition criteria.

 

The issue can be reproduced at will with the following steps:

  1. Log into the Primavera Unifier environment to download the WSDL file.
  2. Launch the SoapUI application and create a new project.
  3. Open a Web Service call, for example getBPList, and create a new entry.
  4. Post the end point URL.
  5. Populate the XML as in the following example (replacing the generic placeholders with valid values):

         <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:gen="http://general.service.webservices.skire.com">
           <soapenv:Header/>
           <soapenv:Body>
              <gen:getBPList>
                <!--Optional:-->
                <gen:shortname>Company_Shortname</gen:shortname>
                <!--Optional:-->
                <gen:authcode>Authentication_Code</gen:authcode>
                <!--Optional:-->
                <gen:projectNumber>Project_Number</gen:projectNumber>
                <!--Optional:-->
                <gen:BPName>BP_Name</gen:BPName>
                <!--Zero or more repetitions:-->
                <gen:fieldnames/>
                <!--Optional:-->
                <gen:filterCondition>data_element=your_filter_condition</gen:filterCondition>
                <!--Zero or more repetitions:-->
                <gen:filtervalues>showlineitems=no</gen:filtervalues>
              </gen:getBPList>
           </soapenv:Body>
         </soapenv:Envelope>

  6. Execute the XML.
  7. Note the response includes records that should have been filtered out.

Changes

 The Cloud environment was updated from the Primavera Unifier 18.4.0.0 version to the 18.5.0.0 version.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.