My Oracle Support Banner

Data Warehouse Workflow Tables Not Populated Causing Analysis Using "Primavera - Workflow" Subject Area To Return No Results (Doc ID 2338858.1)

Last updated on DECEMBER 13, 2017

Applies to:

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


ODI ETL is not populating the following Data Warehouse tables from a Unifier Data source:

When running an ODI ETL against a Unifier data source, for data to be inserted into the following fact/dimension tables:

The issue can be reproduced at will with the following steps:
1. Execute an ODI ETL
2. Run the following SQL to confirm that no rows are being processed post ETL:

The issue has the following business impact:
This causes any analysis which uses workflow fact/dimension data from "Primavera - Workflow" subject area to not return results.


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.