Deleted Data is Loaded When Using Primavera Data Service (PDS) to Read P6 Data as ds_p6adminuser (Doc ID 2915468.1)

Last updated on DECEMBER 14, 2022

Applies to:

Symptoms

Deleted data is loaded in result set when querying the database using PDS with the ds_p6adminuser schema.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Delete an activity from a project in P6.

2. Run a request to load activities for the project. The deleted activity will be listed in the results.

 For example:
   POST https://<HOST>/<SERVICE_INSTANCE>/sync/rest-service/dataservice/runquery?configCode=ds_p6adminuser

   {"name":"My Activities","tables":[{"tableName":"TASK",
   "columns":["PROJ_ID","TASK_ID","TASK_NAME","TASK_TYPE","STATUS_CODE","ACT_START_DATE","ACT_END_DATE"],
   "condition":{"operator":"AND",
         "conditions":
               [{"columnName":"PROJ_ID","operator":"BETWEEN","value1":"355","value2":"548"}]}}]}

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.