My Oracle Support Banner

W_Codes_Resources_hd Is Not Updated With Description After Change Made In P6 (Doc ID 2659642.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Primavera Data Warehouse - Version 18.8 to 19.12.3.0 [Release 18.8 to 19.12]
Information in this document applies to any platform.

Symptoms

Code Value and Description are NOT showing correctly in w_codes_resources_hd table.

Steps to Reproduce:

  1. Add a value for a Resource Code in P6 application.
  2. Run Global scheduled services Published Enterprise data and Resource management.
  3. Verify that data is present in px schema tables.
  4. Run the StarETL process and wait for it to complete.
  5. Verify that the data is loaded in tables staruser.W_CODES_RESOURCE_D and W_CODES_RESOURCE_HD
  6. In P6, update the description of an existing Resource code in the P6 application.
  7. Run Global scheduled services Published Enterprise data and Resource management.
  8. Run the StarETL process and wait for it to complete.
  9. Check the tables staruser.W_CODES_RESOURCE_D and in W_CODES_RESOURCE_HD.

Result:
w_codes_resource_d contains the "new code value and description".
A new row is added to w_codes_resource_hd table, but the description DOES NOT MATCH the new description (that was modified in P6).

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.