Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - OFA Tables and Views

TABLE - FA.FA_ACE_BOOKS

TABLE - FA.FA_ADDITIONS_B

TABLE - FA.FA_ADDITIONS_TL

TABLE - FA.FA_ADDITION_REP_ITF

TABLE - FA.FA_ADD_WARRANTIES

TABLE - FA.FA_ADJUSTMENTS

TABLE - FA.FA_ADJUSTMENTS_T

TABLE - FA.FA_ADJUST_REP_ITF

TABLE - FA.FA_AMORT_SCHEDULES

TABLE - FA.FA_ARCHIVE_HISTORY

TABLE - FA.FA_ASSET_HIERARCHY

TABLE - FA.FA_ASSET_HIERARCHY_PURPOSE

TABLE - FA.FA_ASSET_HIERARCHY_VALUES

TABLE - FA.FA_ASSET_HISTORY

TABLE - FA.FA_ASSET_INVOICES

TABLE - FA.FA_ASSET_KEYWORDS

TABLE - FA.FA_ASSET_LISTING_REP_ITF

TABLE - FA.FA_BALANCES_REPORT

TABLE - FA.FA_BALANCES_REPORTS

TABLE - FA.FA_BALANCES_REP_ITF

TABLE - FA.FA_BONUS_RATES

TABLE - FA.FA_BONUS_RULES

TABLE - FA.FA_BOOKS

TABLE - FA.FA_BOOKS_GROUPS

TABLE - FA.FA_BOOKS_SUMMARY

TABLE - FA.FA_BOOKS_SUMMARY_T

TABLE - FA.FA_BOOK_CONTROLS

TABLE - FA.FA_BOOK_CONTROLS_HISTORY

TABLE - FA.FA_BUDGET_DISTRIBUTION

TABLE - FA.FA_BUDGET_INTERFACE

TABLE - FA.FA_CALENDAR_PERIODS

TABLE - FA.FA_CALENDAR_TYPES

TABLE - FA.FA_CAPITAL_BUDGET

TABLE - FA.FA_CAP_REP_ITF

TABLE - FA.FA_CASH_GEN_UNITS

TABLE - FA.FA_CATEGORIES_B

TABLE - FA.FA_CATEGORIES_TL

TABLE - FA.FA_CATEGORY_ACCOUNTS_GT

TABLE - FA.FA_CATEGORY_BOOKS

TABLE - FA.FA_CATEGORY_BOOK_DEFAULTS

TABLE - FA.FA_CEILINGS

TABLE - FA.FA_CEILING_TYPES

TABLE - FA.FA_CONVENTIONS

TABLE - FA.FA_CONVENTION_TYPES

TABLE - FA.FA_COSTCLEAR_REP_ITF

TABLE - FA.FA_DEFERRED_DEPRN

TABLE - FA.FA_DEFERRED_DEPRN_EVENTS

TABLE - FA.FA_DELETED_MASS_ADDITIONS

TABLE - FA.FA_DEPRN_BASIS_RULES

TABLE - FA.FA_DEPRN_DETAIL

TABLE - FA.FA_DEPRN_DETAIL_H

TABLE - FA.FA_DEPRN_EVENTS

TABLE - FA.FA_DEPRN_OVERRIDE

TABLE - FA.FA_DEPRN_PERIODS

TABLE - FA.FA_DEPRN_REP_ITF

TABLE - FA.FA_DEPRN_RULE_DETAILS

TABLE - FA.FA_DEPRN_SUMMARY

TABLE - FA.FA_DEPRN_SUMMARY_H

TABLE - FA.FA_DEPRN_TAX_AUTHORITIES

TABLE - FA.FA_DEPRN_TAX_ENTITIES

TABLE - FA.FA_DEPRN_TAX_REP_ITF

TABLE - FA.FA_DEPRN_TAX_REP_NBVS

TABLE - FA.FA_DISTRIBUTION_ACCOUNTS

TABLE - FA.FA_DISTRIBUTION_DEFAULTS

TABLE - FA.FA_DISTRIBUTION_HISTORY

TABLE - FA.FA_DISTRIBUTION_SETS

TABLE - FA.FA_EXCLUDE_HIERARCHY_LEVELS

TABLE - FA.FA_EXT_INV_RETIREMENTS

TABLE - FA.FA_FISCAL_YEAR

TABLE - FA.FA_FLAT_RATES

TABLE - FA.FA_FORMULAS

TABLE - FA.FA_GROUP_ASSETS

TABLE - FA.FA_GROUP_ASSET_DEFAULT

TABLE - FA.FA_GROUP_ASSET_RULES

TABLE - FA.FA_GROUP_DEPRN_DETAIL

TABLE - FA.FA_GROUP_DEPRN_RATES

TABLE - FA.FA_GROUP_DEPRN_SUMMARY

TABLE - FA.FA_GROUP_REP_ITF

TABLE - FA.FA_HIERARCHY_CONTROLS

TABLE - FA.FA_HIERARCHY_DISTRIBUTIONS

TABLE - FA.FA_HIERARCHY_RULE_DETAILS

TABLE - FA.FA_HIERARCHY_RULE_SET

TABLE - FA.FA_HR_RETIREMENT_DETAILS

TABLE - FA.FA_HR_RETIREMENT_HEADERS

TABLE - FA.FA_IMPAIRMENTS

TABLE - FA.FA_INS_LINES

TABLE - FA.FA_INS_MST_POLS

