When an attribute type Lookup using a parameterized lookup is deleted, the record in ODF_LOOKUP_PARAMETERS table for that attribute is not deleted

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

When an attribute type 'lookup' using a parameterized lookup is deleted, the record of the mapping in ODF_LOOKUP_PARAMETERS table for that attribute is not deleted.

Steps to Reproduce:

1. Go to Admin side - Objects - Open Investment Object 
2. Create a new attribute: 
name=mylookup
id=mylookup 
type=lookup 
Select a dynamic lookup (parameterized lookup) 
Save the attribute 
Set the mapping [--object id --] 
Save the attribute 

3. Run query: 
select * from ODF_LOOKUP_PARAMETERS where lookup_attribute_name in ('mylookup') 
result: 1 row 

4. Delete the attribute you just create 

5. Run query again: 
select * from ODF_LOOKUP_PARAMETERS where lookup_attribute_name in ('mylookup') 

Expected Result: 
No result. The record for the attribute in the ODF_LOOKUP_PARAMETERS should have been deleted. 

Actual Result: 
result: 1 row. The record for the attribute in the ODF_LOOKUP_PARAMETERS was not deleted. 
 

Cause

Cause by DE48500

Environment

Release:
Component: ODSTU

Resolution

Open. Defect is target for resolution in future release.