1. Tables and Views for Financials
  2. FA_RATES_

FA_RATES_

FA_RATES stores the annual depreciation rates used by the depreciation program to calculate depreciation for your assets that use life-based depreciation methods. . When you create a depreciation method using the Life-Based Depreciation Methods form, Oracle Assets inserts a row into this table for each depreciation rate you define for a year of life and prorate period (PERIOD_PLACED_IN_SERVICE). The number of prorate periods per year for a method is defined by PRORATE_PERIODS_PER_YEAR in FA_METHODS. . Oracle Assets does not use FA_RATES to store rate information for straight-line methods because the depreciation program calculates the rate by dividing the life in years into 1. . .

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FA_RATES_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, METHOD_ID, YEAR, PERIOD_PLACED_IN_SERVICE

Columns

Name Datatype Length Precision Not-null Comments
METHOD_ID NUMBER 18 Yes Depreciation method identification number.
YEAR NUMBER 4 Yes Fiscal year of asset life
PERIOD_PLACED_IN_SERVICE NUMBER 3 Yes Period number from the prorate calendar in which the asset was placed in service
RATE NUMBER Depreciation rate
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 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 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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
FA_RATES_N1_ Non Unique Default METHOD_ID, YEAR, PERIOD_PLACED_IN_SERVICE
FA_RATES_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, METHOD_ID, YEAR, PERIOD_PLACED_IN_SERVICE