Unable to select value for parameterized Lookup on Cost Plan Detail object after creation
search cancel

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

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.

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:ID@,
@SELECT:c.code:CODE@,
@SELECT:c.name:NAME@
from odf_ca_capability c
WHERE @FILTER@ 
@BROWSE-ONLY:
  AND (@where:param:user_def:integer:inv_id@ IS NULL OR
@where:param:user_def:integer:inv_id@ = odf_parent_id)
:BROWSE-ONLY@

OR 

select 
@SELECT:c.id:ID@,
@SELECT:c.code:CODE@,
@SELECT:c.name:NAME@
from odf_ca_capability c
WHERE (@where:param:user_def:integer:inv_id@ IS NULL OR
@where:param:user_def:integer:inv_id@ = odf_parent_id)
AND @FILTER@


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, 16.1.0

Resolution

DE67746, Fix targeted for 16.1.1.

Workaround: Put this attribure in the Flyout details where it works.