Query to get the 11i Asset categories setup information with GL Code Combinations,Salvage value and depreciation rate

SELECT fcb.book_type_code, fc.segment1, fc.segment2, FC.DESCRIPTION,FC.ENABLED_FLAG,fc.category_type,
       fc.owned_leased,
       (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.ASSET_CLEARING_ACCOUNT_CCID) asset_clearing_cost,
        (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.ASSET_COST_ACCOUNT_CCID ) asset_cost,
         DEPRN_RESERVE_ACCT,
          fcb.DEPRN_EXPENSE_ACCT,
          (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.RESERVE_ACCOUNT_CCID) ACCUM_DEPRN,
  fcb.BONUS_DEPRN_EXPENSE_ACCT,
          BONUS_DEPRN_RESERVE_ACCT ,
          (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.BONUS_RESERVE_ACCT_CCID) BONUS_RESERVE_ACCT,
          fcb.CIP_COST_ACCT  ,
(select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.WIP_COST_ACCOUNT_CCID) CIP_cost,
          fcb.CIP_CLEARING_ACCT ,
(select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.WIP_CLEARING_ACCOUNT_CCID) CIP_CLEARING,
  fcbd.DEPRN_METHOD,
          fcbd.BASIC_RATE ,
          fcbd.ADJUSTED_RATE ,
 FCBD.LIFE_IN_MONTHS ,
 FCBD.PRORATE_CONVENTION_CODE,
 FCBD.RETIREMENT_PRORATE_CONVENTION,
 FCBD.PERCENT_SALVAGE_VALUE
  FROM fa_category_books fcb, fa_categories fc,fa_category_book_defaults fcbd
 WHERE  fcb.category_id = fc.category_id
 AND fcb.CATEGORY_ID=fcbd.CATEGORY_ID
 AND fcb.BOOK_TYPE_CODE=fcbd.BOOK_TYPE_CODE
--- AND Fcb.book_type_code =
  --AND fc.CATEGORY_ID=1

Creating the custom Depreciation method in oracle APPS

How to create Custom Depreciation method in Oracle Fixed Assets.

Requirement: 

There is an asset with cost of 10000. The life of asset is 3 years. Salvage value is 5%. Now if you want to calculate the depreciation with WDV method (63.16%) with life basis. And if you want to calculate the depreciation on salvage value.

For this we use the Calculated type Depreciation Method , system will not take the depreciation rate. And also you cannot calculate the depreciation salvage value.

If you use the Flat rate method, we cannot use the life of asset.

So for this we need to create a new depreciation method with formula method.

Create a new asset with this depreciation method 

Theoretical calculations for the above case

		asset cost =10000
		dep rate = 0.6316			2016 has 366 days
	NBV	Depraciation/yr			Depreciation/day	depreciation/30 days
1st Year					=6316/366= 17.256
	10000	6316	=10000-6316= 3684		17.2568306		517.704918
2nd Year
	3684	2326.8144	1357.186		6.374833973		191.2450192
3rd Year
	1357.186	857.198425	499.9872		2.348488836		70.45466507
	after 3 years the NBV is the salvage value=500

 

Now run the what if analysis for this asset.

 

Open the report output, and check the depreciation for each period.

 

In this way we can achieve the depreciation calculations