TABLE - FA.FA_INS_POLICIES

TABLE - FA.FA_INS_VALUES

TABLE - FA.FA_INVENTORY

TABLE - FA.FA_INVMISS_REP_ITF

TABLE - FA.FA_INVOICE_TRANSACTIONS

TABLE - FA.FA_INV_COMPARE_REP_ITF

TABLE - FA.FA_INV_INTERFACE

TABLE - FA.FA_ITC_RATES

TABLE - FA.FA_ITC_RECAPTURE_RATES

TABLE - FA.FA_ITF_IMPAIRMENTS

TABLE - FA.FA_JOURNAL_ENTRIES

TABLE - FA.FA_LEASES

TABLE - FA.FA_LEASE_PAYMENTS

TABLE - FA.FA_LEASE_PAYMENT_ITEMS

TABLE - FA.FA_LEASE_SCHEDULES

TABLE - FA.FA_LIFE_DERIVATION_INFO

TABLE - FA.FA_LOCATIONS

TABLE - FA.FA_LOOKUPS_B

TABLE - FA.FA_LOOKUPS_TL

TABLE - FA.FA_LOOKUP_TYPES_B

TABLE - FA.FA_LOOKUP_TYPES_TL

TABLE - FA.FA_MAINT_EVENTS

TABLE - FA.FA_MAINT_REP_ITF

TABLE - FA.FA_MAINT_SCHEDULE_DTL

TABLE - FA.FA_MAINT_SCHEDULE_HDR

TABLE - FA.FA_MASSADD_DISTRIBUTIONS

TABLE - FA.FA_MASSADD_REP_ITF

TABLE - FA.FA_MASS_ADDITIONS

TABLE - FA.FA_MASS_ADDITIONS_GT

TABLE - FA.FA_MASS_CHANGES

TABLE - FA.FA_MASS_CHANGES_ITF

TABLE - FA.FA_MASS_EXTERNAL_TRANSFERS

TABLE - FA.FA_MASS_EXT_RETIREMENTS

TABLE - FA.FA_MASS_EXT_RET_EXCEPTS

TABLE - FA.FA_MASS_RECLASS

TABLE - FA.FA_MASS_RECLASS_ITF

TABLE - FA.FA_MASS_RETIREMENTS

TABLE - FA.FA_MASS_RET_EXCEPTS

TABLE - FA.FA_MASS_REVALUATIONS

TABLE - FA.FA_MASS_REVALUATION_RULES

TABLE - FA.FA_MASS_REVAL_REP_ITF

TABLE - FA.FA_MASS_TAX_ADJUSTMENTS

TABLE - FA.FA_MASS_TAX_ADJ_REP_T

TABLE - FA.FA_MASS_TRANSFERS

TABLE - FA.FA_MASS_UPDATE_BATCH_DETAILS

TABLE - FA.FA_MASS_UPDATE_BATCH_HEADERS

TABLE - FA.FA_MC_ADJUSTMENTS

TABLE - FA.FA_MC_ASSET_INVOICES

TABLE - FA.FA_MC_BOOKS

TABLE - FA.FA_MC_BOOKS_GROUPS

TABLE - FA.FA_MC_BOOKS_RATES

TABLE - FA.FA_MC_BOOKS_SUMMARY

TABLE - FA.FA_MC_BOOK_CONTROLS

TABLE - FA.FA_MC_CONVERSION_HISTORY

TABLE - FA.FA_MC_CONVERSION_RATES

TABLE - FA.FA_MC_DEFERRED_DEPRN

TABLE - FA.FA_MC_DEPRN_DETAIL

TABLE - FA.FA_MC_DEPRN_DETAIL_H

TABLE - FA.FA_MC_DEPRN_PERIODS

TABLE - FA.FA_MC_DEPRN_SUMMARY

TABLE - FA.FA_MC_DEPRN_SUMMARY_H

TABLE - FA.FA_MC_GROUP_DEPRN_DETAIL

TABLE - FA.FA_MC_GROUP_DEPRN_SUMMARY

TABLE - FA.FA_MC_IMPAIRMENTS

TABLE - FA.FA_MC_ITF_IMPAIRMENTS

TABLE - FA.FA_MC_MASS_RATES

TABLE - FA.FA_MC_RETIREMENTS

TABLE - FA.FA_METHODS

TABLE - FA.FA_PARALLEL_WORKERS

TABLE - FA.FA_PERIODIC_PRODUCTION

TABLE - FA.FA_PERIOD_MAPS

TABLE - FA.FA_PLSQL_DEBUG

TABLE - FA.FA_PRICE_INDEXES

TABLE - FA.FA_PRICE_INDEX_VALUES

TABLE - FA.FA_PRODUCTION_INTERFACE

TABLE - FA.FA_PROJECT_REP_ITF

TABLE - FA.FA_PROPTAX_REP_ITF

TABLE - FA.FA_RATES

TABLE - FA.FA_RECLASS_REP_ITF

TABLE - FA.FA_RESERVE_LEDGER

TABLE - FA.FA_RESERVE_LEDGER_GT

TABLE - FA.FA_RETIREMENTS

TABLE - FA.FA_RETIRE_REP_ITF

TABLE - FA.FA_REVAL_LINK_IMP_ASSET

TABLE - FA.FA_REVAL_LINK_IMP_CAT

TABLE - FA.FA_RX_ATTRSETS_B

TABLE - FA.FA_RX_ATTRSETS_TL

