When Using the Primavera Data Service (PDS) to Read Assignment Spreads from OPC the Filters Are Not Working as Expected (Doc ID 2924604.1)

Last updated on JANUARY 30, 2023

Applies to:

Symptoms

When using the OPC Primavera Data Service (PDS) to read assignment spread data, filtering on spread fields like PLANNED_UNITS is not returning results as expected. All spread results are returned no matter which spread field is specified in the filter. 

STEPS TO REPRODUCE:
1. Create a assignment spread request. e.g.
POST https://primavera.oraclecloud.com/data/rest/dataservice/assignmentSpread
{
    "pageSize": "100",
    "tables": [
        {
            "tableName": "SM_ASSIGNMENT",
            "columns": [
                "PROJ_OR_WS_ID",
                "SPREAD_TYPE"
            ],
            "condition": {
                "operator": "AND",
                "conditions": [
                    {
                        "columnName": "PLANNED_UNITS",
                        "operator": "GREATER_THAN_OR_EQUALS",
                        "value1": "8"
                    },
                    {
                        "columnName": "PROJ_ID",
                        "operator": "EQUALS",
                        "value1": "6101"
                    }
                ]
            }
        }
    ]
}

2. Check the results from the query and see that the project filter correctly filters the projects, but assignments with PLANNED_UNITS less than 8 are still returned in the results.

Changes

Cause

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