Assets
This section provides details about Oracle Fusion ERP Analytics Assets subject area metrics.
Financials - Assets Analysis
These metrics are used in the Analytics Currency (AC) and Ledger Currency (LC) fact folders in subject areas. Analytics currency and exchange rate Type are configured during product implementation. Exchange rate date basis uses period end date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| Asset Life - Months | Total life converted in months from asset financials summary. |
| Asset Life - Years | Total life converted in years from asset financials summary. |
| Avg Asset Original Life (Yrs) | Calculated in years based on asset life - months / current units. |
| Avg Asset Remaining Life (Yrs) | Calculated in years based on remaining life prorate date - years / current units. |
| Bonus Depreciation | Bonus depreciation from asset inquiry. |
| Current Cost | Current cost from assets inquiry. |
| Current Cost Post Depreciation | Shows the Current Cost after the depreciation program is complete. |
| Current Units | Current units available from asset assignment details. |
| Depreciation Adjustment Amount | Depreciation Adjustment amount from assets financial inquiry depreciation details. |
| Depreciation Expense | Depreciation expense from assets inquiry. |
| Depreciation Reserve | Depreciation reserve from assets inquiry. |
| Depreciation Reserve Ratio | Depreciation reserve ratio from assets inquiry. |
| Impairment Reserve | Impairment reserve from assets inquiry. |
| Lifespan Reached | Calculated in years as 1 - (remaining life prorate date - years / asset life - years). |
| Lifespan Remaining | Calculated in years as remaining life prorate date - years / asset life - years. |
| Net Book Value | Net book value from assets inquiry. |
| Original Cost | Original cost from assets inquiry. |
| Recoverable Cost | Recoverable cost from assets inquiry. |
| Remaining Life in Service Date - Months | Remaining life calculated in months from in service date available in asset financials summary. |
| Remaining Life in Service Date - Years | Remaining life calculated in years from in service date available in asset financials summary. |
| Remaining Life Prorate Date - Months | Remaining life calculated in months from prorate date available in asset financials summary. |
| Remaining Life Prorate Date - Years | Remaining life calculated in years from prorate date available in asset financials summary. |
| Revaluation Reserve | Revaluation reserve from assets inquiry. |
| Salvage Value | Salvage value from assets inquiry. |
| YTD Bonus Depreciation | YTD Bonus depreciation from asset inquiry. |
| YTD Depreciation | YTD depreciation from assets inquiry. |
| YTD Impairment | YTD Impairment from assets inquiry. |
Financials - Assets Transactions
These metrics will be used in the Analytics Currency (AC) and Ledger Currency (LC) fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| Adjustment Depreciation Expense | The sum of the transaction amount where account class code = DEPRECIATION EXPENSE and transaction type code = adjustment,addition |
| Asset Distribution Amount | Assets distribution amount metric for transactions excluding depreciation related distribution details. |
| Bonus Depreciation Adjustment | The sum of the transaction amount where account class code = BONUS DEPRECIATION EXPENSE and transaction type code = adjustment. |
| Bonus Depreciation Reserve | The sum of the transaction amount where account class code = BONUS DEPRECIATION RESERVE. |
| CIP Cost | The sum of the transaction amount where adjustment type = CIP COST. |
| Cost | The sum of the transaction amount where adjustment type = COST. |
| Cost Clearing | The sum of the transaction amount where adjustment type = COST CLEARING. |
| Cost of Removal | The sum of the transaction amount where adjustment type = REMOVALCOST. |
| Depreciation Distribution Amount | Depreciation distribution amount metric specifically captures depreciation related distribution details. |
| Depreciation Expense | The sum of the transaction amount where account class code = DEPRECIATION EXPENSE. |
| Depreciation Reserve | The sum of the transaction amount where account class code = DEPRECIATION RESERVE. |
| Impairment Expense | The sum of the transaction amount where adjustment type = IMPAIR EXPENSE. |
| Impairment Reserve | The sum of the transaction amount where adjustment type = IMPAIR RESERVE. |
| Net Book Value Retired | The sum of the transaction amount where adjustment type = NBV RETIRED. |
| Proceeds of Sale | The sum of the transaction amount where adjustment type = PROCEEDS. |
| Revaluation Reserve | The sum of the transaction amount where adjustment type = REVAL RESERVE. |
| Revaluation Reserve Retired | The sum of the transaction amount where adjustment type = REVAL RSV RET. |
| Units Assigned | Shows number of units assigned at the distribution level. |