When Using Oracle Primavera Cloud Service (OPC) Primavera Data Service (PDS) to Read UPDATE_TS for Activities or Lean Tasks the Dates Do Not Appear Correct
(Doc ID 2986316.1)
Last updated on NOVEMBER 13, 2023
Applies to:
Oracle Primavera Cloud Service - Version 21.1 and laterInformation in this document applies to any platform.
Symptoms
When reading Activities or Lean Task details using OPC PDS the UPDATE_TS in the response appears to have the wrong update date.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an OPC PDS query for the LN_TASK table
{
"name": "LN_TASK",
"sinceDate": null,
"tables": [
{
"tableName": "LN_TASK",
"columns": [
"TASK_ID",
"NAME",
"STATUS",
"PROJ_ID",
"TASK_TYPE",
"UPDATE_TS",
"ACTIVITY_ID"
],
"condition": {
"columnName": null,
"operator": "AND",
"value1": null,
"conditions": [
{
"columnName": "PROJ_ID",
"operator": "EQUALS",
"value1": "260701"
}
]
}
}
]
}
2. Notice all the UPDATE_TS fields appear to have the same date and time.
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 |