Search Results fa_deprn_basis_rules_u1

Overview

FA.FA_DEPRN_BASIS_RULES is a setup and reference table in the Oracle E-Business Suite Fixed Assets (FA) schema. It stores the depreciation basis rules that determine how an asset's depreciable basis is calculated, for example whether depreciation is applied to cost, cost less salvage value, or other defined bases. Each row defines a named rule that can subsequently be assigned to depreciation methods and depreciation rule details, which in turn drive the periodic depreciation engine and the transaction accounting entries generated through Subledger Accounting (XLA).

Because the table acts as a catalog of reusable business definitions that other FA tables reference by identifier, its heuristic Data Vault classification is hub-leaning. In a Data Vault model this suggests treating DEPRN_BASIS_RULE_ID as a hub business key, with descriptive attributes such as rule names, rate source, and depreciation basis carried on a satellite. The table is owned by FA, carries the FND Design Data reference OFA.FA_DEPRN_BASIS_RULES, and resides in the APPS_TS_SEED tablespace, confirming its role as seeded reference data rather than transactional data.

Key Information Stored

The table's primary key is FA_DEPRN_BASIS_RULES_PK on DEPRN_BASIS_RULE_ID, a NUMBER(15) surrogate identifier. A unique index, FA_DEPRN_BASIS_RULES_U1, exists on DEPRN_BASIS_RULE_ID combined with ZD_EDITION_NAME; this combination is the documented business-key candidate.

• DEPRN_BASIS_RULE_ID — surrogate primary key uniquely identifying each depreciation basis rule.
• RULE_NAME — seeded, system-delivered name of the rule.
• USER_RULE_NAME — user-defined name or translation displayed in the application.
• RATE_SOURCE — source of the depreciation rate associated with the rule.
• DEPRN_BASIS — the depreciation basis the rule applies, such as cost or cost less salvage value.
• ENABLED_FLAG — indicates whether the rule is active and selectable.
• DESCRIPTION — descriptive text explaining the rule's purpose.
• PROGRAM_NAME — name of the concurrent program that created or last modified the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns tracking creation and modification.
• ZD_EDITION_NAME — editioning column supporting Oracle EBS online patching (Edition-Based Redefinition).

Common Use Cases and Queries

The most frequent use is resolving the rule name and depreciation basis for a given rule identifier referenced from depreciation methods and rule details. A typical reporting query joins the unique key to foreign-key references:

• List all enabled rules: SELECT deprn_basis_rule_id, rule_name, user_rule_name, deprn_basis FROM fa.fa_deprn_basis_rules WHERE enabled_flag = 'Y';
• Resolve a rule used by a method: SELECT m.method_id, m.method_name, m.deprn_basis_rule_id, r.rule_name FROM fa.fa_methods m JOIN fa.fa_deprn_basis_rules r ON r.deprn_basis_rule_id = m.deprn_basis_rule_id;
• Audit changes: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to review setup modifications.
• Lookup/validation in extensions: query the table to validate a rule identifier before insert into custom staging or interface logic.

Related Objects

FA.FA_DEPRN_BASIS_RULES is referenced by several FA objects through the DEPRN_BASIS_RULE_ID column, and it does not itself reference any database object.

• FA.FA_DEPRN_RULE_DETAILS — references DEPRN_BASIS_RULE_ID; holds the depreciation rule detail lines that consume basis rules.
• FA.FA_METHODS — references DEPRN_BASIS_RULE_ID; associates a depreciation method with its basis rule.
• FA.FA_XLA_EXT_LINES_B_GT — references DEPRN_BASIS_RULE_ID in the Subledger Accounting extract line structure.
• FA.FA_XLA_EXT_LINES_STG_GT — references DEPRN_BASIS_RULE_ID in the XLA staging global temporary table.
• APPS.FA_DEPRN_BASIS_RULES — the APPS synonym that applications and reports query in place of the base table.

These relationships confirm the table's role as a parent reference source feeding the depreciation configuration hierarchy and the accounting extract pipelines.