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 DECEMBER 05, 2016

Applies to:

Oracle Assets - Version 11.5.10.1 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

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

Cause

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