Lookup On a Project Subobject Lookup Defaults To Value In Error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE: 

1. Create an Object: Client Master
 Object ID: aaa_client_master
 API Attribute ID: custAaaClientMasters
 
2. Create a Dynamic Query Lookup -  
   Lookup Name: Country on Client L2 subobject (Parameterized)
   Lookup ID:  AAA_CLIENT_L2_COUNTRY
   
3. Query:
 SELECT  @SELECT:L.LOCATIONID:LOCATIONID@, 
   @SELECT:L.ID:ID@,
   @SELECT:L.SHORTDESC:COUNTRY@ 
 FROM ODF_MULTI_VALUED_LOOKUPS MV 
 JOIN LOCATIONS L ON L.LOCATIONID = MV.VALUE 
 WHERE @FILTER@
 AND MV.OBJECT = 'aaa_client_master' 
 AND MV.ATTRIBUTE = 'aaa_countries'
   @BROWSE-ONLY:
  AND MV.PK_ID = (SELECT C.ID FROM ODF_CA_AAA_CLIENT_MASTER C WHERE  C.CODE= @WHERE:PARAM:USER_DEF:STRING:CLIENT_PARAM@)
   :BROWSE-ONLY@

4. Create a Sub-Object of Project
   Object Name:  Deliverables
   Object ID:   visa_deliv_prj_l2
   API Attribute ID:  custAaaDelivPrjLs
   Master Object:   Project
   
   Attributes:
   Create typical attributes (see test case environment)
   and a field for the lookup above
   Attribute Name: Deliverable Country
   Attribute ID: aaa_deliv_country
   Data Type:  Lookup - STRING
 LOOKUP: Country on Client L2 subobject (Parameterized)
 API ATTRIBUTE ID:  v_deliv_country
 Lookup Parameter: 
 Client Param       aaa_del_client_name
 
5. Create a Blueprint for Projects with a Module - tab for Deliverables, Publish

6. Open a project that is using that blueprint

7. Go to the Deliverables tab

8. Click Plus sign for new row

9. Enter a value for Deliverable Client Name, Deliverable Kickoff Date, Deliverable Delivery Date, Stage and Deliverable Confidence

10. Wait for the Save

11. There should be no value for Deliverable Country at this point

12. Update one of the non-required columns
The Country will update to the first in the ordered list, for example: Afghanistan

Expected Results: Lookup should remain blank if nothing is selected

Actual Results: Lookup defaults to a value if nothing is selected

Workaround: Update the Deliverable Country Field and select -None-

 

Resolution

This is reported as DE63420 and is resolved in 16.0.1.