FA_RETIREMENTS

FA_RETIREMENTS contains information about asset retirements. Oracle Fusion Assets inserts a row into this table when you retire an asset and updates it if you reinstate the asset. When you perform a retirement, the row that Oracle Assets inserts has a TRANSACTION_HEADER_ID_IN and DATE_EFFECTIVE that matches the TRANSACTION_HEADER_ID and DATE_EFFECTIVE in FA_TRANSACTION_HEADERS. The TRANSACTION_HEADER_ID_OUT and DATE_INEFFECTIVE are NULL. If you reinstate a retirement for which Oracle Assets has calculated the gain or loss, Oracle Assets updates TRANSACTION_HEADER_ID_OUT and DATE_INEFFECTIVE with the TRANSACTION_HEADER_ID and DATE_EFFECTIVE from the FA_TRANSACTION_HEADERS row.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

FA_RETIREMENTS_PK

RETIREMENT_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
RETIREMENT_ID NUMBER 18 Yes Identifier of the asset retirement transaction.
BOOK_TYPE_CODE VARCHAR2 30 Yes Unique book identification name.
ASSET_ID NUMBER 18 Yes Identifier of the asset number.
TRANSACTION_HEADER_ID_IN NUMBER 18 Yes Identifier of the transaction that created the row.
DATE_RETIRED DATE Yes Date on which an asset was retired.
DATE_EFFECTIVE DATE Yes Date when the row became effective.
COST_RETIRED NUMBER Yes Amount of cost retired from the asset.
STATUS VARCHAR2 15 Yes Status of the retirement transaction.
RETIREMENT_CONVENTION_TYPE_ID NUMBER 18 Identifier of the prorate convention.
TRANSACTION_HEADER_ID_OUT NUMBER 18 Identifier of the transaction that terminated the row.
UNITS NUMBER Number of units retired in the transaction.
COST_OF_REMOVAL NUMBER Amount required to remove the retired asset.
NBV_RETIRED NUMBER Net book value of an asset at the time of retirement.
GAIN_LOSS_AMOUNT NUMBER Gain or loss amount from retiring an asset.
PROCEEDS_OF_SALE NUMBER Amount received from the sale of an asset.
GAIN_LOSS_TYPE_CODE VARCHAR2 15 Indicator of whether the retirement resulted in a gain or loss.
RETIREMENT_TYPE_CODE VARCHAR2 30 Reason why the asset is retired in the system.
REFERENCE_NUM VARCHAR2 15 Unique internal reference number for retirement transactions.
SOLD_TO VARCHAR2 30 Name of the party to whom the asset was sold as part of retirement.
TRADE_IN_ASSET_ID NUMBER 18 Asset identification number of the new asset for which the retired asset was traded.
STL_METHOD_ID NUMBER 18 Identifier of the straight line depreciation method used to calculate the depreciation for retirement transaction.
STL_DEPRN_AMOUNT NUMBER Straight line depreciation amount for reporting of 1250 property in a tax book.
REVAL_RESERVE_RETIRED NUMBER Revaluation reserve retired at the time of retiring an asset.
UNREVALUED_COST_RETIRED NUMBER Cost retired without any regard to any revaluations.
BONUS_RESERVE_RETIRED NUMBER Bonus depreciation reserve retired.
RECOGNIZE_GAIN_LOSS VARCHAR2 30 Option indicating whether gain or loss should be recognized for member asset retirement or not.
REDUCTION_RATE NUMBER Depreciation reduction percentage for the group and its member assets.
RECAPTURE_RESERVE_FLAG VARCHAR2 1 Option indicating whether reserve for the group asset can exceed its recoverable cost or not.
LIMIT_PROCEEDS_FLAG VARCHAR2 1 Option indicating whether the member asset proceed of sale should be limited to its recoverable cost or not.
TERMINAL_GAIN_LOSS VARCHAR2 30 Option indicating how terminal gain or loss should be recognized for member asset retirement.
RESERVE_RETIRED NUMBER Depreciation reserve retired along with the asset.
RECAPTURE_AMOUNT NUMBER Recaptured accumulated depreciation amount.
EOFY_RESERVE NUMBER Depreciation reserve at the end of the previous fiscal year.
IMPAIR_RESERVE_RETIRED NUMBER Impairment reserve amount which is retired.
ITC_RECAPTURED NUMBER Recaptured amount from investment tax credits.
ITC_RECAPTURE_ID NUMBER Identifier for the investment tax credits recapture rate.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Retirements (FA_RETIREMENTS)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
REVALUED_COST_RETIRED NUMBER Revalued cost amount retired for the asset.
BACKLOG_RESERVE_RETIRED NUMBER Backlog depreciation reserve amount retired for the asset.
REVAL_AMORTIZATION_RETIRED NUMBER Life-to-date revaluation reserve amortization amount for retirement.
TERMINATE_IB_ASSET_FLAG VARCHAR2 1 Indicates whether to terminate the associated installed base asset when a fixed asset is retired.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_RETIREMENTS fa_book_controls BOOK_TYPE_CODE
FA_RETIREMENTS fa_additions_b ASSET_ID
FA_RETIREMENTS fa_transaction_headers TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE
FA_RETIREMENTS fa_transaction_headers TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE
FA_RETIREMENTS fa_convention_types RETIREMENT_CONVENTION_TYPE_ID
FA_RETIREMENTS fa_additions_b TRADE_IN_ASSET_ID
FA_RETIREMENTS fa_methods STL_METHOD_ID
FA_RETIREMENTS fa_itc_recapture_rates ITC_RECAPTURE_ID
fa_distribution_history fa_retirements RETIREMENT_ID
fa_mc_books fa_retirements RETIREMENT_ID
fa_books fa_retirements RETIREMENT_ID
fa_retirements_t fa_retirements RETIREMENT_ID

Indexes

Index Uniqueness Tablespace Columns
FA_RETIREMENTS_N1 Non Unique Default ASSET_ID, BOOK_TYPE_CODE
FA_RETIREMENTS_N2 Non Unique Default TRANSACTION_HEADER_ID_OUT
FA_RETIREMENTS_U1 Unique Default RETIREMENT_ID
FA_RETIREMENTS_U2 Unique Default TRANSACTION_HEADER_ID_IN