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 APRIL 26, 2021

Applies to:

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

Symptoms

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

 

ERROR
-----------------------

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



STEPS
-----------------------
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


 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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