Process Group Adjustments Completed With Error "A transaction is pending for this asset in another session" (Doc ID 2158333.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

When attempting to reclass a standalone asset into a Group Asset, the process spawns the Process Group Adjustment concurrent request, which fails with:

ERROR
-----------------------
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 12345 and book ABC CORP
Error: function FA_CHK_BOOKSTS.faxcbs returned failure
Error: function FA_TRX_APPROVAL_PKG.faxcat returned failure
Error: function FA_TRANSFER_PUB.do_transfer returned failure
Error: function fa_group_process_groups_pkg.do_rcl returned failure
Error: function fa_process_groups_pkg.do_all_books returned failure
Module FAPGADJ ended with error


STEPS TO REPRODUCE
-----------------------

Responsibility:  Fixed Assets Manager or similar

1. User selects a standalone asset which is not presently a member of any Group Asset with the intention of moving it to a Group.

Menu path:  Assets -- Asset Workbench.  Complete query information to pull back the standalone asset.

2. Press the "Books" button to open book level information for this asset.  Choose the book in which this asset should become a member.  That can be a Corporate Book or a Tax Book.

3. Choose the Group Asset tab.  Populate the Group Asset you wish this standalone to become a member of.  Accept defaults for other values, or modify if necessary.  Save.

4. The Process Group Adjustment concurrent request will be spawned. This will perform the reclass to the Group implicitly to get new distribution_id. It does not change expense or location id. Change of distribution_id required to handle accounting entries correctly.

5. Restriction added in the unpublished Bug 22674354 will stop transfer started by Process Group Adjustment. In other words, fix in Bug 22674354 is incorrect and results in corruption:

 Bug 22674354
====================
1. User created a member asset(10000) under the group asset (11111)
2. Try transferring the member asset(100000) from group asset (11111 to 22222).
3. Process Group adjustment kicked off.
4. Try to perform transfer on member asset (10000). i.e. change location or expense account before Process Group adjustment is complete. If transfer goes through, data corruption happens.
5. Code added in the fix for unpublished Bug 22674354 to stop such transfer. User should wait until Process Group adjustment is complete.

Bug 3444449334444493
==================
1. User creates standalone capitalized asset (10000). This is not member of any group.
2. Try moving capitalized asset (100000) as member of group asset (11111).
3. Process Group adjustment kicked off. Code process Group adjustment will perform Transfer implicitly to get new distribution_id. It does not change expense or location id. Change of distribution_id required to handle accounting entries correctly.
4. Restriction added in the bug 22674354 will stop transfer started by Process Group Adjustment. Further original fix to this issue, found in bug 23740117, has a typographical error that means it does not resolve the issue.
5. If customer applies the patch from bug 34444493 , code will by pass validation added in the 22674354. And Process Group adjustment completes normally.

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.