TABLE - FA.FA_RX_DYNAMIC_COLUMNS

TABLE - FA.FA_RX_LOV

TABLE - FA.FA_RX_MULTIFORMAT_REPS

TABLE - FA.FA_RX_REPORTS

TABLE - FA.FA_RX_REP_COLUMNS_B

TABLE - FA.FA_RX_REP_COLUMNS_TL

TABLE - FA.FA_RX_REP_PARAMETERS

TABLE - FA.FA_RX_SECURITY

TABLE - FA.FA_RX_SUMMARY_TL

TABLE - FA.FA_SHORT_TAX_RESERVES

TABLE - FA.FA_SORP_LINK_REVAL_ITF

TABLE - FA.FA_SUPER_GROUPS

TABLE - FA.FA_SUPER_GROUP_RULES

TABLE - FA.FA_SYSTEM_CONTROLS

TABLE - FA.FA_TAX_INTERFACE

TABLE - FA.FA_TAX_REPORT

TABLE - FA.FA_TRACK_MEMBERS

TABLE - FA.FA_TRANSACTION_HEADERS

TABLE - FA.FA_TRANSACTION_INTERFACE

TABLE - FA.FA_TRANSFER_DETAILS

TABLE - FA.FA_TRANSFER_REP_ITF

TABLE - FA.FA_TRX_REFERENCES

TABLE - FA.FA_WARRANTIES

TABLE - FA.FA_WHATIF_ITF

TABLE - FA.FA_WORKER_JOBS

TABLE - FA.FA_XLA_EXT_HEADERS_B_GT

TABLE - FA.FA_XLA_EXT_LINES_B_GT

TABLE - FA.FA_XLA_EXT_LINES_STG_GT

TABLE - FA.FA_XLA_EXT_LINES_TL_GT

VIEW - APPS.FABV_ACCT_PRDS

VIEW - APPS.FABV_ASSETS

VIEW - APPS.FABV_ASSET_ASSIGNS

VIEW - APPS.FABV_ASSET_BKS

VIEW - APPS.FABV_ASSET_CATS

VIEW - APPS.FABV_ASSET_LEASES

VIEW - APPS.FABV_ASSET_LOCS

VIEW - APPS.FABV_BOOKS

VIEW - APPS.FABV_DEPRECIATIONS

VIEW - APPS.FABV_SRC_LNS

VIEW - APPS.FABV_TRANS_HDRS

VIEW - APPS.FABV_TRANS_LINES

VIEW - APPS.FAFV_ACCT_PRDS

VIEW - APPS.FAFV_ASSETS

VIEW - APPS.FAFV_ASSET_ASSIGNS

VIEW - APPS.FAFV_ASSET_BKS

VIEW - APPS.FAFV_ASSET_CATS

VIEW - APPS.FAFV_ASSET_LEASES

VIEW - APPS.FAFV_ASSET_LOCS

VIEW - APPS.FAFV_BOOKS

VIEW - APPS.FAFV_DEPRECIATIONS

VIEW - APPS.FAFV_SRC_LNS

VIEW - APPS.FAFV_TRANS_HDRS

VIEW - APPS.FAFV_TRANS_LINES

VIEW - APPS.FA_ADDITIONS_ASSET_V

VIEW - APPS.FA_ADDITIONS_NON_SEC_VL

VIEW - APPS.FA_ADDITIONS_V

VIEW - APPS.FA_ADDITIONS_VL

VIEW - APPS.FA_ADDITIONS_WEB_V

VIEW - APPS.FA_ADD_INVOICE_WEB_V

VIEW - APPS.FA_ADJUSTMENTS_MRC_V

VIEW - APPS.FA_AEL_GL_V

VIEW - APPS.FA_AEL_SL_MRC_V

VIEW - APPS.FA_AEL_SL_V

VIEW - APPS.FA_ALTERNATE_LEDGERS_V

VIEW - APPS.FA_ASSET_DISTRIBUTION_V

VIEW - APPS.FA_ASSET_HIERARCHY_PURPOSE_V

VIEW - APPS.FA_ASSET_HIERARCHY_V

VIEW - APPS.FA_ASSET_HIERARCHY_VALUES_V

VIEW - APPS.FA_ASSET_HISTORY_V

VIEW - APPS.FA_ASSET_HIST_WEB_V

VIEW - APPS.FA_ASSET_HRCHY_DETAILS_V

VIEW - APPS.FA_ASSET_INVOICES_MRC_V

VIEW - APPS.FA_ASSET_INVOICES_V

VIEW - APPS.FA_ASSET_MAINT_VIEW

VIEW - APPS.FA_ASSET_V

VIEW - APPS.FA_BOOKS_BK_CNTRL_WEB_V

VIEW - APPS.FA_BOOKS_BOOK_CONTROLS_V

VIEW - APPS.FA_BOOKS_GROUPS_MRC_V

VIEW - APPS.FA_BOOKS_GROUPS_V

VIEW - APPS.FA_BOOKS_GROUPS_V1

VIEW - APPS.FA_BOOKS_MRC_V

VIEW - APPS.FA_BOOKS_SUMMARY_MRC_V

VIEW - APPS.FA_BOOKS_V

VIEW - APPS.FA_BOOK_CONTROLS_MRC_V

VIEW - APPS.FA_CAPITALIZE_CIP_V

VIEW - APPS.FA_CATEGORIES_VL

VIEW - APPS.FA_CHILD_ASSETS_V

