1. Tables and Views for Financials
  2. FA_DEPRN_RULE_DETAILS

FA_DEPRN_RULE_DETAILS

This table defines detailed information for depreciable basis rule. It contains the available combination of the method type and calculation basis, the available asset types, defines whether depreciable basis is update at the each period, the subtraction method for depreciation expense among other details.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FA_DEPRN_RULE_DETAILS_PK

DEPRN_BASIS_RULE_ID, DEPRN_RULE_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
DEPRN_RULE_DETAIL_ID NUMBER 18 Yes Identifier of the depreciable basis rule detail row.
DEPRN_BASIS_RULE_ID NUMBER 18 Yes Identifier of the depreciation basis rule.
RATE_SOURCE_RULE VARCHAR2 15 Yes The depreciation rate source. Possible values are CALCULATED, FLAT, PRODUCTION, FORMULA or TABLE.
DEPRN_BASIS_RULE VARCHAR2 15 Yes Depreciation calculation basis. It can be based on cost or net book value.
ASSET_TYPE VARCHAR2 15 Yes Type of the asset allowed in the Oracle Fusion Assets. The asset types allowed are Capitalized, construction-in-process (Construction-in-Process), Expensed, and Group.
PERIOD_UPDATE_FLAG VARCHAR2 1 Periodic depreciable basis updating indicator. Possible values are Y, N or null. Y means that the adjusted cost is updated by every period after the depreciation expense calculation. N or Null means that the adjusted cost is updated by fiscal year end only after the depreciation expense calculation.
SUBTRACT_YTD_FLAG VARCHAR2 1 Subtraction method indicator for depreciation expense calculation. Possible values are Y for depreciation expense calculation using the subtraction method and N or Null for depreciation expense calculation not using the subtraction method.
ALLOW_REDUCTION_RATE_FLAG VARCHAR2 1 Option indicating whether to allow entering reduction rate or not.
USE_EOFY_RESERVE_FLAG VARCHAR2 1 Option indicating whether to allow entering the prior year depreciation reserve with retirement and reclassification or not.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
USE_RSV_AFTER_IMP_FLAG VARCHAR2 1 Option indicating whether current reserve at the time of impairment will be deducted from depreciable basis or not.
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.
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.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_DEPRN_RULE_DETAILS fa_deprn_basis_rules DEPRN_BASIS_RULE_ID

Indexes

Index Uniqueness Tablespace Columns
FA_DEPRN_RULE_DETAILS_U1 Unique Default DEPRN_BASIS_RULE_ID, DEPRN_RULE_DETAIL_ID, ORA_SEED_SET1
FA_DEPRN_RULE_DETAILS_U11 Unique Default DEPRN_BASIS_RULE_ID, DEPRN_RULE_DETAIL_ID, ORA_SEED_SET2