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

Article Id: 130544

Status: Published

Updated On: 05-04-2019 06:27

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , 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.