Adding Assignment To Existing Lines Fails in Period of Addition with Error: function FA_INS_ADJUST_PKG.fadoact returned failure (Doc ID 2723585.1)

Last updated on JANUARY 10, 2021

Applies to:

Symptoms

When attempting to add a new assignment to an existing asset in period of addition,
the following error occurs.

ERROR
-----------------------
APP-OFA-48398: Program entered with errors

ORA-01403: no data found
Error: function FA_INS_ADJUST_PKG.fadoact returned failure
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
Error: function FA_TRANSFER_XIT_PKG.fadotfr returned failure

FA_TFR_BOOK_INFO

User-Defined Exception
Error: function FA_DISTRIBUTION_PVT.do_distribution returned failure

Can also present when doing multiple unit adjustments on the same asset:

Error: amount cleared 55416.66 does not equal amount inserted 55416.72; 
cannot create balanced journal entries Cause: You have a database problem. 
Action: Contact your system administrator.
FA_TFR_BOOK_INFO
User-Defined Exception
Error: function FA_DISTRIBUTION_PVT.do_distribution returned failure
Error: function FA_UNIT_ADJ_PUB.do_unit_adjustment returned failure

Changes

Cause

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