Primavera Data Service (PDS) Returns Dataset with the Column Sequence Different from That Is Specified in the JSON Payload (Doc ID 3078348.1)

Last updated on MARCH 24, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Primavera Data Service (PDS) query returns the dataset with the column sequence different from that is specified in the JSON payload.

For example, below is the list of columns sent to PDS in the JSON payload.
{
"tableName": "XXXXX",
"columns": [
"column1",
"column2",
"column3",
"column4",
"column5"
]
}

However, PDS returns the data with a different column sequence.
"data": {
"XXXXX": [
{
"column5": "xxxxx",
"column3": null,
"column1": "xxxxx",
"column4": "xxxxx",
"column2": "xxxxx"
},
...
]}

EXPECTED BEHAVIOR
-----------------------
PDS query returns the dataset with the same column sequence that is specified in the JSON payload.

STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Run PDS query and specify the table columns in the JSON payload.
2. The PDS dataset is returned with table columns of a different sequence.

Cause

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