Analytics Catalog/Oracle Fusion ERP/Fixed Assets/Data model
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · FA · Data model

Fixed Assets data model

Fixed Assets modeled as 2 conformed stars — each a fact at its own grain sharing the same dimensions. Open a star to drill into its fact and dimension columns; the last tab lists every bicc View Object the module exposes.

Free reference2 stars19 PVOs

Use case. Asset register, additions, and the cost behind FA-to-GL reconciliation.

ASSET_IDFA_BOOKSbook / cost▪ PK ASSET_IDCATEGORY_IDFA_CATEGORIES_Basset category▪ PK CATEGORY_IDDISTRIBUTION_IDFA_DISTRIBUTION_HISTORYassignment▪ PK DISTRIBUTION_IDCODE_COMBINATIO…GL_CODE_COMBINATIONSasset account▪ PK CODE_COMBINATION…LEGAL_ENTITY_IDXLE_ENTITY_PROFILESlegal entity▪ PK LEGAL_ENTITY_IDORGANIZATION_IDHR_ALL_ORGANIZATION_UNIT…assigned organization▪ PK ORGANIZATION_IDFA_ADDITIONS_Bfact · one row per assetCost · Net Book Value▪ PK ASSET_ID
●— fact → dimension join▪ PK = primary / join key

Fact — FA_ADDITIONS_B

Grain: one row per asset. Derived measures: Cost, Net Book Value. Drill into the fact columns:

ColumnDefinition
ASSET_NUMBERAsset number.
ASSET_TYPEType of asset.
COMMITMENTCommitment.
CURRENT_UNITSCurrent units.
INVENTORIALInventorial.
INVESTMENT_LAWInvestment law.
IN_USE_FLAGIndicator (Y/N) for the in use.
MANUFACTURER_NAMEName of the manufacturer.

all 15 columns & keys →

Dimensions / click any to drill into its columns

FA_BOOKS → · book / cost
ColumnDefinition
ADJUSTED_RECOVERABLE_COSTAdjusted recoverable cost.
ALLOWED_DEPRN_LIMITAllowed deprn limit.
ALLOWED_DEPRN_LIMIT_AMOUNTAllowed deprn limit amount.
CAPITALIZE_FLAGIndicator (Y/N) for the capitalize.
CONVERSION_DATEConversion date.
COSTCost.

all 20 columns & keys →

FA_CATEGORIES_B → · asset category
ColumnDefinition
CAPITALIZE_FLAGIndicator (Y/N) for the capitalize.
CATEGORY_TYPEType of category.
OWNED_LEASEDOwned leased.
PROPERTY_1245_1250_CODECode identifying the property 1245 1250.
PROPERTY_TYPE_CODECode identifying the property type.

all 5 columns & keys →

FA_DISTRIBUTION_HISTORY → · assignment
ColumnDefinition
DATE_INEFFECTIVEDate ineffective.
RETIREMENT_IDIdentifier for the retirement.
TRANSACTION_HEADER_ID_INTransaction header id in.
TRANSACTION_HEADER_ID_OUTTransaction header id out.
TRANSACTION_UNITSTransaction units.
UNITS_ASSIGNEDUnits assigned.

all 6 columns & keys →

GL_CODE_COMBINATIONS → · asset account
ColumnDefinition
ACCOUNT_TYPEType of account.
CHART_OF_ACCOUNTS_IDIdentifier for the chart of accounts.
CODE_COMBINATION_IDIdentifier for the code combination.
ENABLED_FLAGIndicator (Y/N) for the enabled.
END_DATE_ACTIVEEnd date active.
START_DATE_ACTIVEStart date active.

all 7 columns & keys →

XLE_ENTITY_PROFILES → · legal entity
ColumnDefinition
ACTIVITY_CODECode identifying the activity.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 73 columns & keys →

