CIP Source Line Transfer Errors With ORA-20000 'Trigger adj api failure' and ORA-01400 Cannot Insert Null Into FA_MC_BOOKS_RATES
(Doc ID 1491319.1)
Last updated on NOVEMBER 17, 2020
Applies to:Oracle Assets - Version 188.8.131.52 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Unable to transfer a source line from one CIP asset to another.
Error: function fa_mc_util_pvt.get_existing_rate returned failure
ORA-20000: Trigger adj api failure. Unable to insert information from table fa_mc_books_rates. Error: ORA-01400 cannot insert null into ("FA"."FA_MC_BOOKS_RATES"."AVG_EXCHANGE_RATE").
Error: function fa_adjustment_pub.do_all_books returned failure
Error: function fa_adjustment_pub.do_adjustment returned failure
Error: function fa_inv_xfr_pub.do_transfer returned failure
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!