My Oracle Support Banner

EAM: AMALLOC.UPDDIST.Step01A Failed With Unique Constraint (SYSADM.PS_DIST_LN) Violated (Doc ID 2421151.1)

Last updated on APRIL 03, 2019

Applies to:

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


For Assets with multiple ADD Lines ( In this case interfaced from PC ), the Asset Allocation Process ( AMALLOC ) fails with unique constraint Error at Step AMALLOC.UPDDIST.Step01A.


  1. Create a new Project    with one Activity.    
  2. Create 82 Transactions with the same Chartfield details but each with a different Currency Effective Date.    
  3. Process the Transactions.   
  4. Define Asset.   
  5. Run the Express Capitalization Process.

Note that there are 82 Interfaces created, each for every transaction.    

  1. Run AMIF1000.   
  2. Calculate Depreciation.   
  3. Create Accounting Entries.   
  4. Close Depreciation for period 2 and 3.   

10.Define Allocation.

11.Process Allocation.


Process 641825 ABENDED at Step AMALLOC.UPDDIST.Step01A (Action SQL) -- RC = 805



SQL Error: ORA-00001: unique constraint (SYSADM.PS_DIST_LN) violated



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

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