My Oracle Support Banner

Data Incorrect or Missing in the Extended Schema For Reporting (Example: atcompletioncost in p6resourceassignment View) (Doc ID 2711941.1)

Last updated on SEPTEMBER 21, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12.8.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 19.12.8.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Resource Assignment Cost data is missing in the Extended Schema. Running the query against the Production database shows no results, whereas running the same query against the Stage database displays the cost data.

For example: Running "select atcompletioncost from p6resourceassignment;" shows no values.

EXPECTED BEHAVIOR
-----------------------
Resource Assignment Cost data should be visible in the Extended Schema so that the user can report on the data in BI Publisher.

STEPS
-----------------------

  1. Login to BI Publisher (BIP)
  2. Connect the data model to the data source for the P6 Prod database (example: P6RPT)
  3. Design a data model to query for atcompletion cost in p6resourceassignment view
  4. No data is displayed when executing against Prod database
  5. Connect the data model to the data source for the P6 Stage database, and notice the correct values displayed in the report

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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