R11i and R12.1 Depreciation (FADEPR) Extremely Poor Performance In First Depreciation Run (Doc ID 789539.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Assets - Version 11.5.10.2 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
FADEPR - Depreciation Run


Symptoms

Depreciation concurrent request (FADEPR) has been running for an extremely long time, mainly in processing this SQL statement:

select distinct 1 into :b0 from FA_ADJUSTMENTS ADJ where ((((ADJ.ASSET_ID=:b1 and
ADJ.BOOK_TYPE_CODE=:b2) and ADJ.ADJUSTMENT_TYPE in ('COST','COST CLEARING')) and ADJ.SOURCE_TYPE_CODE in ('CIP ADDITION','ADDITION')) and ADJ.PERIOD_COUNTER_CREATED=:b3)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms