When Creating or Copying an Activity in P6 Professional, the UDFVALUE.Table_Name Value is Null

(Doc ID 2320778.1)

Last updated on DECEMBER 12, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

DESCRIPTION OF PROBLEM:
When adding or copying an activity within P6 Professional, the UDFVALUE.table_name column is set to a null value.

EXPECTED OUTCOME:
When adding a UDF value from P6 Professional, the UDFVALUE.table_name column for the row should be populated with the associating type and should not be null.


STEPS TO REPRODUCE:

Login to P6 Professional

  1. Select Enterprise > User Defined Fields (UDF)
  2. Add an Activitiy UDF
  3. Open a project
  4. On the activities page add the UDF to the column list
  5. Add a value and commit changes
  6. Run the following statement (connected to the database through SQL*Plus or SQL Developer) which will confirm the UDFVALUE.table_name populated 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;
Note:
When performing the same action from P6 (web), this will result in the UDFVALUE.table_name 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 is populated), the new activity results in a null UDFVALUE.table_name.

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



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms