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

Last updated on SEPTEMBER 09, 2020

Applies to:

Symptoms

ACTUAL RESULTS

When adding a UDF value (for example, within P6 Professional), the UDFVALUE.table_name field is set to a blank (null) 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. Login to P6 Professional
2. Select Enterprise > User Defined Fields.
3. Add an Activities UDF.
4. Open a project.
5. On the Activities page, add the UDF to the column list.
6. Add a value and commit the changes.
7. Run the following statement to confirm the UDFVALUE.table_name is a null value:

   • with udf_task_list as
     (
     select udftype.udf_type_id udftype_pk, udfvalue.udf_type_id udfvalue_fk1, udftype.udf_type_label, udftype.table_name udftype_tn, udfvalue.table_name udfvalue_tn, udfvalue.proj_id, project.proj_short_name, udfvalue.fk_id from udftype, udfvalue, project
     where udftype.udf_type_id=udfvalue.udf_type_id and udfvalue.proj_id=project.proj_id and udftype.table_name='TASK'
     and proj_short_name = '&Replace_With_ProjectID' order by udfvalue.proj_id
     )
     select udf_task_list.*, task.task_code from udf_task_list, task where task.task_id=udf_task_list.fk_id;

ADDITIONAL INFORMATION

When performing the same action in the P6 Web application, this will result in the UDFVALUE.table_name field to be populated with the associating 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

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