My Oracle Support Banner

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:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
References


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