My Oracle Support Banner

Why Are There Thousands of Inserts Against W_PROJECTCODEASSIGNMENT_DS, W_PROJECT_SECURITY_SS and W_RESOURCE_ASSIGNMENT_DS? (Doc ID 2505340.1)

Last updated on DECEMBER 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.12.2.0 to 17.12.2.0 [Release 17.12]
Primavera Analytics - Version R3.1 and later
Primavera Data Warehouse - Version R3.1 and later
Information in this document applies to any platform.

Goal

Why are there thousands of executions of the following queries during each STARETL run?


INSERT /*+ APPEND */ INTO W_PROJECTCODEASSIGNMENT_DS(PROJECTOBJECTID, PROJECTCODETYPEOBJECTID, PROJECTCODEOBJECTID, PROJECTCODEDESCRIPTION, PROJECTCODETYPENAME, PROJECTCODEVALUE, PROJECTNAME, ISSECURECODE, LASTUPDATEUSER, LASTUPDATEDATE, CREATEUSER, CREATEDATE, DATASOURCE_ID) SELECT PROJECTCODEASSIGNMENT.PROJECTOBJECTID, PROJECTCODEASSIGNMENT.PROJECTCODETYPEOBJECTID, PROJECTCODEASSIGNMENT.PROJECTCODEOBJECTID, PROJECTCODEASSIGNMENT.PROJECTCODEDESCRIPTION, PROJECTCODEASSIGNMENT.PROJECTCODETYPENAME, PROJECTCODEASSIGNMENT.PROJECTCODEVALUE, PROJECTCODEASSIGNMENT.PROJECTNAME, PROJECTCODEASSIGNMENT.ISSECURECODE, PROJECTCODEASSIGNMENT.LASTUPDATEUSER, PROJECTCODEASSIGNMENT.LASTUPDATEDATE, PROJECTCODEASSIGNMENT.CREATEUSER, PROJECTCODEASSIGNMENT.CREATEDATE, 1 FROM PROJECTCODEASSIGNMENT@DSLINK01 WHERE PROJECTOBJECTID = :proj_id

INSERT /*+ APPEND */ INTO W_PROJECT_SECURITY_SS(RDBMSUSERID, COSTFLAG, PROJECTOBJECTID, DATASOURCE_ID) SELECT distinct PROJECTSECURITY.RDBMSUSERID, PROJECTSECURITY.COSTFLAG, PROJECTSECURITY.PROJECTOBJECTID, 1 FROM PROJECTSECURITY@DSLINK01 WHERE PROJECTOBJECTID = :proj_id

INSERT /*+ APPEND */ INTO W_RESOURCE_ASSIGNMENT_DS(RESOURCE_ASSIGNMENT_OBJECT_ID, RESOURCE_OBJECT_ID, ROLE_OBJECT_ID, ACTIVITY_OBJECT_ID, WBS_OBJECT_ID, COST_ACCOUNT_OBJECT_ID, PROJECT_OBJECT_ID, DATASOURCE_ID) SELECT RESOURCEASSIGNMENT.OBJECTID, RESOURCEASSIGNMENT.RESOURCEOBJECTID, RESOURCEASSIGNMENT.ROLEOBJECTID, RESOURCEASSIGNMENT.ACTIVITYOBJECTID, RESOURCEASSIGNMENT.WBSOBJECTID, RESOURCEASSIGNMENT.COSTACCOUNTOBJECTID, RESOURCEASSIGNMENT.PROJECTOBJECTID, 1 FROM RESOURCEASSIGNMENT@DSLINK01 WHERE PROJECTOBJECTID = :proj_id

Solution

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
Goal
Solution
References


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