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.

Symptoms

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

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

STEPS
-----------------------
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:

BUSINESS IMPACT
-----------------------
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.

Cause

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 hundreds of Community platforms