Primavera Analytics Subject Area Translations for UDF And Code Mappings Do Not Display the Correct Value in OBIEE after Adding Or Modifying a UDF/Code Mapping in Data Warehouse And Running the ETL Process (Doc ID 2086673.1)

Last updated on DECEMBER 16, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR

After running the Data Warehouse STARETL process to populate new user defined field or code translations, OBIEE does not reflect the modified UDF or Code in the Primavera Analytics Subject Area Translations.

For example:

1. Login to P6 EPPM and create a new UDF.
2. Run the 'Publish Enterprise Data' Global Scheduled Service.
3. Run the Data Warehouse Configuration Wizard and map the UDF on the UDF Mapping Screen.  (same situation can be considered when mapping a code on the Code Mapping Screen)
4. Run the Data Warehouse ETL process.
5. Login to OBIEE after the ETL process has been run.
6. Attempt to create a new analysis, and note that when using a subject area which should reflect the updated UDF, the subject area still displays the unmapped UDF name (for example, Text Activity UDF 6).  The same issue will occur when reviewing an existing analysis that had a translation.

The changes do not reflect until a restart of the OBIEE services are run.

EXPECTED BEHAVIOR

When adding or modifying existing user defined fields (UDF's) or Codes in P6 EPPM, for OBIEE to reflect the additional or modified UDF or Code in the Primavera Analytics Subject Area Translation after the Data Warehouse ETL process is run to update the STAR schema with the updated UDF or Code.  This should occur without a need to restart the OBIEE services.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.