EAM: AMDPREPT 805 Error At Step AMDPREPT.DPRPT200.Step16 for an InterUnit Transfer (Doc ID 1681511.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

Load Depreciation Reporting Table (AMDPREPT) abends when processing an interunit transfer (IUT) transaction (during which the chartfields were changed) that was preceded by a transfer transaction for one book only.
The error is:
SQL error. Stmt # :1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PS_DEPR_RPT) violated
Process ABENDED at Step AMDPREPT.DPRPT200.Step16 (SQL) -- RC = 805

STEPS
1) Create an Asset Profile for 4 Books (ACE, AMT, CORP, FEDERAL).
2) Add an Asset in BU US001 using the 4 Book Profile. The ACE, CORP, and FEDERAL Books should all have the same Chartfield values (e.g Department = 10200), while the AMT Book has different Chartfields (e.g. Department = 10500).
3) Run the Depreciation Calculation process.
4) Transfer the AMT Book to the same Chartfields as the other Books (i.e. transfer AMT from Department 10500 to Department 10200). N.B. Copy Changes To Other Books must be OFF.
5) Run the Depreciation Calculation process.
6) Run the Load Depreciation Reporting Table process (AMDPREPT) for all the Asset's Books. There is no error.
7) InterUnit Transfer (IUT) the Asset from BU US001 to BU US002. Copy Changes To Other Books must be selected. Before saving the IUT transaction, change the Department from 10200 to 50000.
8) Run the Depreciation Calculation process.
9) Run the Load Depreciation Reporting Table process (AMDPREPT) for the Asset's CORP Book only.
10) Run the Load Depreciation Reporting Table process (AMDPREPT) for the Asset's ACE Book only.
11) Run the Load Depreciation Reporting Table process (AMDPREPT) for the Asset's FEDERAL Book only.
12) Run the Load Depreciation Reporting Table process (AMDPREPT) for the Asset's AMT Book only. AMDPREPT abends with the following error messages:
SQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PS_DEPR_RPT) violated
Process ABENDED at Step AMDPREPT.DPRPT200.Step16 (SQL) -- RC = 805
The abend occurs because the CF_SEQNO value is incorrect for the AMT Book's InterUnit TRF OUT transaction.

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