EAM: Depreciation Reporting Fails on Step AMDPREPT.DPRPT720.STEP06A

(Doc ID 2351367.1)

Last updated on JANUARY 22, 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 20, Reports

AMDPREPT fails with the following unique constraint error:

ERROR
-----------------------
Oracle:

Process 135807 ABENDED at Step AMDPREPT.DPRPT720.Step06A (Action SQL) -- RC =
805
ROLLBACK
/
-- 17:41:20.558 SQL Error: ORA-00001: unique constraint
(EMDBO.PS_DEPR_RPT_CF_SUM) violated

DB2:

Process 116150 ABENDED at Step AMDPREPT.DPRPT720.Step06A (Action SQL) -- RC =
805
ROLLBACK
/
-- 08:16:08.500 SQL Error: [IBM][CLI Driver][DB2/AIX64] SQL0803N  One or more
values in the INSERT statement, UPDATE statement, or foreign key update
caused by a DELETE statement are not valid because the primary key, unique
constraint or unique index identified by "1" constrains

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Replication_Steps_and_Traces_9.2.25.docx

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with the month end close process.

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