VIEW - APPS.FA_CURR_DEPRN_ADJ_V

VIEW - APPS.FA_DEFERRED_DEPRN_EVENTS_V

VIEW - APPS.FA_DEFERRED_DEPRN_MRC_V

VIEW - APPS.FA_DEPRN_DETAIL_H_MRC_V

VIEW - APPS.FA_DEPRN_DETAIL_MRC_V

VIEW - APPS.FA_DEPRN_EVENTS_V

VIEW - APPS.FA_DEPRN_GROUPS_V

VIEW - APPS.FA_DEPRN_GROUPS_V1

VIEW - APPS.FA_DEPRN_OVERRIDE_V

VIEW - APPS.FA_DEPRN_PERIODS_MRC_V

VIEW - APPS.FA_DEPRN_SUMMARY_H_MRC_V

VIEW - APPS.FA_DEPRN_SUMMARY_MRC_V

VIEW - APPS.FA_DEPRN_WEB_V

VIEW - APPS.FA_DISTRIBUTION_HISTORY_V

VIEW - APPS.FA_DISTRIBUTION_HIST_WEB_V

VIEW - APPS.FA_DISTRIBUTION_INQUIRY_V

VIEW - APPS.FA_DISTRIBUTION_INQ_WEB_V

VIEW - APPS.FA_EMPLOYEES

VIEW - APPS.FA_EMP_ASSET_WEB_V

VIEW - APPS.FA_EXTENDED_DEPRN_V

VIEW - APPS.FA_FINANCIAL_INQUIRY_COST_V

VIEW - APPS.FA_FINANCIAL_INQUIRY_DEPRN_H_V

VIEW - APPS.FA_FINANCIAL_INQUIRY_DEPRN_V

VIEW - APPS.FA_FINANCIAL_INQUIRY_UPL_V

VIEW - APPS.FA_FIN_INQRY_COST_WEB_V

VIEW - APPS.FA_FIN_INQRY_DEPRN_WEB_V

VIEW - APPS.FA_FIN_INQRY_UPL_WEB_V

VIEW - APPS.FA_FUTURE_MASS_ADDITIONS_V

VIEW - APPS.FA_GROUP_COST_INQUIRY_V

VIEW - APPS.FA_GROUP_DEPRN_DETAIL_MRC_V

VIEW - APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V

VIEW - APPS.FA_HIERARCHY_BATCH_DETAILS_V

VIEW - APPS.FA_HIERARCHY_BATCH_HEADER_V

VIEW - APPS.FA_HIERARCHY_DISTRIBUTIONS_V

VIEW - APPS.FA_HIERARCHY_RULE_DETAILS_V

VIEW - APPS.FA_HR_BATCH_DIST_NEW_V

VIEW - APPS.FA_HR_BATCH_DIST_OLD_V

VIEW - APPS.FA_HR_RETIREMENT_DETAILS_V

VIEW - APPS.FA_HR_RETIREMENT_HEADERS_V

VIEW - APPS.FA_IMPAIRMENTS_MRC_V

VIEW - APPS.FA_INS_ADDITIONS_V

VIEW - APPS.FA_INS_LINES_V

VIEW - APPS.FA_INS_MST_POLS_V

VIEW - APPS.FA_INS_POLICIES_V

VIEW - APPS.FA_INVENTORY_V

VIEW - APPS.FA_INVOICE_DETAILS_V

VIEW - APPS.FA_INVOICE_DETAILS_WEB_V

VIEW - APPS.FA_INVOICE_TRANSFERS_V

VIEW - APPS.FA_INV_INTERFACE_V

VIEW - APPS.FA_ITF_IMPAIRMENTS_MRC_V

VIEW - APPS.FA_LEASES_V

VIEW - APPS.FA_LEASES_WEB_V

VIEW - APPS.FA_LEASE_PAYMENT_ITEMS_V

VIEW - APPS.FA_LOOKUPS_VL

VIEW - APPS.FA_LOOKUP_TYPES_VL

VIEW - APPS.FA_MASS_ADDITIONS_V

VIEW - APPS.FA_MASS_EXTERNAL_TRANSFERS_V

VIEW - APPS.FA_MASS_EXT_RETIREMENTS_V

VIEW - APPS.FA_MUPD_V

VIEW - APPS.FA_PRRUN_PERIODS_V

VIEW - APPS.FA_QUICK_ADDITIONS_V

VIEW - APPS.FA_QUICK_BOOKS_V

VIEW - APPS.FA_QUICK_DISTRIBUTIONS_V

VIEW - APPS.FA_RESERVE_TRANSFERS_V

VIEW - APPS.FA_RETIRED_ASSET_WEB_V

VIEW - APPS.FA_RETIREMENTS_MRC_V

VIEW - APPS.FA_RETIREMENTS_V

VIEW - APPS.FA_RETIREMENTS_WEB_V

VIEW - APPS.FA_RETIREMENT_ADJUSTMENTS_V

VIEW - APPS.FA_RETIREMENT_REQUESTS_V

VIEW - APPS.FA_RX_ATTRSETS_VL

VIEW - APPS.FA_RX_CR_REPORTS_V

VIEW - APPS.FA_RX_NOCR_REPORTS_V

VIEW - APPS.FA_RX_REPORTS_V

VIEW - APPS.FA_RX_REP_COLUMNS_VL

VIEW - APPS.FA_RX_REP_PARAMETERS_V

