Search Results fa_deprn_basis_rules




Overview
Explore in AI Chat

Overview

FA_DEPRN_BASIS_RULES is an Oracle Assets (OFA) reference table that stores the depreciable basis rules used to determine how an asset's cost basis is calculated before depreciation is applied. Each row defines a distinct rule that governs which cost components — such as cost, salvage value, prior depreciation, or adjustments — are included when computing the depreciable basis of an asset. The table is owned by the FA schema and is present in both Oracle EBS 12.1.1 and 12.2.2, with the 12.2.2 physical schema documented as containing 14 columns.

From a Data Vault modeling perspective, the mined FK structure classifies this table as hub-leaning. This is a modeling suggestion: the surrogate primary key DEPRN_BASIS_RULE_ID behaves as a durable business key referencing a defined rule, while descriptive and operational attributes could conceptually be split into satellite structures in a Data Vault design. In practice, the table functions as a foundational lookup within the FA schema, referenced by multiple dependent objects that drive depreciation rule configuration.

Key Information Stored

The table is keyed by the surrogate primary key DEPRN_BASIS_RULE_ID, defined through the FA_DEPRN_BASIS_RULES_PK constraint. A parallel unique index, FA_DEPRN_BASIS_RULES_U1, covers DEPRN_BASIS_RULE_ID together with ZD_EDITION_NAME, forming the documented business-key candidate set.

The most significant columns include:

  • DEPRN_BASIS_RULE_ID — Unique identifier for each depreciable basis rule.
  • RULE_NAME — System-facing name of the rule.
  • USER_RULE_NAME — User-defined descriptive name presented in the application.
  • RATE_SOURCE — Identifies the source used to derive the depreciable rate or basis inputs.
  • DEPRN_BASIS — Defines the basis calculation method applied to the asset.
  • ENABLED_FLAG — Indicates whether the rule is active and available for selection.
  • DESCRIPTION — Free-form text describing the rule's purpose.
  • PROGRAM_NAME — Identifies the concurrent program or process associated with the record.
  • ZD_EDITION_NAME — Editioning column supporting Advanced Global Intercompany / edition-based redefinition behavior in 12.2.x.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record ownership and lifecycle.

Common Use Cases and Queries

Typical usage involves joining this table to depreciation rule details and depreciation methods to resolve the full depreciation configuration for an asset category. A representative query retrieves enabled rules with their descriptions:

  • SELECT deprn_basis_rule_id, rule_name, user_rule_name, deprn_basis, enabled_flag FROM fa_deprn_basis_rules WHERE enabled_flag = 'Y';
  • SELECT m.method_name, r.user_rule_name FROM fa_methods m, fa_deprn_basis_rules r WHERE m.deprn_basis_rule_id = r.deprn_basis_rule_id;
  • SELECT d.deprn_rule_detail_id, r.rule_name FROM fa_deprn_rule_details d JOIN fa_deprn_basis_rules r ON d.deprn_basis_rule_id = r.deprn_basis_rule_id;

Reporting scenarios include auditing which basis rules are active, confirming the basis mapping tied to each depreciation method, and validating configuration before asset additions or mass depreciation runs. Administrators also query this table when troubleshooting unexpected depreciable basis results across asset books.

Related Objects

Several FA and XLA objects reference DEPRN_BASIS_RULE_ID as a foreign key, making this table a central hub within the depreciation configuration model:

  • FA_DEPRN_RULE_DETAILS — References FA_DEPRN_BASIS_RULES via DEPRN_BASIS_RULE_ID; defines rule detail lines.
  • FA_METHODS — References the rule through DEPRN_BASIS_RULE_ID, linking depreciation methods to their basis rule.
  • FA_XLA_EXT_LINES_B_GT — Subledger accounting extension lines referencing DEPRN_BASIS_RULE_ID.
  • FA_XLA_EXT_LINES_STG_GT — Staging extension lines carrying the same foreign key for XLA processing.

These relationships confirm that basis rules feed both the core depreciation rule framework and the subledger accounting (XLA) integration layer, reinforcing the table's role as a configuration reference within Oracle Assets.