R11i and R12.1 Depreciation (FADEPR) Extremely Poor Performance In First Depreciation Run
(Doc ID 789539.1)
Last updated on SEPTEMBER 21, 2023
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)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
Still Have Questions? |
References |