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 FOR ITGCLARITY PPM FEDERALClarity PPM SaaSClarity 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.