AssetImpairmentDetail

Impairment details include the allocated impairment loss details, such as the net selling price, value in use, and impairment loss for each asset in the primary asset book.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetImpairmentDetailsExtract**

  Impairment details include the allocated impairment loss details, such as the net selling price, value in use, and impairment loss for each asset in the primary asset book.

  Label

  Asset Impairment Details

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • adjustedCost (big-decimal)

    Depreciable basis of the asset, calculated as the recoverable cost for cost basis depreciation methods, and the recoverable cost minus the accumulated depreciation for net book value basis methods.

    Label

    Adjusted Cost

    Properties

    • searchable
    • sortable
  • assetId (int64)

    The identifier of the asset number.

    Label

    Asset ID

    Properties

    • searchable
    • sortable
    • not nullable
  • bonusDepreciationAdjustmentAmount (big-decimal)

    Adjustment to the bonus depreciation amount for retroactive asset transactions.

    Label

    Bonus Depreciation Adjustment Amount

    Properties

    • searchable
    • sortable
  • bonusDepreciationAmount (big-decimal)

    Depreciation expense calculated due to bonus depreciation.

    Label

    Bonus Depreciation Amount

    Properties

    • searchable
    • sortable
  • bonusDepreciationReserve (big-decimal)

    The total amount of bonus depreciation recorded against an asset.

    Label

    Bonus Depreciation Reserve

    Properties

    • searchable
    • sortable
  • bonusRate (big-decimal)

    Rate for calculating bonus depreciation amounts.

    Label

    Bonus Rate

    Properties

    • searchable
    • sortable
  • bonusYtdDepreciation (big-decimal)

    Year-to-date bonus depreciation amount.

    Label

    Bonus YTD Depreciation

    Properties

    • searchable
    • sortable
  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

    • searchable
    • sortable
    • not nullable
  • capitalAdjustment (big-decimal)

    Capital adjustment balance for the period.

    Label

    Capital Adjustment

    Properties

    • searchable
    • sortable
  • cost (big-decimal)

    Total recorded cost of the asset.

    Label

    Cost

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • currentUnits (big-decimal)

    The number of units in the current period.

    Label

    Current Units

    Properties

    • searchable
    • sortable
  • depreciationAdjustmentAmount (big-decimal)

    Adjustment to the depreciation amount for retroactive asset transactions.

    Label

    Depreciation Adjustment Amount

    Properties

    • searchable
    • sortable
  • depreciationAmount (big-decimal)

    Asset depreciation expense amount.

    Label

    Depreciation Amount

    Properties

    • searchable
    • sortable
  • depreciationLimitAmount (big-decimal)

    Depreciation limit amount for the asset.

    Label

    Depreciation Limit Amount

    Properties

    • searchable
    • sortable
  • depreciationOverride (string)

    Indicates whether a depreciation override amount is allowed for assets in the book.

    Label

    Depreciation Override Indicator

    Properties

    • searchable
    • sortable
  • depreciationRateAdjustmentFactor (big-decimal)

    Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life.

    Label

    Depreciation Rate Adjustment Factor

    Properties

    • searchable
    • sortable
  • depreciationReserve (big-decimal)

    Total depreciation expense for the asset.

    Label

    Depreciation Reserve

    Properties

    • searchable
    • sortable
  • depreciationRunDate (date)

    The application date when the Calculate Depreciation process was run.

    Label

    Depreciation Run Date

    Properties

    • searchable
    • sortable
  • formulaFactor (big-decimal)

    Factor used to adjust the depreciation rate for formula-net book value method assets.

    Label

    Formula Factor

    Properties

    • searchable
    • sortable
  • generalFund (big-decimal)

    General fund balance for the period.

    Label

    General Fund Amount

    Properties

    • searchable
    • sortable
  • goodwillAssetFlag (boolean)

    Indicates whether the asset is a goodwill asset.

    Label

    Goodwill Asset Indicator

    Properties

    • searchable
    • sortable
  • historicalNetBookValue (big-decimal)

    The net book value of the asset calculated as if there were no impairments.

    Label

    Historical Net Book Value

    Properties

    • searchable
    • sortable
  • impairmentAmount (big-decimal)

    Impairment loss expense balance for the period.

    Label

    Impairment Amount

    Properties

    • searchable
    • sortable
  • impairmentDate (date)

    The date of the impairment transaction.

    Label

    Impairment Date

    Properties

    • searchable
    • sortable
  • impairmentId (int64)

    The identifier of the impairment transaction.

    Label

    Impairment ID

    Properties

    • searchable
    • sortable
    • not nullable
  • impairmentLossBalance (big-decimal)

    Impairment loss balance of the asset immediately after the impairment.

    Label

    Impairment Loss Balance

    Properties

    • searchable
    • sortable
  • impairmentReserve (big-decimal)

    Total impairment loss recognized for the asset.

    Label

    Impairment Reserve

    Properties

    • searchable
    • sortable
  • lifeToDateProduction (big-decimal)

    Life-to-date production for a units of production depreciation method.

    Label

    Life-to-Date Production

    Properties

    • searchable
    • sortable
  • nbvBeforeImpairment (big-decimal)

    The net book value of the asset before the impairment transaction.

    Label

    NBV Before Impairment

    Properties

    • searchable
    • sortable
  • netSellingPrice (big-decimal)

    The difference between the price for selling the asset and the cost of removal.

    Label

    Net Selling Price

    Properties

    • searchable
    • sortable
  • periodOfAddition (string)

    Indicates whether the asset is currently in the period of addition.

    Label

    Period of Addition

    Properties

    • searchable
    • sortable
  • priorFiscalYearExpense (big-decimal)

    The depreciation expense amount related to the previous fiscal year.

    Label

    Prior Fiscal Year Expense

    Properties

    • searchable
    • sortable
  • priorYearBonusExpenseAmount (big-decimal)

    The bonus depreciation expense amount related to the previous fiscal year.

    Label

    Prior Year Bonus Expense Amount

    Properties

    • searchable
    • sortable
  • priorYearDepreciationReserve (big-decimal)

    The depreciation reserve at the end of the previous fiscal year.

    Label

    Prior Year Depreciation Reserve

    Properties

    • searchable
    • sortable
  • productionQuantity (big-decimal)

    Current period production for a units of production asset.

    Label

    Production Quantity

    Properties

    • searchable
    • sortable
  • reason (string)

    Reason for performing the impairment transaction.

    Label

    Reason

    Properties

    • searchable
    • sortable
  • requestId (int64)

    Unique identifier assigned to each parallel worker.

    Label

    Request ID

    Properties

    • searchable
    • sortable
  • revaluationAmortization (big-decimal)

    Account used to book the periodic amortization of the revaluation reserve.

    Label

    Revaluation Amortization

    Properties

    • searchable
    • sortable
  • revaluationAmortizationBalance (big-decimal)

    Revaluation reserve amortization balance of the asset immediately after the impairment.

    Label

    Revaluation Amortization Balance

    Properties

    • searchable
    • sortable
  • revaluationDepreciationExpense (big-decimal)

    Portion of depreciation expense generated due to revaluation of the asset cost. Oracle Fusion Assets doesn't create any journal entries for this amount. It's for reporting purposes only.

    Label

    Revaluation Depreciation Expense

    Properties

    • searchable
    • sortable
  • revaluationLossBalance (big-decimal)

    The revaluation loss balance of the asset after revaluation.

    Label

    Revaluation Loss Balance

    Properties

    • searchable
    • sortable
  • revaluationReserve (big-decimal)

    During a period in which the asset was revalued, the change in the net book value due to revaluation of the asset cost. In some cases, it refers to revaluation of depreciation reserve.

    Label

    Revaluation Reserve

    Properties

    • searchable
    • sortable
  • revaluationReserveAdjustmentAmount (big-decimal)

    Change in the net book value due to a depreciation reserve adjustment for a revaluation period. For all other periods, the revaluation reserve amount after the Calculate Depreciation process is run.

    Label

    Revaluation Reserve Adjustment Amount

    Properties

    • searchable
    • sortable
  • revaluationReserveAmortizationBasis (big-decimal)

    The revaluation reserve amortization basis amount of the asset.

    Label

    Revaluation Reserve Amortization Basis

    Properties

    • searchable
    • sortable
  • systemBonusDepreciation (big-decimal)

    Bonus depreciation amount calculated by the application.

    Label

    System Bonus Depreciation

    Properties

    • searchable
    • sortable
  • systemDepreciation (big-decimal)

    Depreciation amount calculated by the application.

    Label

    System Depreciation

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable
  • valueInUse (big-decimal)

    Asset value in use for impairment evaluation.

    Label

    Value in Use

    Properties

    • searchable
    • sortable
  • ytdDepreciation (big-decimal)

    Year-to-date depreciation amount.

    Label

    YTD Depreciation

    Properties

    • searchable
    • sortable
  • ytdImpairment (big-decimal)

    Year-to-date impairment amount.

    Label

    YTD Impairment

    Properties

    • searchable
    • sortable
  • ytdProduction (big-decimal)

    Year-to-date production for assets depreciating in units of production methods.

    Label

    YTD Production

    Properties

    • searchable
    • sortable
  • ytdRevaluationDepreciationExpense (big-decimal)

    Year-to-date depreciation expense due to revaluation. Oracle Assets doesn't create any journal entries for this amount. It's for reporting purposes only.

    Label

    YTD Revaluation Depreciation Expense

    Properties

    • searchable
    • sortable

  Expand all

  Collapse all

  Reference Object

  • cashGeneratingUnit (AssetCashGeneratingUnit)

    A cash generating unit represents the smallest identifiable group of assets that generates cash inflows that are largely independent of the cash inflows from other assets or groups of assets.

    Business Object

    AssetCashGeneratingUnit

    Expand all

    Collapse all

    Fields

    • cashGeneratingUnitId (int64)

      The unique identifier of the cash generating unit.

      Label

      Cash Generating Unit ID

      Properties

      • searchable
      • sortable
      • not nullable

  • impairmentPeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable
    • periodId (int64)

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top