Search Results fa_tax_interface




Overview
Explore in AI Chat

Overview

The FA_TAX_INTERFACE table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It functions as a staging and interface table specifically designed for managing tax book data. Its primary role is to serve as an intermediary repository for asset tax information that is being processed, validated, or transferred between the corporate book and associated tax books. This includes capturing key tax-specific attributes such as depreciation methods, life, conventions, and Investment Tax Credit (ITC) details before they are formally posted or reconciled within the tax book structures, facilitating accurate tax reporting and compliance.

Key Information Stored

The table stores a combination of asset identifiers and tax-specific depreciation rules. Key columns include the composite primary key of ASSET_NUMBER and BOOK_TYPE_CODE, which links the interface record to a specific asset in a specific book. Other critical columns define the tax depreciation policy: DEPRN_METHOD_CODE and LIFE_IN_MONTHS (referencing FA_METHODS), PRORATE_CONVENTION_CODE (referencing FA_CONVENTION_TYPES), and CEILING_NAME (referencing FA_CEILING_TYPES). The ITC_AMOUNT_ID links to FA_ITC_RATES for tax credit details. The TAX_REQUEST_ID column, referencing FND_CONCURRENT_REQUESTS, is pivotal for tracking and managing the batch processes, such as mass additions transfers or tax book reconciliation, that populate and act upon this interface data.

Common Use Cases and Queries

A primary use case is the review of pending tax book updates or error records during the transfer of assets from the corporate book. Administrators often query this table to diagnose failed transactions or validate data before submission. Common SQL patterns include identifying interface records for a specific asset or batch process, and joining to related master tables for descriptive reporting.

  • To find all interface records for a specific concurrent request: SELECT * FROM fa_tax_interface WHERE tax_request_id = &request_id;
  • To validate tax depreciation rules for assets pending transfer, joining to descriptive tables: SELECT fti.asset_number, fti.book_type_code, fm.method_code, fc.convention_code FROM fa_tax_interface fti, fa_methods fm, fa_convention_types fc WHERE fti.deprn_method_code = fm.method_code AND fti.prorate_convention_code = fc.convention_code AND fti.group_asset_id IS NULL;

Related Objects

The FA_TAX_INTERFACE table maintains documented foreign key relationships with several foundational Fixed Assets tables, ensuring referential integrity. These relationships, as per the provided metadata, are:

  • FA_ADDITIONS_B: Linked via ASSET_NUMBER and GROUP_ASSET_ID to the core asset master.
  • FA_BOOK_CONTROLS: Linked via BOOK_TYPE_CODE to define the book context.
  • FA_METHODS: Linked via DEPRN_METHOD_CODE and LIFE_IN_MONTHS for depreciation rules.
  • FA_CONVENTION_TYPES: Linked via PRORATE_CONVENTION_CODE for proration rules.
  • FA_CEILING_TYPES: Linked via CEILING_NAME for depreciation ceiling rules.
  • FA_ITC_RATES: Linked via ITC_AMOUNT_ID for investment tax credit rates.
  • FND_CONCURRENT_REQUESTS: Linked via TAX_REQUEST_ID to track the concurrent process.