search cancel

Unable to select value for parameterized Lookup on Cost Plan Detail object

book

Article ID: 254177

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Unable to select value for parameterized Lookup on Cost Plan Detail object in version 16.0.3

Steps to Reproduce: 

1. Create a CIT Object (ex: program)
2. Create a sub-object of the CIT Object (ex: capability)
3. Create a dynamic lookup that returns all the capabilities from the sub-object to be selected at the program level. Example sql:
select 
@SELECT:c.id:[email protected],
@SELECT:c.code:[email protected],
@SELECT:c.name:[email protected]
from odf_ca_capability c
WHERE @[email protected] 
@BROWSE-ONLY:
  AND (@where:param:user_def:integer:[email protected] IS NULL OR
@where:param:user_def:integer:[email protected] = odf_parent_id)
:[email protected]

OR 

select 
@SELECT:c.id:[email protected],
@SELECT:c.code:[email protected],
@SELECT:c.name:[email protected]
from odf_ca_capability c
WHERE (@where:param:user_def:integer:[email protected] IS NULL OR
@where:param:user_def:integer:[email protected] = odf_parent_id)
AND @[email protected]


4. Add a new attribute to the Cost Plan Detail object based on the lookup created above and map inv_id to the parameter.

5. Financially enable your program instance record
6. Create a cost plan
7. Go to the Cost Plan Details
8. Add the new field tied to the lookup to the cost plan detail view
9. Observe you are only able to select the value once and after that it will not allow.

Expected Results: It should allow to update field value.

Actual Results: It does not allow to update field value.

Environment

Release : 16.0.3

Resolution

After testing this behaviour in 16.1.0 it is no longer reproduced.