My Oracle Support Banner

EAM: AMALLOC Process ABENDED At Step AMALLOC.CHARTFLD.Step01 (Action SQL) -- RC = 1427 ROLLBACK (Doc ID 2414087.1)

Last updated on JUNE 21, 2018

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

AMALLOC process ABENDED at Step AMALLOC.CHARTFLD.Step01 (Action SQL) -- RC = 1427 ROLLBACK

-- 17:44:48.779 ....(AMALLOC.CHARTFLD.Step01) (SQL)
UPDATE PS_ALLOC_TMP SET AFFILIATE = (select DIST.AFFILIATE from
PS_DIST_LN_TEMP DIST where DIST.BUSINESS_UNIT = PS_ALLOC_TMP.BUSINESS_UNIT
AND DIST.ASSET_ID = PS_ALLOC_TMP.ASSET_ID AND DIST.BOOK = PS_ALLOC_TMP.BOOK
AND DIST.DTTM_STAMP = PS_ALLOC_TMP.DTTM_STAMP AND DIST.DISTRIBUTION_TYPE =
PS_ALLOC_TMP.DISTRIBUTION_TYPE AND DIST.ACCOUNTING_DT =
PS_ALLOC_TMP.ACCOUNTING_DT AND DIST.TRANS_TYPE = PS_ALLOC_TMP.TRANS_TYPE AND
DIST.CATEGORY = PS_ALLOC_TMP.CATEGORY AND DIST.COST_TYPE =
PS_ALLOC_TMP.COST_TYPE AND DIST.CF_SEQNO = PS_ALLOC_TMP.CF_SEQNO_LAST AND
DIST.PROCESS_INSTANCE = 1508160 AND DIST.BUSINESS_UNIT = 'PRINU') WHERE
AFFILIATE = ' ' AND PROCESS_INSTANCE = 1508160 AND BUSINESS_UNIT = 'PRINU'
/
-- Row(s) affected: 0
-- 17:44:48.819 Process 1508160 ABENDED at Step AMALLOC.CHARTFLD.Step01 (Action SQL) -- RC = 1427
ROLLBACK
/

ERROR
--------





STEPS
--------
The issue can be reproduced at will with the following steps:
1.
2.
3.

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

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!


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