Results for “fa_tax_interface_u1”

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

Overview

FA_TAX_INTERFACE is the Tax Book Interface table in the Oracle Assets (OFA) module, owned by the FA schema. Its documented role is to stage asset tax-book information that has been prepared for processing by the tax book generation programs. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the working interface between the corporate book and the tax book: records are populated for a given asset and book, typically through a concurrent request, and are then consumed by tax book generation and depreciation routines.

Under the heuristic Data Vault classification derived from its foreign-key structure, FA_TAX_INTERFACE is best modeled as a link. It sits at the intersection of assets (FA_ADDITIONS_B), book controls (FA_BOOK_CONTROLS), depreciation methods (FA_METHODS), conventions (FA_CONVENTION_TYPES), ceiling types (FA_CEILING_TYPES), ITC rates (FA_ITC_RATES), and concurrent requests (FND_CONCURRENT_REQUESTS), and it carries a composite unique key rather than an isolated surrogate identity. This classification is a modeling suggestion only; the physical table remains a standard EBS interface entity.

Key Information Stored

The table contains 88 documented columns. The most operationally significant are:

• ASSET_NUMBER and BOOK_TYPE_CODE — the two columns forming the primary key FA_TAX_INTERFACE_PK and the unique index FA_TAX_INTERFACE_U1. These are the business-key candidates that uniquely identify each staged tax-book record.
• ASSET_ID and GROUP_ASSET_ID — surrogate identifiers linking the row to FA_ADDITIONS_B for the asset and any associated group asset.
• COST, ORIGINAL_COST, SALVAGE_VALUE, ADJUSTED_RATE, BASIC_RATE — cost basis and rate attributes used by the tax depreciation calculation.
• DEPRN_METHOD_CODE, LIFE_IN_MONTHS, PRORATE_CONVENTION_CODE, CEILING_NAME — method, life, convention, and ceiling parameters that drive tax depreciation rules.
• DATE_PLACED_IN_SERVICE, ORIGINAL_DEPRN_START_DATE, CONVERSION_DATE, AMORTIZATION_START_DATE — dates controlling when depreciation and amortization begin.
• DEPRN_RESERVE, YTD_DEPRN, YTD_REVAL_DEPRN_EXPENSE, REVAL_RESERVE, UNREVALUED_COST — accumulated and period depreciation and revaluation balances.
• POSTING_STATUS and TAX_REQUEST_ID — the processing state and the foreign key to FND_CONCURRENT_REQUESTS that generated or governs the row.
• ITC_AMOUNT_ID, BONUS_RULE, PRODUCTION_CAPACITY, DEPRECIATE_FLAG — investment tax credit, bonus, units-of-production, and depreciation eligibility flags.
• ATTRIBUTE1–15, ATTRIBUTE_CATEGORY_CODE, and GLOBAL_ATTRIBUTE1–20 — descriptive flexfield storage available for client-specific extension.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include diagnosing tax book generation failures, reconciling tax versus corporate depreciation, and auditing rows linked to a specific concurrent request. A representative query joins the interface to book controls and concurrent requests:

• SELECT ti.asset_number, ti.book_type_code, ti.cost, ti.deprn_reserve, ti.posting_status FROM fa_tax_interface ti WHERE ti.book_type_code = :book AND ti.tax_request_id = :request_id;
• Reconciliation: compare DEPRN_RESERVE and YTD_DEPRN on FA_TAX_INTERFACE against FA_DEPRN_SUMMARY for the same asset and period.
• Error triage: locate rows where POSTING_STATUS indicates incomplete processing and correlate to TAX_REQUEST_ID in FND_CONCURRENT_REQUESTS.
• Method validation: join to FA_METHODS on DEPRN_METHOD_CODE and LIFE_IN_MONTHS to confirm the tax method applied.

Related Objects

• FA_ADDITIONS_B — joined on ASSET_NUMBER and GROUP_ASSET_ID; provides the asset definition.
• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; defines the tax book.
• FA_METHODS — joined on DEPRN_METHOD_CODE and LIFE_IN_MONTHS.
• FA_CONVENTION_TYPES — joined on PRORATE_CONVENTION_CODE.
• FA_CEILING_TYPES — joined on CEILING_NAME.
• FA_ITC_RATES — joined on ITC_AMOUNT_ID.
• FND_CONCURRENT_REQUESTS — joined on TAX_REQUEST_ID; tracks the generating request.