My Oracle Support Banner

ELA: Accounting Entries Fails At Step AM_AMAEDIST.600617.Step02 For Amended Lease Asset (Doc ID 2771697.1)

Last updated on JUNE 17, 2022

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Create Accounting entries fails at step AM_AMAEDIST.600617.Step02 while processing LA asset with Microsoft SQL Server Database:



Process XXXXXX ABENDED at Step AM_AMAEDIST.600617.Step02 (SQL) – RC = 8601

Cannot perform an aggregate function on an expression containing an aggregate or a subquery

The issue can be reproduced at will with the following steps:
1. Create new Payables Lease
a. Add Equipment
b. Add Base rent with one escalation
c. Allocate lease payments
d. Set the accounting distribution on asset to spread over 13 departments
e. Save, mark as reviewed, and activate Lease

2. Run Generate Straightline Schedule
3. Run AM_DEPR_Calc on new asset
4. Run Create Accounting Entries
5. Run DPClose
6. Amend Lease
a. Extend termination – change end date on base rent
b. Add escalation
c. Add Initial Direct Cost
d. Redistribute Costs and add new cost to asset
e. Replace one department with new code
f. Change percentages
g Save and activate amendment

7. Run Generate Straight Line Schedule
8. Run AM_DEPR_Calc
9. Run Create Accounting Entries
10. Accounting Entries Fails





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.