The TABLE_NAME Column in the UDFVALUE Table Is Empty for Some User Defined Field (UDF) Records (Doc ID 2319402.1)

Last updated on OCTOBER 14, 2022

Applies to:

Symptoms

ACTUAL RESULTS

When adding a UDF value (for example, within P6 Professional), the table_name field in the UDFVALUE table is set to a null (blank) value.

EXPECTED RESULTS

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:

1. In P6 Professional select Enterprise > User Defined Fields.
2. Add an Activities UDF.
3. Open a project and go to the Activities page.
4. Add the UDF to the column list, add a value and commit the changes.
5. Using a tool such as SQLPlus or SQL Developer, connect to the P6 database as the schema owner (default admuser) to confirm the UDFVALUE.table_name column contains a null value(s):
   

ADDITIONAL INFORMATION

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).

Changes

Cause