My Oracle Support Banner

EAM: Incorrect DISTRIBUTION_TYPE And AMOUNT/TXN_AMOUNT For Retired Asset. (Doc ID 2276804.1)

Last updated on JANUARY 25, 2021

Applies to:

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


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

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

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

1. Add an asset with cost 600000 under BU ARO01  
 2. ARO measurement is done with labor 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

Incorrect DISTRIBUTION_TYPE and AMOUNT/TXN_AMOUNT for the final retirement of an asset that is not fully depreciated 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, the incorrect GA distribution type is created.

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

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

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.