Search Results fa_ace_books




Overview
Explore in AI Chat

Overview

The FA_ACE_BOOKS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It serves as a specialized repository for financial information specifically used to update an ACE (Adjusted Current Earnings) book. In Oracle Fixed Assets, an ACE book is a corporate tax book used in the United States to calculate depreciation for Alternative Minimum Tax (AMT) and Earnings & Profits (E&P) purposes, distinct from the corporate or tax books used for standard financial reporting. This table's primary role is to store the calculated depreciation and financial data required for ACE book compliance, ensuring the system maintains a parallel and accurate record of asset costs and depreciation according to specific tax regulations.

Key Information Stored

The table stores financial and depreciation attributes for assets assigned to an ACE book. Based on the provided metadata, key columns are defined by its primary and foreign key relationships. The primary key is ASSET_ID, uniquely identifying the asset within this context. Critical foreign keys link to other fundamental Fixed Assets tables, indicating the columns and data stored include the DEPRN_METHOD_CODE (the depreciation method, e.g., Straight Line), LIFE_IN_MONTHS (the asset's useful life for ACE calculations), and PRORATE_CONVENTION_CODE (the prorate convention rule for depreciation calculations). While the full column list is not detailed in the excerpt, the structure confirms the table holds the necessary financial rules and cumulative amounts—such as cost, accumulated depreciation, and year-to-date depreciation—specific to the ACE book's reporting requirements.

Common Use Cases and Queries

This table is central to processes involving ACE book depreciation and reporting. Common use cases include generating the ACE tax depreciation report, reconciling corporate book values with ACE book values for tax filings, and performing mass updates or inquiries on ACE-specific asset information. A typical query might join FA_ACE_BOOKS to the main asset master table to compare depreciation methods between books. For example:

  • SELECT a.asset_number, ace.deprn_method_code AS ace_method, corp.deprn_method_code AS corp_method FROM fa_additions_b a, fa_ace_books ace, fa_books corp WHERE a.asset_id = ace.asset_id AND a.asset_id = corp.asset_id AND corp.book_type_code = 'CORP';

Data in this table is primarily populated and maintained by the Fixed Assets depreciation program and related transaction processes when an asset is associated with an ACE book type.

Related Objects

As defined by its foreign key constraints, FA_ACE_BOOKS has direct, integral relationships with several core Fixed Assets tables. The ASSET_ID column references FA_ADDITIONS_B, the master table for asset additions. The DEPRN_METHOD_CODE and LIFE_IN_MONTHS columns reference FA_METHODS, which stores valid depreciation methods. The PRORATE_CONVENTION_CODE references FA_CONVENTION_TYPES. Furthermore, this table is intrinsically linked to the FA_BOOKS table, which holds book control information, and is accessed by standard Oracle Fixed Assets APIs and tax reporting programs like the Depreciation and Tax Reporting processes.

  • Table: FA_ACE_BOOKS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ACE_BOOKS,  object_name:FA_ACE_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information for updating ACE book ,  implementation_dba_data: FA.FA_ACE_BOOKS , 

  • Table: FA_ACE_BOOKS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ACE_BOOKS,  object_name:FA_ACE_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information for updating ACE book ,  implementation_dba_data: FA.FA_ACE_BOOKS , 

  • Table: FA_CONVENTION_TYPES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CONVENTION_TYPES,  object_name:FA_CONVENTION_TYPES,  status:VALID,  product: OFA - Assets ,  description: Names and descriptions for prorate conventions ,  implementation_dba_data: FA.FA_CONVENTION_TYPES , 

  • Table: FA_METHODS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_METHODS,  object_name:FA_METHODS,  status:VALID,  product: OFA - Assets ,  description: Depreciation method information ,  implementation_dba_data: FA.FA_METHODS , 

  • Table: FA_CONVENTION_TYPES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CONVENTION_TYPES,  object_name:FA_CONVENTION_TYPES,  status:VALID,  product: OFA - Assets ,  description: Names and descriptions for prorate conventions ,  implementation_dba_data: FA.FA_CONVENTION_TYPES , 

  • Table: FA_METHODS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_METHODS,  object_name:FA_METHODS,  status:VALID,  product: OFA - Assets ,  description: Depreciation method information ,  implementation_dba_data: FA.FA_METHODS , 

  • Table: FA_ADDITIONS_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • Table: FA_ADDITIONS_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B ,