My Oracle Support Banner

Performance Degradation While Running "MERGE INTO W_CODES_RESOURCE_D" or "MERGE INTO W_CODES_ACTIVITY_D" Statement During The ETL Process (ODI Or TRADITIONAL) For A P6 EPPM Datasource (Doc ID 2337374.1)

Last updated on JULY 12, 2018

Applies to:

Primavera Analytics - Version 17.11.0.0 and later
Primavera Data Warehouse - Version 17.7 and later
Primavera Analytics Cloud Service - Version 17.11.0.0 to 18.1 [Release 17.11 to 18.1]
Information in this document applies to any platform.

Symptoms

WHEN EXECUTING AN ODI ETL

Performance degradation with the following merge statement which runs during ODI ETL:

From:

Statement:

Which executes:

Note:

 

WHEN EXECUTING A TRADITIONAL ETL

Performance degradation with one or both of the following merge statements which run during a P6 EPPM ETL:

From:

Statement:

Which executes:

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!


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