VIEW - APPS.FA_RX_SUMMARY_VL

VIEW - APPS.FA_SORP_ASSET_LINK_REVAL_V

VIEW - APPS.FA_SORP_CAT_LINK_REVAL_V

VIEW - APPS.FA_SOURCE_LINES_V

VIEW - APPS.FA_SXL_BOOKS_V

VIEW - APPS.FA_TRANSACTIONS_V

VIEW - APPS.FA_TRANSACTION_HEADERS_V

VIEW - APPS.FA_TRANSACTION_HISTORY_BOOKS_V

VIEW - APPS.FA_TRANSACTION_HISTORY_TRX_V

VIEW - APPS.FA_TRANSFER_INVOICES_V

VIEW - APPS.FA_TRANS_HIST_BOOKS_WEB_V

VIEW - APPS.FA_TRANS_HIST_TRX_WEB_V

VIEW - APPS.FA_UNPLANNED_DEPR_V

Table: FA_ACE_BOOKS

Primary Key: FA_ACE_BOOKS_PK

1. ASSET_ID

Foreign Keys from this table:

Comments

FA_ACE_BOOKS is temporary table Oracle Assets uses to store
financial information for your Adjusted Current Earnings ("ACE")
depreciation book.
.
When you run FAACCR, the ACE program populates this table.
Oracle Assets deletes any data in this table before running the
program. Oracle Assets then inserts into this table the financial
information of assets you placed in service before 1981, MACRS
assets placed in service before 1990, and ACRS assets. The program
ignores assets that do not fit into one of these groups.
.
Oracle Assets uses the information in the table to update these
assets in your ACE tax book when you run FAACUP.
.
MLC_UPDATE_FLAG is set to 'YES' by the FAACCR program if Oracle
Assets must update the depreciation method(M), life(L), and prorate
convention(C) of an asset in the ACE tax book to the values for the
asset in the federal tax book. In this case Oracle Assets also
provides the method, life, and convention.
.
For more information on the RATE_ADJUSTMENT_FACTOR , please
refer to the FA_BOOKS table description in this manual.
.
For more information on loading this table, read the Integrating
Oracle Assets Using the ACE Interface essay in the Oracle Financials
and Oracle Government Financials Implementation Manual.
Scope: public
Lifecycle: active
Display Name: FA ACE Books
Product: FA
Category: BUSINESS_ENTITY FA_ASSET

Columns

[top of page]

FA.FA_ACE_BOOKS does not reference any database object

FA.FA_ACE_BOOKS is referenced by following:

FA

VIEW - FA_ACE_BOOKS#

[top of page]

Table: FA_ADDITIONS_B

Primary Key: FA_ADDITIONS_B_PK

1. ASSET_ID

Primary Key: FA_ADDITIONS_B_UK1

1. ASSET_NUMBER

Foreign Keys from this table:

Foreign Keys to this table:

Comments

FA_ADDITIONS_B contains descriptive information to help you identify
your assets. Oracle Assets does not use this table to calculate
depreciation.
.
When you add an asset, Oracle Assets inserts a row into this table
and into FA_ASSET_HISTORY.
.
When you change the asset information stored in this table, Oracle
Assets updates it in this table. It also creates a new row in
FA_ASSET_HISTORY.
.
When you perform a unit retirement, Oracle Assets reduces the
CURRENT_UNITS by the units retired.
.
UNIT_ADJUSTMENT_FLAG is set to YES by the Additions form if you
change the number of units for an asset. The Transfers form resets
it to NO after you reassign the remaining units.
.
Oracle Assets does not support ASSET_IDs that exceed 2,000,000,000.
.
.

Indexes

Columns

[top of page]

FA.FA_ADDITIONS_B does not reference any database object

FA.FA_ADDITIONS_B is referenced by following:

FA

VIEW - FA_ADDITIONS_B#

[top of page]

Table: FA_ADDITIONS_TL

Primary Key: FA_ADDITIONS_TL_PK

1. ASSET_ID
2. LANGUAGE

Comments

FA_ADDITIONS_TL contains translated description columns from the FA_ADDITIONS_B base
table to conform to multilingual standards.

Indexes

Columns

[top of page]

FA.FA_ADDITIONS_TL does not reference any database object

FA.FA_ADDITIONS_TL is referenced by following:

FA

VIEW - FA_ADDITIONS_TL#

[top of page]

Table: FA_ADDITION_REP_ITF

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

FA.FA_ADDITION_REP_ITF does not reference any database object

FA.FA_ADDITION_REP_ITF is referenced by following:

FA

VIEW - FA_ADDITION_REP_ITF#

[top of page]

Table: FA_ADD_WARRANTIES

Primary Key: FA_ADD_WARRANTIES_PK

1. WARRANTY_ID
2. ASSET_ID
3. DATE_EFFECTIVE

Foreign Keys from this table:

Comments

FA_ADD_WARRANTIES contains information about the warranty that is
attached to an asset. Oracle Assets inserts one row in this table for
each asset that you assign to a warranty in the Asset Details window.

Indexes

Columns

[top of page]

FA.FA_ADD_WARRANTIES does not reference any database object

FA.FA_ADD_WARRANTIES is referenced by following:

FA

VIEW - FA_ADD_WARRANTIES#

[top of page]

Table: FA_ADJUSTMENTS

Foreign Keys from this table:

Comments

