INHERIT_DEF_RULES_FLAG Error with Category Reclass Via FBDI Spreadsheet
Last updated on JULY 24, 2017
Applies to:Oracle Fusion Assets Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Assets - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
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)
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