Fixed Assets - EBS (MOSC)

MOSC Banner

Journal Entry reserve Ledger report

edited May 16, 2011 8:33PM in Fixed Assets - EBS (MOSC) 1 commentAnswered
 Hi
My customer is not able to see depreciation reserve amount for few assets which are fully reserved before upgrade. So support suggested us to apply the below data fix script

update FA_DEPRN_DETAIL
set bonus_deprn_amount = decode(bonus_deprn_amount,
NULL, 0, bonus_deprn_amount),
bonus_ytd_deprn = decode(bonus_ytd_deprn,
NULL, 0, bonus_ytd_deprn),
bonus_deprn_reserve = decode(bonus_deprn_reserve,
NULL, 0, bonus_deprn_reserve),
bonus_deprn_adjustment_amount = decode(bonus_deprn_adjustment_amount,
NULL, 0, bonus_deprn_adjustment_amount)
where book_type_code = '&BOOK'

/

update FA_DEPRN_SUMMARY
set bonus_deprn_amount = decode(bonus_deprn_amount,

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