FA_ADJUSTMENTS stores information that Oracle Assets needs to
create journal entries for transactions. The posting program
creates journal entries for regular depreciation expense from
information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in
this table for the debit and credit sides of a financial
transaction. All the rows for the same transaction have the same
value in the TRANSACTION_HEADER_ID column.
.
The SOURCE_TYPE_CODE column tells you which program created the
adjustment:
.
{{FB}}ADDITION{{F0}}
{{TAB}}Depreciation program
.
{{FB}}ADJUSTMENT{{F0}}
{{TAB}}Expensed or Amortized Adjustment User Exit
.
{{FB}}CIP ADDITION{{F0}}
{{TAB}}Depreciation program
.
{{FB}}CIP ADJUSTMENT{{F0}}
{{TAB}}Expensed or Amortized Adjustment User Exit
.
{{FB}}CIP RETIREMENT{{F0}}
{{TAB}}Gain/loss program
.
{{FB}}DEPRECIATION{{F0}}
{{TAB}}Depreciation program (Retroactive transactions and
expensed depreciation adjustments)
.
{{FB}}RETIREMENT{{F0}}
{{TAB}}Gain/loss program
.
{{FB}}RECLASS{{F0}}
{{TAB}}Reclassification user exit
.
{{FB}}TRANSFER{{F0}}
{{TAB}}Transfers form
.
{{FB}}TAX{{F0}}
{{TAB}}Reserve Adjustments form
.
{{FB}}REVALUATION{{F0}}
{{TAB}}Mass revaluation program
.
.
.
The ADJUSTMENT_TYPE column tells you which type of account Oracle
Assets adjusts.
.
DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the
amount is a credit.
.
ADJUSTMENT_AMOUNT is the amount debited or credited to the account.
.
ANNUALIZED_ADJUSTMENT is the adjustment amount for a period
times the number of periods in a fiscal year. The depreciation
program uses it to calculate the depreciation adjustment for an asset
when you perform multiple retroactive transactions on the asset.
Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the
ADJUSTMENT_AMOUNT for a retroactive transaction by the number of
periods between the period you entered the transaction and the period
that it was effective. For current period transactions, this
column is zero.
.
PERIOD_COUNTER_CREATED IS the period that you entered the adjustment
into Oracle Assets.
.
PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies.
It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve
adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period
of the fiscal year to which the adjustment applies.
.
CODE_COMBINATION_ID indicates the Accounting Flexfield combination
Oracle Assets debits or credits for all transactions except
reclassifications and intercompany transfers. This
CODE_COMBINATION_ID is generated using the Account Generator, and the
posting
program does not perform any further processing.
.
.

Indexes

Columns

[top of page]

FA.FA_ADJUSTMENTS does not reference any database object

FA.FA_ADJUSTMENTS is referenced by following:

FA

VIEW - FA_ADJUSTMENTS#

[top of page]

Table: FA_ADJUSTMENTS_T

Comments

FA_ADJUSTMENTS_T is a temporary table used during processing of impairment transactions and Extended Depreciation. When user searches in Extended Depreciation form the records are inserted into this table, and these are later used by the Extended Adjustments Program to call the adjustment API.

Indexes

Columns

[top of page]

FA.FA_ADJUSTMENTS_T does not reference any database object

FA.FA_ADJUSTMENTS_T is referenced by following:

FA

VIEW - FA_ADJUSTMENTS_T#

[top of page]

Table: FA_ADJUST_REP_ITF

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

FA.FA_ADJUST_REP_ITF does not reference any database object

FA.FA_ADJUST_REP_ITF is referenced by following:

FA

VIEW - FA_ADJUST_REP_ITF#

[top of page]

Table: FA_AMORT_SCHEDULES

Primary Key: FA_AMORT_SCHEDULES_PK

1. PAYMENT_SCHEDULE_ID
2. AMORTIZATION_LINE_NUM

Comments

FA_AMORT_SCHEDULES stores the amortization schedule information for
capitalized leases.

Indexes

Columns

[top of page]

FA.FA_AMORT_SCHEDULES does not reference any database object

FA.FA_AMORT_SCHEDULES is referenced by following:

FA

VIEW - FA_AMORT_SCHEDULES#

[top of page]

Table: FA_ARCHIVE_HISTORY

Primary Key: FA_ARCHIVE_HISTORY_PK

1. ARCHIVE_ID

Foreign Keys from this table:

Comments

FA_ARCHIVE_HISTORY contains information about your archive,
purge, and restore requests. Oracle Assets uses this
information to run a concurrent process that archives,
purges, or restores depreciation and adjustment transaction
information for a book for a fiscal year.
.
When you define an archive request using the Mass Purge
form, Oracle Assets inserts a row that stores which book to
archive for which year into this table. It uses this
information to archive, purge, and restore information from
the FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL, and FA_ADJUSTMENTS
tables.
.
ARCHIVE_ID identifies each archive and purge definition.
.
.

Indexes

Columns

[top of page]

FA.FA_ARCHIVE_HISTORY does not reference any database object

FA.FA_ARCHIVE_HISTORY is referenced by following:

FA

VIEW - FA_ARCHIVE_HISTORY#

[top of page]

Table: FA_ASSET_HIERARCHY

Comments

Contains Asset Hierarchy information and the parent child relationship between the nodes.

Indexes

Columns

[top of page]

FA.FA_ASSET_HIERARCHY does not reference any database object

FA.FA_ASSET_HIERARCHY is referenced by following:

FA

VIEW - FA_ASSET_HIERARCHY#

