My Oracle Support Banner

R12: "NBV at the time of Switch" Is Not Updatable in JP-200DB Method on Mass Additions Window (Doc ID 2207472.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After inserting an asset with Deprn Method:JP-200DB, "NBV at the time of Switch" is not updatable on Mass Additions window even though the asset is revised.
NOTE: If the assets has Deprn Method:JP-250DB, this field is updatable when the asset is revised because this case is fixed by <Bug 14620236>.

Reproduce Step

  1. Insert data in to FA_MASS_ADDITIONS. *** JUN-16
     
    MASS_ADDITION_ID 1385084
    ASSET_NUMBER FA_BOOK-01
    BOOK_TYPE_CODE FA_BOOK
    DESCRIPTION BBBBBBBB
    DATE_PLACED_IN_SERVICE 2013/05/31
    FIXED_ASSETS_COST 735200
    POSTING_STATUS NEW
    QUEUE_NAME NEW
    DEPRECIATE_FLAG YES
    ASSET_TYPE CAPITALIZED
    DEPRN_RESERVE 609482
    YTD_DEPRN 41908
    NEW_USED NEW
    NBV_AT_SWITCH 167624


  2. Set Default Depren method to JP-200DB 5.


  3. Open Mass Additions window.
    "NBV at the time of Switch" is not updatable.

    Recalculation
    TRUNC(FIXED_ASSETS_COST * ln_Guaranteed_Rate)
    = TRUNC(735200 * 0.108)
    = 79401

    TRUNC((FIXED_ASSETS_COST - (DEPRN_RESERVE - YTD_DEPRN ))* ln_Original_Rate)
    = TRUNC((735200 - (609482 - 41908 ))* 0.4)
    = 67050

    -> Thus, the Asset uses Revised Rate.

     

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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