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

book

Article ID: 130544

calendar_today

Updated On:

Products

Clarity PPM SaaS 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

This is fixed in 15.6.1