Project Attribute Groups - Wrong Value In LOV-based Field (Doc ID 2367331.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Template has defined Attribute Group, which has LOV-based column.
When project is created by applying template, that column contains LOV ID, but not the value of LOV.
Expected behaviour is that the column would contain Value, not the ID.

Please note:
The LOV has $OBJECT$ reference.
When $OBJECT$ reference is removed, then that column contains the Value (e.g. behaviour is as expected).

But, business demands that the $OBJECT$ reference must be used.

Navigation
    Project super user -> Projects: Delivery -> Create project -> Create Project From Template

Table Data
TASK_ID PROJECT_ID TASK_NUMBER Task_Name
     3 2    10               Task Name1
     4         2                  20               Task Name2
     5         2                  30               Task Name3

Value Column
Name defined as: "Task_number ||'-'||Task_name"
Type: Char
Size: 60

Meaning Column
Name: task_name
Type: Char
Size: 30

ID Column
Name: task_id
Type: Char
Size: 8

Expecting to see:
--------------------

10 - Task Name 1
20 - Task Name 2

Actually Seeing:
3
4