EAM: AMAEDIST GOES TO NO SUCCESS FOR ARO ASSET ON SECOND RETIREMENT WITH REMOVAL COST (Doc ID 2276849.1)

Last updated on JULY 19, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR 
----------------------
AMAEDIST process goes to no success for ARO asset on second retirement with removal cost given. 


ERROR
-----------------------
Process 46718 ABENDED at Step AM_AMAEDIST.600693.Step10 (SQL) -- RC = 805


STEPS
-----------------------  
 
The issue can be reproduced at will with the following steps:

1. Add an asset with cost 600000 under BU ARO01  
 2. ARO measurment is done with labour cost of 5000
 3. Generate ARC
 4. Run AMIF1000 process  
 5. Go and view for the ARO asset generated in basic add for the above asset  
 under BU ARO01
 6. Run amdpcalc for both the assets
 7. Create accounting entries for both the assets  
 8. Retire the ARO asset with removal cost 1000
 9. run amdpcalc and AMAEDIST for the retired asset  
 10. Again retire the same asset giving removal cost as 1600
 11. run amdpcalc
 12. run amaedist for the ARo asset  
 13. process goes to No success - Process 46718 ABENDED at Step AM_AMAEDIST.600693.Step10 (SQL) -- RC = 805


SECOND SCENARIO  
-------------------------------
Incorrect DISTRIBUTION_TYPE and AMOUNT/TXN_AMOUNT for the final retirement for an asset that is not fully depreciated and when there was a prior partial retirement. In this case, the distribution type is GA when it should be GL. The
first partial retirement is creating the GL distribution type, which is correct. When another retirement is entered to retire the remaining quantity, that is when the incorrect GA distribution type is created.


EXPECTED BEHAVIOR
-----------------------
The DISTRIBUTION_TYPE created was 'GA' and should have been 'GL' and the amounts should have been positive rather than negative.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add an Asset.
2. Retire the asset partially.
3. Run the AMAEDIST process.
4. Retire the remaining quantity for the asset.
5. Run the AMAEDIST process

BUSINESS IMPACT
-----------------------
In the first scenario, accounting entries cannot be generated. In the second scenario, GL Loss is not reported accurately for the final retirement for an asset when there was a prior partial retirement.

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