HR_ALL_ORGANIZATION_UNITS_F → · assigned organization
ColumnDefinition
ACTION_OCCURRENCE_IDIdentifier for the action occurrence.
BUSINESS_GROUP_IDIdentifier for the business group.
COST_ALLOCATION_KEYFLEX_IDIdentifier for the cost allocation keyflex.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
EFFECTIVE_END_DATEEnd date of the effective-dated record.

all 18 columns & keys →

Extracted by 9 BICC PVOs / same-module, fact first

These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.

full SCM & Procurement PVO → table map (Fixed Assets) →

Reports on this star

Use case. Depreciation expense and accumulated depreciation analysis.

ASSET_IDFA_ADDITIONS_Basset▪ PK ASSET_IDASSET_IDFA_BOOKSbook▪ PK ASSET_IDPERIOD_COUNTERFA_DEPRN_PERIODSdepreciation period▪ PK PERIOD_COUNTERCODE_COMBINATIO…GL_CODE_COMBINATIONSdepreciation expense account▪ PK CODE_COMBINATION…FA_DEPRN_DETAILfact · one row per asset per periodDepreciation Amount · YTD Depreciat…▪ PK ASSET_ID
●— fact → dimension join▪ PK = primary / join key

Fact — FA_DEPRN_DETAIL

Grain: one row per asset per period. Derived measures: Depreciation Amount, YTD Depreciation. Drill into the fact columns:

ColumnDefinition
ADDITION_COST_TO_CLEARAddition cost to clear.
BONUS_DEPRN_ADJUSTMENT_AMOUNTBonus deprn adjustment amount.
BONUS_DEPRN_AMOUNTBonus deprn amount.
BONUS_DEPRN_RESERVEBonus deprn reserve.
BONUS_YTD_DEPRNBonus ytd deprn.
COSTCost.
DEPRN_ADJUSTMENT_AMOUNTDeprn adjustment amount.
DEPRN_AMOUNTDeprn amount.

all 16 columns & keys →

Dimensions / click any to drill into its columns

FA_ADDITIONS_B → · asset
ColumnDefinition
ASSET_NUMBERAsset number.
ASSET_TYPEType of asset.
COMMITMENTCommitment.
CURRENT_UNITSCurrent units.
INVENTORIALInventorial.
INVESTMENT_LAWInvestment law.

all 15 columns & keys →

FA_BOOKS → · book
ColumnDefinition
ADJUSTED_RECOVERABLE_COSTAdjusted recoverable cost.
ALLOWED_DEPRN_LIMITAllowed deprn limit.
ALLOWED_DEPRN_LIMIT_AMOUNTAllowed deprn limit amount.
CAPITALIZE_FLAGIndicator (Y/N) for the capitalize.
CONVERSION_DATEConversion date.
COSTCost.

all 20 columns & keys →

FA_DEPRN_PERIODS → · depreciation period
ColumnDefinition
PERIOD_NAMEName of the period.

all 1 columns & keys →

GL_CODE_COMBINATIONS → · depreciation expense account
ColumnDefinition
ACCOUNT_TYPEType of account.
CHART_OF_ACCOUNTS_IDIdentifier for the chart of accounts.
CODE_COMBINATION_IDIdentifier for the code combination.
ENABLED_FLAGIndicator (Y/N) for the enabled.
END_DATE_ACTIVEEnd date active.
START_DATE_ACTIVEStart date active.

all 7 columns & keys →

Extracted by 9 BICC PVOs / same-module, fact first

These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.

full SCM & Procurement PVO → table map (Fixed Assets) →

Reports on this star

Every BICC PVO this module exposes, mapped to the physical tables it extracts from and the star it feeds.