[top of page]

Table: FA_ASSET_HIERARCHY_PURPOSE

Comments

Contains Purpose information. This contains rules regarding how the Inheritance Rule Set will be used and whether the relationship between an asset and a node is mandatory or not.

Indexes

Columns

[top of page]

FA.FA_ASSET_HIERARCHY_PURPOSE does not reference any database object

FA.FA_ASSET_HIERARCHY_PURPOSE is referenced by following:

FA

VIEW - FA_ASSET_HIERARCHY_PURPOSE#

[top of page]

Table: FA_ASSET_HIERARCHY_VALUES

Comments

Stores attribute values associated with a hierarchy node that may be inherited by other nodes.

Indexes

Columns

[top of page]

FA.FA_ASSET_HIERARCHY_VALUES does not reference any database object

FA.FA_ASSET_HIERARCHY_VALUES is referenced by following:

FA

VIEW - FA_ASSET_HIERARCHY_VALUES#

[top of page]

Table: FA_ASSET_HISTORY

Primary Key: FA_ASSET_HISTORY_PK

1. ASSET_ID
2. DATE_EFFECTIVE

Foreign Keys from this table:

Comments

FA_ASSET_HISTORY contains information about asset
reclassifications, capitalizations, unit adjustments, and
partial unit retirements.
.
When you initially add an asset, Oracle Assets inserts one row into
the table. This becomes the "active" row for the asset. When you
use the Additions form to reclassify an asset or perform a unit
adjustment, Oracle Assets marks this row as obsolete and inserts
a new row. If you either reclassify an asset or change its asset
type in the period in which you added the asset, Oracle Assets
simply updates the row, since the transaction has no financial
impact. At any point in time, there is only one "active" row in
the table for an asset, and you can always identify it because it
is the only one whose DATE_INEFFECTIVE is NULL.
.
.
Oracle Assets terminates a row by setting the DATE_INEFFECTIVE and
TRANSACTION_HEADER_ID_OUT to the DATE_EFFECTIVE and
TRANSACTION_HEADER_ID_IN of the new row. This means you can
identify rows affected by the same transaction because they have
the same DATE_EFFECTIVE / DATE_INEFFECTIVE and
TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs. For
new rows, TRANSACTION_HEADER_ID_IN is the same as
TRANSACTION_HEADER_ID of the row inserted into
FA_TRANSACTION_HEADERS for the transaction, and DATE_EFFECTIVE is
the system date.
.
.

Indexes

Columns

[top of page]

FA.FA_ASSET_HISTORY does not reference any database object

FA.FA_ASSET_HISTORY is referenced by following:

FA

VIEW - FA_ASSET_HISTORY#

[top of page]

Table: FA_ASSET_INVOICES

Foreign Keys from this table:

Comments

FA_ASSET_INVOICES stores accounts payable and purchasing
information about your assets so you can track your assets to their
source. This table also stores all costs interfaced from projects
including labor and expenses.
.
Oracle Assets inserts a row into this table for each asset when you
use Mass Additions to automatically add your assets. For manual
additions, Oracle Assets inserts a row only if you complete the
purchasing zone of the Additions form. This becomes an "active"
row for the asset. You can have multiple "active" rows for each
asset.
.
Oracle Assets inserts an "active" row into this table when you use
the CIP Asset Adjustments form to add an invoice line to a CIP
asset. If you delete an invoice line using this form, Oracle
Assets marks the row as obsolete. If you change an invoice line
using the CIP Asset Adjustments form or the Transfer Invoices form,
Oracle Assets inserts another row into this table, which then
becomes an "active" row, and marks the previous row as obsolete.
.
When Oracle Assets terminates a row, the DATE_INEFFECTIVE and
INVOICE_TRANSACTION_ID_OUT are set to the DATE_EFFECTIVE and
INVOICE_TRANSACTION_ID_IN of the new row, respectively. This
means that you can easily identify rows affected by the same
transaction because they have the same DATE_EFFECTIVE /
DATE_INEFFECTIVE and INVOICE_TRANSACTION_ID_IN /
INVOICE_TRANSACTION_ID_OUT pairs. When Oracle Assets created the
new row, the value used for the INVOICE_TRANSACTION_ID_IN column
is the same as the INVOICE_TRANSACTION_ID in the row inserted in
FA_INVOICE_TRANSACTIONS, and the DATE_EFFECTIVE is the system date.
Oracle Assets also inserts a row in FA_TRANSACTION_HEADERS in which
the INVOICE_TRANSACTION_ID is the same as the
INVOICE_TRANSACTION_ID in FA_INVOICE_TRANSACTIONS.
.
FEEDER_SYSTEM_NAME identifies the system from which the mass
additions originated.
.
POST_BATCH_ID identifies the Mass Additions Post concurrent request
that posted your mass additions to Oracle Assets.
.
DELETED_FLAG is set to 'YES' when you delete an invoice using the
CIP Asset Adjustments form.
.
DATE_EFFECTIVE is the date on which you entered the transaction
into Oracle Assets.
.
SPLIT_MERGED_CODE tells you whether an invoice was split or merged:
.
{{FB}}MC{{F0}}
{{TAB}}Merged child - Oracle Assets merged this invoice
line into another mass addition.
.
{{FB}}MP{{F0}}
{{TAB}}Merged parent - Oracle Assets merged other invoice
lines into this mass addition.
.
{{FB}}SC{{F0}}
{{TAB}}Split child - Oracle Assets created this mass
addition from a multi-unit mass addition.
.
{{FB}}SP{{F0}}
{{TAB}}Split parent - Oracle Assets split this multi-unit
mass addition into individual mass additions.
.
.

