My Oracle Support Banner

UDF Text Fields Are Displaying Incorrect Data in an Analytics Analysis for Fields "BP UDF Text 70" Through "BP UDF Text 79" (Doc ID 2454560.1)

Last updated on MARCH 09, 2020

Applies to:

Primavera Analytics Cloud Service - Version 18.8 and later
Primavera Analytics - Version 18.8 and later
Information in this document applies to any platform.



UDF text fields, which are mapped to number 70-79 in Unifier, display incorrect data in Analytics after executing an ETL.  The data/values do not reflect the the actual values which should be returned by the Unifier field. 



An Analytics Analysis should display the correct values for any Business Process Text UDF that is mapped to numbers 70 - 79.


The following steps can be used to duplicate the reported issue:

  1. Login to Unifier as an Administrator
  2. Browse to Company Workspace
  3. Change to Admin View
  4. Click the Analytics link
  5. Highlight Business Process and click Edit
  6. Click the Data Mapping Tab
  7. Add a new BP Text UDF which maps to number 70 - 79. 
  8. Save changes.
  9. Run the Publication process
  10. Execute the Unifier ETL
  11. Create a new analysis using "Primavera - Business Process" subject area adding the BP text UDF to criteria.  When viewing the results, you will notice the wrong values are returned for the Unifier field. 




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

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