Post Mass Additions (FAMAPT): Errors With "ORA-00054: resource busy and acquire with NOWAIT specified" (Doc ID 746776.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Assets - Version 11.5.9 to 11.5.9 [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:FAMAPT - Mass Additions Post


Symptoms

The Mass Additions Post process (FAMAPT) completes with the following error in the logfile, for some mass addition lines:-

------------
ORA-00054: resource busy and acquire with NOWAIT specified
Error: function FA_CHK_BOOKSTS_PKG.faxlck returned failure
A transaction is pending for this asset in another session. Please complete it and try again.
Failed to obtain lock on FA_BOOKS row for asset_id nnnn and book CORP_BOOK.
Error: function FA_CHK_BOOKSTS_PKG.faxlck returned failure
Error: function FA_CHK_BOOKSTS.faxcbs returned failure
Error: function FA_TRX_APPROVAL_PKG.faxcat returned failure
Error: function fa_adj_pub.do_all_books returned failure
Error: function fa_adjustment_pub.do_adjustment returned failure
Mass Addition ID: nnnnn ==> ** FAILED **
Error: function fa_massadd_pkg.do_mass_addition 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