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
Last updated on JULY 07, 2017
Applies to:Oracle Assets - Version 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms