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 SEPTEMBER 10, 2020
Applies to:PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.
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.
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.
The issue has the following business impact:
Due to this issue, users cannot create accounting entries
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