My Oracle Support Banner

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

Last updated on MARCH 20, 2018

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

 

 

 

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
Cause
Solution
References


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