R11i and R12.1 Depreciation (FADEPR) Extremely Poor Performance In First Depreciation Run
(Doc ID 789539.1)
Last updated on SEPTEMBER 02, 2020
Applies to:Oracle Assets - Version 188.8.131.52 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
FADEPR - Depreciation Run
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)
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
|Still Have Questions?|