FAMCP - Periodic Mass Copy Unable to insert from table fa_mc_books_rates ORA-01400: cannot insert NULL ("FA"."FA_MC_BOOKS_RATES"."EXCHANGE_RATE")
(Doc ID 1500807.1)
Last updated on JUNE 16, 2020
Applies to:Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
Running FAMCP - Periodic Mass Copy
Process fails on copying an adjustment transaction with:
Asset number #####
Transaction header id #####
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"."EXCHANGE_RATE").
Error: function fa_adjustment_pub.do_all_books returned failure
Error: function fa_adjustment_pub.do_adjustment returned failure
Mass Copy failed on this asset and transaction. Please review log file for more information.
Error: function fa_masscp_pkg.mcp_adjustment returned failure
Error: function fa_masscp_pkg.do_mass_copy 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!
In this Document
|Still Have Questions?|