INHERIT_DEF_RULES_FLAG Error with Category Reclass Via FBDI Spreadsheet (Doc ID 2082380.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Assets - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

There is a problem with the category reclass type in the FBDI template. There is a field in FBDI template titled 'inherit depreciation rules of new category'.
However the list of values (LOV) in that field does not have 'Y' or 'N' as expected. In lieu, it shows YNtypes.

Hence the interface load process ends in warning since it cannot recognize value of 'YNtypes' passed in this field.

Reclass works if no value is passed in the 'inherit depreciation rules of new category', but the intention at the time of reclass would always be
to let asset inherit depreciation rules from new category.

ERROR
-----------------------
Record 1: Rejected - Error on table FA_ADJUSTMENTS_T, column INHERIT_DEF_RULES_FLAG.
ORA-12899: value too large for column "FUSION"."FA_ADJUSTMENTS_T"."INHERIT_DEF_RULES_FLAG" (actual: 7, maximum: 1)


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