Business Process Subject Area Does Not Contain Data In Analytics After Running A Unifier ETL (Doc ID 2386960.1)

Last updated on AUGUST 29, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
-----------------------
When creating a new analysis in Analytics, the BP Dimension area is not showing the correct data. Additionally, after running a Unifier ETL:
The W_BP_DS table is getting populated with the total number of rows from the SYS_STG_BP table, but is not populating any value for majority of the required fields (example, bp_object_id, project_object_id).

EXPECTED BEHAVIOR
-------------------------
The ETL should correctly populate the W_BP_D/DS table

STEPS TO REPRODUCE
--------------------------
The issue can be reproduced at will with the following steps:

1. Run an ETL to populate the BP data
2. Create a new analysis in Analytics using the Business Process subject area
3. Observe the Dimension data is not populated correctly.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot report on the business process data correctly.

Changes

Cause

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