The W_CODES_RESOURCE_HD Data Warehouse Table Is Not Being Updated (as Indicated via Resource Code History Report)
(Doc ID 2926750.1)
Last updated on MAY 01, 2023
Applies to:Primavera Analytics - Version 20.12 and later
Information in this document applies to any platform.
A Resource UDF History report generated via Primavera Analytics shows that the W_CODES_RESOURCE_D table is being updated as expected, however a Resource Code History report indicates that OBS Name data in the W_CODES_RESOURCE_HD table is not getting updated.
The W_CODES_RESOURCE_HD table should be updated each time code assignments are modified in P6.
The issue can be reproduced at will with the following steps:
- In Primavera Analytics create a report including the WBS ID, WBS Name, and OBS Name.
- Note that the OBS Name value is always the same.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!