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 18.104.22.168 [Release 20.12]
Information in this document applies to any platform.
P6 Web / BI Publisher Reporting
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
Assignment Codes should be published to the extended schema for reporting.
- Log in to P6 Web
- Create an Assignment Code with value under Administration > Enterprise Data > Resources > Assignment Codes
- Create a project and assign a resource to an activity
- Assign the Assignment Code to the assignment
- Publish Enterprise Data and projects
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