Indexes

Columns

[top of page]

FA.FA_ASSET_INVOICES does not reference any database object

FA.FA_ASSET_INVOICES is referenced by following:

FA

VIEW - FA_ASSET_INVOICES#

[top of page]

Table: FA_ASSET_KEYWORDS

Primary Key: FA_ASSET_KEYWORDS_PK

1. CODE_COMBINATION_ID

Foreign Keys to this table:

Comments

FA_ASSET_KEYWORDS stores valid asset key flexfield segment value
combinations.
.
Segment values are stored in the SEGMENT columns. The SEGMENT
columns which are used are not guaranteed to be in any order.
.
The Application Object Library table FND_ID_FLEX_SEGMENTS stores
information about which column in this table is used for each
segment.
.

Indexes

Columns

[top of page]

FA.FA_ASSET_KEYWORDS does not reference any database object

FA.FA_ASSET_KEYWORDS is referenced by following:

FA

VIEW - FA_ASSET_KEYWORDS#

[top of page]

Table: FA_ASSET_LISTING_REP_ITF

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

FA.FA_ASSET_LISTING_REP_ITF does not reference any database object

FA.FA_ASSET_LISTING_REP_ITF is referenced by following:

FA

VIEW - FA_ASSET_LISTING_REP_ITF#

[top of page]

Table: FA_BALANCES_REPORT

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

FA.FA_BALANCES_REPORT does not reference any database object

FA.FA_BALANCES_REPORT is referenced by following:

FA

VIEW - FA_BALANCES_REPORT#

[top of page]

Table: FA_BALANCES_REPORTS

Comments

Indexes

Columns

[top of page]

FA.FA_BALANCES_REPORTS does not reference any database object

FA.FA_BALANCES_REPORTS is referenced by following:

FA

VIEW - FA_BALANCES_REPORTS#

[top of page]

Table: FA_BALANCES_REP_ITF

Foreign Keys from this table:

Comments

FA_BALANCES_REP_ITF is an interface table tracking balances for RX reports.

Indexes

Columns

[top of page]

FA.FA_BALANCES_REP_ITF does not reference any database object

FA.FA_BALANCES_REP_ITF is referenced by following:

FA

VIEW - FA_BALANCES_REP_ITF#

[top of page]

Table: FA_BONUS_RATES

Primary Key: FA_BONUS_RATES_PK

1. BONUS_RULE
2. START_YEAR

Foreign Keys from this table:

Comments

FA_BONUS_RATES stores the bonus rates used by the depreciation
program to calculate depreciation for your assets that use bonus
depreciation.
.
When you create a bonus rate using the Bonus Depreciation Rules
form, Oracle Assets inserts a row into this table for each bonus
rate you define. The master bonus rule row is in FA_BONUS_RULES
table.
.
.

Indexes

Columns

[top of page]

FA.FA_BONUS_RATES does not reference any database object

FA.FA_BONUS_RATES is referenced by following:

FA

VIEW - FA_BONUS_RATES#

[top of page]

Table: FA_BONUS_RULES

Primary Key: FA_BONUS_RULES_PK

1. BONUS_RULE

Foreign Keys to this table:

Comments

FA_BONUS_RULES stores information about your bonus depreciation rules.
Oracle inserts a row into this table for each bonus rule you define in the Bonus
Depreciation Rules form.

Indexes

Columns

[top of page]

FA.FA_BONUS_RULES does not reference any database object

FA.FA_BONUS_RULES is referenced by following:

FA

VIEW - FA_BONUS_RULES#

[top of page]

Table: FA_BOOKS

Primary Key: FA_BOOKS_PK

1. TRANSACTION_HEADER_ID_IN

Foreign Keys from this table:

Foreign Keys to this table:

Comments

FA_BOOKS contains the information needed for calculating depreciation.
.
When you initially add an asset, Oracle Assets inserts one row into the
table. This becomes the "active" row for the asset. Whenever you use the
Depreciation Books form to change the asset's depreciation information, or if
you retire or reinstate it, Oracle Assets inserts another row into the table,
which then becomes the new "active" row, and marks the previous row as
obsolete.
At any point in time, there is only one "active" row in the table for an asset
in any given depreciation book. Generally, Oracle Assets uses the active row,
but if you run a report for a prior accounting period, Oracle Assets selects
the row that was active during that period. You can
identify the active row for an asset in a book because it is the only one
whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL.
.
When Oracle Assets terminates a row, the DATE_INEFFECTIVE and
TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and
TRANSACTION_HEADER_IN of the new row, respectively. You can easily identify
rows affected by the same transaction because they have the same
DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN /
TRANSACTION_HEADER_ID_OUT pairs. When Oracle Assets creates the new row, the
value used for the TRANSACTION_HEADER_ID_IN column is the same as the
TRANSACTION_HEADER_ID in the row inserted into
FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date.
.
When you retire an asset, Oracle Assets inserts a new row to reduce the COST
by the amount retired. When you reinstate an asset, Oracle Assets inserts a
new row to
increase the COST by the COST_RETIRED in the corresponding row in
FA_RETIREMENTS.
.
NOTE: Altering the Adjusted Cost and Rate Adjustment Factor values damages
data integrity.

Indexes

Columns