Fixed Assets - EBS (MOSC)

MOSC Banner

how do i get fa_deprn_override adjustment to work

edited Nov 1, 2018 5:05AM in Fixed Assets - EBS (MOSC) 2 commentsAnswered

How do I get the fa_deprn_override to work when using the used_by=adjustment option?   Here is an explanation of what we did.  First of all, we changed the LIM on one account for an international account from 3 to 5 years to spread out the depreciation.  This worked fine, however our tax book is now calculating a different deprecation schedule.

SELECT book_type_code, ASSET_ID, LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR, ADJUSTED_COST, COST,

ROUND(((ADJUSTED_COST/(LIFE_IN_MONTHS/12)/12/RATE_ADJUSTMENT_FACTOR)),2) "DEP EXP"

FROM FA.FA_BOOKS

WHERE TRANSACTION_HEADER_ID_OUT IS NULL

AND DATE_INEFFECTIVE IS NULL

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center