My Oracle Support Banner

EAM: AMAEDIST Fails With Single-row Subquery Returns More Than One Row Error in Step AM_AMAEDIST.600340.Step27 (Doc ID 2414087.1)

Last updated on FEBRUARY 01, 2019

Applies to:

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

Symptoms

On : 9.2 version, Functionality

AMAEDIST fails with single-row subquery returns more than one row error in
step AM_AMAEDIST.600340.Step27 (Action SQL).

This happens when processing 2 intra-unit transfers. The second transfer is
transferring 2 cf_seqnos to 2 different cf_seqnos in one transaction.

REPLICATION STEPS
=================
1. Create asset with 4 cf_seqno using Express Add.
2. Run AM_DEPR_CALC.
3. Run AMAEDIST.
4. Transfer one of the rows, cf_seqno 3 to create cf_seqno 4.
5. Run AM_DEPR_CALC.
6. Transfer cf_seqno 0 to cf_seqno 4.
7. Transfer cf_seqno 4 to cf_seqno 5.
8. Run AM_DEPR_CALC.
9. Run AMAEDIST.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create accounting entries

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.