PVOFully-qualified nameMaps to tablesFeeds star
DepreciationDetailPVOoracle.apps.financials.assets.depreciation.depreciation.publicView.analytics.DepreciationDetailPVOFA_BOOK_CONTROLS, FA_DEPRN_DETAILDepreciation fact
DepreciationEventsPVOoracle.apps.financials.assets.depreciation.depreciation.publicView.analytics.DepreciationEventsPVOFA_ADDITIONS_B, FA_BOOK_CONTROLS, FA_DEPRN_EVENTSAssets fact, Depreciation dim
CategoryBasePVOoracle.apps.financials.assets.depreciationSetup.categories.publicView.analytics.CategoryBasePVOFA_CATEGORIES_B, FA_CATEGORIES_TLAssets dim
AssetRetirementPVOoracle.apps.financials.assets.retirements.retirements.publicView.analytics.AssetRetirementPVOFA_ADDITIONS_B, FA_ASSET_RETIREMENTS_V, FA_CONVENTION_TYPESAssets fact, Depreciation dim
RetirementDistributionPVOoracle.apps.financials.assets.retirements.retirements.publicView.analytics.RetirementDistributionPVOFA_ADDITIONS_B, FA_ADJUSTMENTS, FA_ASSET_RETIREMENTS_VAssets fact, Depreciation dim
AdjustmentTransactionPVOoracle.apps.financials.assets.shared.publicView.analytics.AdjustmentTransactionPVOFA_ADDITIONS_B, FA_ADJUSTMENTS, FA_ASSET_INVOICESAssets fact, Depreciation dim
AssetInvoicePVOoracle.apps.financials.assets.shared.publicView.analytics.AssetInvoicePVOAP_INVOICE_DISTRIBUTIONS_ALL, FA_ASSET_INVOICES, PJC_PRJ_ASSET_LNS_ALLreference / config
BookPVOoracle.apps.financials.assets.shared.publicView.analytics.BookPVOFA_BONUS_RULES, FA_BOOKS, FA_CEILING_TYPESAssets dim, Depreciation dim
DistributionHistoryPVOoracle.apps.financials.assets.shared.publicView.analytics.DistributionHistoryPVOFA_DISTRIBUTION_HISTORY, FA_TRANSACTION_HEADERSAssets dim
FaLookupPVOoracle.apps.financials.assets.shared.publicView.analytics.FaLookupPVOFND_LOOKUPSreference / config
TransactionHeaderPVOoracle.apps.financials.assets.shared.publicView.analytics.TransactionHeaderPVOFA_ADDITIONS_B, FA_BOOKS, FA_BOOK_CONTROLSAssets fact, Depreciation dim
BookControlPVOoracle.apps.financials.assets.sharedSetup.bookControls.publicView.analytics.BookControlPVOFA_BOOK_CONTROLS, FA_DEPRN_PERIODSDepreciation dim
AdditionBasePVOoracle.apps.financials.assets.tracking.descriptiveDetails.publicView.analytics.AdditionBasePVOFA_ADDITIONS_B, FA_ADDITIONS_TLAssets fact, Depreciation dim
AssetTransferPVOoracle.apps.financials.assets.tracking.transfers.publicView.analytics.AssetTransferPVOFA_ASSET_TRANSFER_Vreference / config
AssetHistoryIBPVOoracle.apps.scm.installedBase.customerAssets.publicView.analytics.AssetHistoryIBPVOCSE_ASSETS_HIST, CSE_TRANSACTIONS, WIE_WORK_ORDERS_VLreference / config
CustomerAssetBuiltStructurePVOoracle.apps.scm.installedBase.customerAssets.publicView.analytics.CustomerAssetBuiltStructurePVOCSE_AS_BUILT_STRUCTURES_Vreference / config
CustomerAssetPVOoracle.apps.scm.installedBase.customerAssets.publicView.analytics.CustomerAssetPVOCSE_ASSETS_B, CSE_ASSETS_TL, CSE_GENEALOGY_OBJECTSreference / config
CustomerAssetSoldStructurePVOoracle.apps.scm.installedBase.customerAssets.publicView.analytics.CustomerAssetSoldStructurePVOCSE_AS_SOLD_STRUCTURES_Vreference / config
OSSProductAssociationsPVOoracle.apps.scm.installedBase.customerAssets.publicView.analytics.OSSProductAssociationsPVOOSS_SUBSCRIPTIONSreference / config
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.
Talk to us