My Oracle Support Banner

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 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.