EAM: AMALLOC Failed With Unique Constraint Error On PS_ALLOC_ROUND_TMP

(Doc ID 1927657.1)

Last updated on AUGUST 17, 2016

Applies to:

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


On :  9 version, Accounting Entries

AMALLOC failed with unique constraint error on PS_ALLOC_ROUND_TMP  

Process 10159 ABENDED at Step AMALLOC.ROUND.Step00 (SQL) -- RC = 805

The issue can be reproduced at will with the following steps:
1. Include TRF transaction type in DEPR transaction group - No account number filled in
2. Add an asset for building profile
3. Fill in an amount that is likely to need rounding in amount allocation (I used 1500002)
4. Run Depreciation
5. Transfer the asset – fill in the department id
6. Run depreciation
7. Run Create Accounting Entries
8. Run Depreciation Close
9. Run Allocation process




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 hundreds of Community platforms