My Oracle Support Banner

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

Last updated on JULY 17, 2019

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 #### and book &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: #### ==> ** FAILED **
Error: function fa_massadd_pkg.do_mass_addition 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.