My Oracle Support Banner

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.

Symptoms

 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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Still Have Questions?


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.