AMDPREPT.DPRPT720.Step01: Unique Constraint (SYSADM.PS_DEPR_RP5_TMP11) Violated (Doc ID 2152061.1)

Last updated on JUNE 23, 2016

Applies to:

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

Symptoms

On :  9.1 version, Depreciation

Return: 805 - ORA-00001: unique constraint (SYSADM.PS_DEPR_RP5_TMP11) violated  

This is on LOAD DEPRECIATION REPORTING TABLE function:

The error pointed on AMDPREPT.DPRPT200.Step16.SQL has already been fixed. However, we encounter another error. It is not only once that we see this, but below is the usual form:

Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_DEPR_RP5_TMP11) violated
Failed SQL stmt: INSERT INTO PS_DEPR_RP5_TMP11 (PROCESS_INSTANCE , BUSINESS_UNIT , BOOK , FISCAL_YEAR , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE , PROJECT_ID , DEPTID , CATEGORY , COST_TYPE , PROFILE_ID , GROUP_ASSET_FLAG ) SELECT DISTINCT PROCESS_INSTANCE , BUSINESS_UNIT , BOOK , FISCAL_YEAR , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE , PROJECT_ID , DEPTID , CATEGORY , COST_TYPE , PROFILE_ID , GROUP_ASSET_FLAG FROM PS_DEPR_RP4_TMP11 WHERE PROCESS_INSTANCE = 6365176

We are using the same data in TCIFSK to that in PCIFSK Prod. However, we don't encounter the error in Prod. Our PS Test has Bundles 36 upgrade while Prod has none.

The error is now pointed on AMDPREPT.DPRPT720.Step01.SQL

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Asset Management > Financial Reports > Load Reporting Tables > Depr Reporting Table

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