Create Impairment List Of Values LOV For Impairment Date Placed In Service DPIS Errors With 'Unable to create sql for table validation type' In Web ADI
(Doc ID 759935.1)
Last updated on FEBRUARY 25, 2020
Applies to:Oracle Assets - Version 188.8.131.52 to 12.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
When entering information into a Web ADI spreadsheet to create an impairment, an error is received when selecting the list of values from the menu (or double clicking) on the impairment date.
The following error has occurred
Exception Name: oracle.apps.bne.exception.BneInvalidException - Program Error: Unable to create sql for table validation type, the column does not have a validation type of: TABLE!, Column Name; IMPAIRMENT_DATE
The date can be manually entered but cannot be entered using the LOV.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!