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 laterInformation 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |