Unable to Read Data From P6 Views ACTIVITY_FULL, PROJECT_FULL and PROJECT
(Doc ID 3027334.1)
Last updated on JUNE 27, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 23.12 to 23.12.5.0 [Release 23.12]Information in this document applies to any platform.
Symptoms
The views ACTIVITY_FULL, PROJECT_FULL or PROJECT are empty in the report user (PXRPTUSER) schema. This generates an error in some reports and data extractions. When executing the following SQL statement, it returns 0 results.
select "ACTIVITY_FULL"."OBJECTID" as "OBJECTID",
"ACTIVITY_FULL"."PROJECTOBJECTID" as "PROJECTOBJECTID",
"ACTIVITY_FULL"."WBSOBJECTID" as "WBSOBJECTID",
"ACTIVITY_FULL"."CALENDAROBJECTID" as "CALENDAROBJECTID",
"ACTIVITY_FULL"."ISNEWFEEDBACK" as "ISNEWFEEDBACK",
"ACTIVITY_FULL"."AUTOCOMPUTEACTUALS" as "AUTOCOMPUTEACTUALS",
"ACTIVITY_FULL"."PERCENTCOMPLETETYPE" as "PERCENTCOMPLETETYPE",
"ACTIVITY_FULL"."TYPE" as "TYPE",
"ACTIVITY_FULL"."DURATIONTYPE" as "DURATIONTYPE",
"ACTIVITY_FULL"."REVIEWSTATUS" as "REVIEWSTATUS"
from "PXRPTUSER"."ACTIVITY_FULL" "ACTIVITY_FULL"
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 |