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 JULY 07, 2017

Applies to:

Oracle Assets - Version 11.5.10.0 to 12.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

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.

Cause

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 hundreds of Community platforms