My Oracle Support Banner

Assignment Codes and Assignment Code Assignments Are Not Publishing to the Extended (PX) Schema for Reporting (Doc ID 2803588.1)

Last updated on DECEMBER 13, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 20.11 to 21.9 [Release 20.11 to 21.9]
Primavera P6 Enterprise Project Portfolio Management - Version 20.12 to 20.12.9.0 [Release 20.12]
Information in this document applies to any platform.

Symptoms

P6 Web / BI Publisher Reporting

ACTUAL BEHAVIOR
---------------

Assignment Codes and Assignment Code assignments are not present in the extended schema after publishing enterprise data and projects.

The values exist in ASGNMNTACAT but no rows in ASGNMNTACATX or pxrptuser.ASSIGNMENTCODE or pxrptuser.ASSIGNMENTCODEASSIGNMENT

EXPECTED BEHAVIOR
-----------------------

Assignment Codes should be published to the extended schema for reporting.

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

  1. Log in to P6 Web
  2. Create an Assignment Code with value under Administration > Enterprise Data > Resources > Assignment Codes
  3. Create a project and assign a resource to an activity
  4. Assign the Assignment Code to the assignment
  5. Publish Enterprise Data and projects

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