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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


When attempting to Process Group Adjustments
the following error occurs.

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
-----------------------
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. 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 22674354 to stop such transfer. User should wait until Process Group adjustment is complete.

<Bug 23740117>
==================
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. In other words, fix in bug 22674354 is kind of suicide for such test case.
5. If customer applies the patch from bug 23740117 , code will by pass validation added in the 22674354. And Process Group adjustment completes normally.



Changes

 

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