FAXMADDS: Default Value of Prepare Mass Additions Depreciation Tab (Doc ID 1939070.1)

Last updated on MAY 25, 2023

Applies to:

Symptoms

In Prepare Mass Additions, Depreciation Tab, the default values from Asset Categories are not displayed in some fields when the depreciation columns are null in fa_mass_additions interface table.

Only Depreciation Method fields can display the default values from Asset Category. 

The default values should be displayed in all fields if the columns are null so that customer may review what defaults will be taken at posting..

Steps to Reproduce
==============================
1.  Set the default values in Asset Category

    ----------------------------------------------
    Depreciation method       : JP-200DB 8
    Default Salvage Value     : 10%
    Depreciation limit amount : 1
    Prorate Convention        : JAN_M
    Bonus Rule                : DUMMY_RULE
    ----------------------------------------------


2.  Insert the record into FA_MASS_ADDITIONS with NULL

    PRORATE_CONVENTION_CODE     : NULL
    BONUS_RULE                  : NULL
    SALVAGE_VALUE               : NULL
    DEPRN_METHOD_CODE           : NULL
    LIFE_IN_MONTHS              : NULL
    BASIC_RATE                  : NULL
    ADJUSTED_RATE               : NULL
    SALVAGE_TYPE                : NULL
    PERCENT_SALVAGE_VALUE       : NULL
    DEPRN_LIMIT_TYPE            : NULL
    ALLOWED_DEPRN_LIMIT         : NULL
    ALLOWED_DEPRN_LIMIT_AMOUNT  : NULL


3.  Go to (N)Mass Additions > Prepare Mass Additions - [Depreciation]Tab

    Method                              : JP-200DB 8 *From Asset Category
    Life Years                          : 8          *From Asset Category
    Life Months                         : 0          *From Asset Category
    Prorate Convention                  : NULL
    Bonus Value                         : NULL
    Depreciation Limit - Type           : NULL
    Depreciation Limit - Limit Amount   : NULL
    Depreciation Limit - Percent        : NULL
    Salvage Value Type                  : NULL
    Salvage Value                       : NULL
    Salvage Value Percent               : NULL

    --> The default values are Not displayed in all fields.

    Expected Behavior
    ==============================
    Method                              : JP-200DB 8 *From Asset Category
    Life Years                          : 8          *From Asset Category
    Life Months                         : 0          *From Asset Category
    Prorate Convention                  : JAN_M      *From Asset Category
    Bonus Value                         : DUMMY_RULE *From Asset Category
    Depreciation Limit - Type           : Amount     *From Asset Category
    Depreciation Limit - Limit Amount   : 1          *From Asset Category
    Depreciation Limit - Percent        : NULL       *From Asset Category
    Salvage Value Type                  : Percent    *From Asset Category
    Salvage Value                       : NULL       *From Asset Category
    Salvage Value Percent               : 10%        *From Asset Category

Changes

Cause

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