Fixed Assets - EBS (MOSC)

MOSC Banner

Update of expense_code_combination_id in FA_Mass_Additions Table

edited Mar 28, 2013 5:10AM in Fixed Assets - EBS (MOSC) 6 commentsAnswered ✓
We have a custom program to derive the depreciation expense account and update the expense_code_combination_id column in FA_Mass_Additions.  We are converting from 11i to R12.  The update statement is failing to write values into the table; however, no error messaage is being produced.  It is a simple update statement. 

                    UPDATE   FA_MASS_ADDITIONS
                    SET      expense_code_combination_id = v_new_ccid
                    WHERE    mass_addition_id = cur_rec.mass_addition_id
                    AND      book_type_code = cur_rec.book_type_code
                    AND      asset_category_id = cur_rec.asset_category_id;

I have verified the data meets the conditions in where clause.  Can anyone help me with this issue?

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