R12: "Post Mass Retirements" Program Finishes with "Cost retired cannot exceed current cost nor equal zero." Error in Tax Book (Doc ID 2350612.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Symptoms

"Post Mass Retirements" program finishes with "Cost retired cannot exceed current cost nor equal zero." error in Tax book.
In tax book, Alternate Ledger is set to use multi currency.
FA_MASS_EXT_RETIREMENTS.COST_RETIRED has the amount in Alternate Ledger's currency.

Sample Case:

1. Create the Corporate book and asset
   

   Book Name	: FA_CORP_BOOK
   Asset Number	: FA_BOOK-01
   Currency	: USD
   Cost	: 5555.55
   YTD depreciation	: 0
   Accumulated depreciation	: 0
   Date in Service	: 01-OCT-2017
   Depreciation method	: STL
   Salvage value	: 0
   Depreciation limit amount	: null

   
   
   
2. Create the Tax book and set Alternate Ledger.

   Alternate Ledger	: GLBOOK_SECOND
   Ledger Type	: Secondary
   Currency	: CAD
   Enabled	: Checked
   Daily Rate	: 50.83
   FA_MC_BOOKS.COST	: 282388.61

   
   
   
3. Create Mass Retirements
   Batch : MASSRET-1128 is created.
   
   
4. Update FA_MASS_EXT_RETIREMENTS.COST_RETIRED with the amount in Alternate Ledger's currency.
   In this case, user tries to retire CAD 141194.45 (in USD 2777.78 <- CAD 141194.45/50.83)
     

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.