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

(Doc ID 2421151.1)

Last updated on JULY 10, 2018

Applies to:

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

Symptoms

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.

Steps:

  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

ROLLBACK

/

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

 "

Changes

 

Cause

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