My Oracle Support Banner

Mapped P6 EPPM Project Code Values Disappeared And Are Not Coming Back With The P6 EPPM Scheduled ETL (ODI - LOAD_PLAN_DAILY) (Doc ID 2405863.1)

Last updated on JULY 12, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Primavera Data Warehouse - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
-----------------------
Project Codes which are assigned to projects within P6 EPPM and published to the extended schema are showing within Analytics for the equivalent project codes which are mapped in Data Warehouse (through the Analytics Administration Application) after running a Data Warehouse ETL.

Note: These project code values which now display were displaying properly within Analytics at one point from a prior ETL.


EXPECTED BEHAVIOR
-----------------------
Project Codes which are assigned to projects within P6 EPPM and published to the extended schema and are published to the extended schema should reflect the code value in Data Warehouse for the equivalent project codes which are mapped in Data Warehouse (through the Analytics Administration Application) after running one of the following:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Analytics Administration Application
2. Ensure codes are mapped under staretl1 > Codes
3. Browse to staretl1
4. Execute an ETL
5. Note the reported issue which occurs by creating a new analysis in Analytics to display a project and associated code values

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.