Most attributes in Oracle assets are determined at the asset category level, and because a single category can hold thousands of assets, business users will have to perform transactions for each asset one by one. Oracle assets do offer options for performing bulk transactions, such as the mass change screen or the Adjustment API.
When it comes to bulk adjustments, API offers more flexibility. The following changes to an asset can be made using the API:
  •  Changing the cost of asset
  •  Changing depreciation method
  •  Changing Prorate Convention
  •  Bonus Rule update.
  •  Salvage Value/Type and percent
  •  Depreciation Limit/Amount or percent
  •  Changing depreciate flag
  • Changing Date placed in service of asset
We can see what parameters should be passed for the above changes in the table below
For adjustment to be amortized or expense transaction subtype has to be passed. It can be passed using below structure:
TRANS_REC_TYPE.TRANSACTION_SUBTYPE
 TRANS_REC_TYPE.AMORTIZATION_START_DATE
Structures for changing above details for adjustment on an asset.
  •  a. Changing cost of asset : ASSET_FIN_REC_TYPE.COST
  •  b. Changing depreciation method : ASSET_FIN_REC_TYPE.DEPRN_METHOD_CODE
  •     Based on type of method change LIFE_IN_MONTHS ,BASIC_RATE, ADJUSTED_RATE needs to  be populated. They are part of ASSET_FIN_REC_TYPE.
  • c. Changing Prorate Convention : ASSET_FIN_REC_TYPE.PRORATE_CONVENTION_ CODE
  •  d. Bonus Rule update: ASSET_FIN_REC_TYPE.BONUS_RULE
  •  e. Salvage Value/Type and percent : ASSET_FIN_REC_TYPE.SALVAGE_VALUE, ASSET_FIN_REC_TYPE.SALVAGE_TYPE and ASSET_FIN_REC_TYPE.PERCENT_SALVAGE_VALUE
  •  f. Depreciation Limit/Amount or percent : ASSET_FIN_REC_TYPE.DEPRN_LIMIT_TYPE,  ASSET_FIN_REC_TYPE.ALLOWED_DEPRN_LIMITand  ASSET_FIN_REC_TYPE.ALLOWED_DEPRN_LIMIT_AMOUNT
  •  g. Changing depreciate flag: ASSET_FIN_REC_TYPE.DEPRECIATE_FLAG
  •  h. Changing Date placed in service of asset :ASSET_FIN_REC_TYPE.DATE_PLACED_IN_ SERVICE
Please see Doc ID 206474.1 for sample adjustment API code and few other details.