Case 00030880 – FA Depreciation Override — Insert Asset Override Amounts into FA_DEPRN

FA Depreciation Override — Insert Asset Override Amounts into FA_DEPRN_OVERRIDE

Case Number	00030880
Oracle Module	Fixed Assets (FA)
EBS Version	R12
Functional Area	FA Depreciation / Depreciation Override
Related Patches	None

Symptoms

One or more fixed assets require a specific depreciation amount to be applied for a given period rather than the system-calculated amount.
The standard depreciation run would calculate an incorrect or undesired amount for the affected assets in the affected periods.
The asset depreciation cannot be corrected through standard UI adjustments — override entries in FA_DEPRN_OVERRIDE are required to force the correct amounts during the next depreciation run.

Root Cause

The FA depreciation engine uses FA_DEPRN_OVERRIDE to apply manually-specified depreciation amounts for specific assets and periods, bypassing the normal depreciation calculation. This mechanism is used when the calculated depreciation is incorrect due to data issues, book setup errors, or asset transfers that affect the system calculation. The fix populates the override table from a pre-loaded driver table so that the next depreciation run picks up the correct amounts.

Resolution

Step 1 – Create driver table and populate override data

Run 01_setup_interim_tables.sql. This creates the RSI_FA_DEPRN_OVERRIDE driver table with columns:

ASSET_ID — the fixed asset ID
PERIOD_NAME — the FA period name (e.g., 'JAN-2014')
DEPRN_AMOUNT — the override depreciation amount (stored as VARCHAR2; converted to NUMBER during the insert)

Populate RSI_FA_DEPRN_OVERRIDE with the correct override amount for each affected asset and period before proceeding to Step 2.

Step 2 – Insert override records into FA_DEPRN_OVERRIDE

Run 02_insert_asset_overrides.sql. Inserts rows from RSI_FA_DEPRN_OVERRIDE into the Oracle-standard FA_DEPRN_OVERRIDE table using the following values:

DEPRN_OVERRIDE_ID = FA_DEPRN_OVERRIDE_S.NEXTVAL
BOOK_TYPE_CODE = the affected asset book type code
ASSET_ID, PERIOD_NAME, DEPRN_AMOUNT from the driver table
USED_BY = 'DEPRECIATION'
STATUS = 'POST' — marks the override as ready to be applied by the next depreciation run

Step 3 – Run depreciation

Run the FA Depreciation process for the affected book and period. The depreciation engine will pick up the FA_DEPRN_OVERRIDE rows with STATUS = 'POST' and apply the specified amounts instead of the calculated amounts. After the run, the status is updated to a completed state by the depreciation process.

Note: FA_DEPRN_OVERRIDE is an Oracle-standard table used by the FA depreciation engine to accept manually-specified depreciation amounts. It must be populated before the depreciation run for the affected period. Rows with STATUS = 'POST' are processed by the next depreciation run; once processed, the status is updated automatically. Populate the RSI_FA_DEPRN_OVERRIDE driver table with the correct asset IDs, period names, and amounts before running the insert script.

Script Inventory

File	Description
01_setup_interim_tables.sql	Creates the RSI_FA_DEPRN_OVERRIDE driver table (ASSET_ID, PERIOD_NAME, DEPRN_AMOUNT). Populate this table with the override values before running script 02.
02_insert_asset_overrides.sql	Inserts records from RSI_FA_DEPRN_OVERRIDE into FA_DEPRN_OVERRIDE using FA_DEPRN_OVERRIDE_S.NEXTVAL for the override ID, with STATUS='POST' and USED_BY='DEPRECIATION'.

Key Tables Affected

Table	Action
FA_DEPRN_OVERRIDE	Insert depreciation override records for affected assets and periods
RSI_FA_DEPRN_OVERRIDE	Driver table — must be populated before running the insert script