CIP Source Line Transfer Errors With ORA-20000 'Trigger adj api failure' and ORA-01400 Cannot Insert Null Into FA_MC_BOOKS_RATES
Last updated on APRIL 16, 2018
Applies to:Oracle Assets - Version 220.127.116.11 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms