The TABLE_NAME Column in the UDFVALUE Table Is Empty for Some User Defined Field (UDF) Records
(Doc ID 2319402.1)
Last updated on DECEMBER 01, 2021
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
When adding a UDF value (for example, within P6 Professional), the UDFVALUE.table_name field is set to a blank (null) value.
When adding a UDF value from P6 Professional, the UDFVALUE.table_name column for the row should be populated with the associated type and should not be null.
The issue can be reproduced using the following steps:
- Login to P6 Professional.
- Select Enterprise > User Defined Fields.
- Add an Activities UDF.
- Open a project.
- On the Activities page, add the UDF to the column list.
- Add a value and commit the changes.
- Run the following statement as the schema owner (default admuser) to confirm the UDFVALUE.table_name is a null value:
When performing the same action in the P6 Web application, this will result in the UDFVALUE.table_name field being populated with the associated UDF type. Additionally, when copy/pasting an activity which has some child object UDF value (where the UDFVALUE.table_name field is populated), the new activity results in a null UDFVALUE.table_name value.
This confirms that the issue is related to INSERT statements triggered from P6 Professional, no matter how the INSERT statement is initiated (either from a direct UDF value creation or from copy/paste).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!