Results for “fa_convention_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_CONVENTION_TYPES is a reference (lookup) table in the Oracle Assets (OFA) module, owned by the FA schema. It stores the names, descriptions, and behavioral flags that define prorate conventions — the rules that determine how much depreciation expense is taken in the period an asset is acquired, and how partial-period depreciation is spread for both additions and retirements. Because depreciation calculations are sensitive to period boundaries, every depreciation book, category-book default, and retirement transaction must resolve to a valid prorate convention defined in this table.

In Data Vault modeling terms, the mined foreign-key structure classifies FA_CONVENTION_TYPES as hub-leaning. This is a modeling suggestion: the table behaves as a central reference hub whose business key (PRORATE_CONVENTION_CODE) is referenced by many dependent transactional and setup satellites across the Assets schema, rather than as a transactional or link entity itself. It has no foreign keys pointing outward to other tables, confirming its role as a top-level reference source.

Key Information Stored

The table contains 25 documented columns. The most significant are:

• PRORATE_CONVENTION_CODE — the primary key (FA_CONVENTION_TYPES_PK) and business key. It uniquely identifies each convention and is also defined by the unique index FA_CONVENTION_TYPES_U1. This is the value carried into all dependent tables.
• DESCRIPTION — the user-facing name of the convention, such as a mid-month, half-year, or full-month rule, displayed in Assets setup and transaction forms.
• FISCAL_YEAR_NAME — identifies the fiscal year context to which the convention applies, allowing year-specific prorate behavior.
• DEPR_WHEN_ACQUIRED_FLAG — controls whether depreciation is taken in the period the asset is acquired; it directly drives the timing of the first depreciation charge.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns, providing extensibility for client-specific convention attributes without schema changes.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, and LAST_UPDATE_LOGIN, which record who created and last modified each convention.

The surrogate primary key and the business-key candidate coincide here (PRORATE_CONVENTION_CODE), which is common for reference tables in EBS.

Common Use Cases and Queries

Typical scenarios include validating book and category setup, auditing which conventions are in use, and building depreciation reporting joins.

• Listing all conventions for setup review: SELECT PRORATE_CONVENTION_CODE, DESCRIPTION, DEPR_WHEN_ACQUIRED_FLAG FROM FA.FA_CONVENTION_TYPES ORDER BY PRORATE_CONVENTION_CODE;
• Joining books to their conventions: SELECT b.BOOK_TYPE_CODE, c.DESCRIPTION FROM FA.FA_BOOKS b JOIN FA.FA_CONVENTION_TYPES c ON b.PRORATE_CONVENTION_CODE = c.PRORATE_CONVENTION_CODE;
• Finding conventions referenced by category-book defaults for both additions and retirements: join FA_CATEGORY_BOOK_DEFAULTS on PRORATE_CONVENTION_CODE and RETIREMENT_PRORATE_CONVENTION.
• Auditing retirement rules by joining FA_RETIREMENTS or FA_MC_RETIREMENTS on RETIREMENT_PRORATE_CONVENTION.

Because the table is small and static, it is commonly cached in reporting extracts and joined as a dimension to depreciation and transaction fact queries.

Related Objects

FA_CONVENTION_TYPES is referenced by numerous Assets tables through PRORATE_CONVENTION_CODE and, for retirements, RETIREMENT_PRORATE_CONVENTION. The most significant dependents are:

• FA_BOOKS — references FA_CONVENTION_TYPES.PRORATE_CONVENTION_CODE at the book level.
• FA_CATEGORY_BOOK_DEFAULTS — references PRORATE_CONVENTION_CODE and RETIREMENT_PRORATE_CONVENTION, defining per-category defaults.
• FA_CONVENTIONS — the operational conventions table, joined via PRORATE_CONVENTION_CODE.
• FA_RETIREMENTS and FA_MC_RETIREMENTS — reference RETIREMENT_PRORATE_CONVENTION for retirement proration.
• FA_MASS_CHANGES and its interface tables FA_MASS_CHANGES_ITF and FA_MASS_RECLASS_ITF — reference FROM_CONVENTION, TO_CONVENTION, and CONVENTION.
• FA_ACE_BOOKS, FA_MC_BOOKS, FA_SHORT_TAX_RESERVES, and FA_TAX_INTERFACE — all reference PRORATE_CONVENTION_CODE.

These relationships confirm that FA_CONVENTION_TYPES is a foundational reference object whose codes propagate throughout Assets depreciation and tax processing.