FAMAPT: Minus Bonus Expense Is Generated Unexpectedly When Amortize_nbv_flag = Y (Doc ID 2189114.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

 When perform Mass Additions(=FAMAPT) with bonus reserve and amortize_nbv_flag = Y, minus bonus expense is generated unexpectedly.

 

Steps to Reproduce
1.  Set bonus reserve and amortize_nbv_flag = Y to FA_MASS_ADDITIONS

    FA_MASS_ADDITIONS ***
    BONUS_DEPRN_RESERVE AMORTIZE_NBV_FLAG AMORTIZATION_START_DATE
    ------------------- ----------------- -----------------------
                   1000 Y                 2016/04/30

            
2.  Perform Mass Additions(=FAMAPT)

3.  Check the Asset

    FA_ADJUSTMENTS ***
    SOURCE_TYPE  ADJUSTMENT_TYPE FLAG ADJUSTMENT_AMT COUNTER
    ------------ --------------- ---- -------------- -------
    ADDITION     COST            DR           100000   24193
    ADDITION     COST CLEARING   CR           100000   24193
    DEPRECIATION BONUS EXPENSE   DR            -1000   24193  <---Wrong

      *Minus bonus expense is generated unexpectedly.


       Expected behavior
    FA_ADJUSTMENTS ***
    SOURCE_TYPE  ADJUSTMENT_TYPE FLAG ADJUSTMENT_AMT COUNTER
    ------------ --------------- ---- -------------- -------
    ADDITION     COST            DR           100000   24193
    ADDITION     COST CLEARING   CR           100000   24193

       *Minus bonus expense should NOT be generated.

 

       [Supplement]

       You can check the asset via Asset Trace or the following query:

select source_type_code as source_type
      ,adjustment_type
      ,debit_credit_flag as flag
      ,adjustment_amount as adjustment_amt
      ,period_counter_created as counter
  from fa_adjustments fa 
      ,fa_additions_b fab 
 where fa.asset_id         = fab.asset_id
   and fa.book_type_code   = '&book_type_code'
   and fab.asset_number    = '&asset_number' 
 order by 
       transaction_header_id
      ,source_type_code
      ,adjustment_type
      ,debit_credit_flag
 ;

 

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