My Oracle Support Banner

P6 Project Code Values Show as <NO VALUE> in Primavera Analytics (Doc ID 2731313.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Primavera Analytics Cloud Service - Version 19.12 to 20.8 [Release 19.12 to 20.8]
Primavera Analytics - Version 19.12 to 20.12 [Release 19.12 to 20.12]
Information in this document applies to any platform.


In P6 after assigning Project Code values to P6 projects and running the ETL, some of the values are not appearing in Primavera Analytics.

The issue can be reproduced at will with the following steps:

1. Assign Project Code values to several projects.
2. Verify the code is mapped correctly in the Primavera Analytics Admin.
3. Ensure the projects are published and the global publication jobs are run.
4. Run the ETL and verify it completes successfully.
5. In Analytics create a new analysis using the Primavera Activity Subject Area with the fields Project Id, Project Name and the project code.
6. Some of the projects may show a value while others show <NO VALUE>.




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.