EAM: Group Asset Depreciation Consolidate Process Error 805 Unique Constraint on PS_COST_GR2_TMP at Step AMGRPCON.CONS-ADD.Step06 (Doc ID 1604136.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

The Asset Management Group Asset Depreciation Consolidate process (AMGRPCON) fails with the following error messages when the Business Unit Book has Chartfield Summarization on two chartfields, and two asset have been entered with multiple cost rows for the two summarize chartfields and another chartfield.

File: e:\pt85306d-retail\peopletools\src\psappeng\aedebug.h
SQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_COST_GR2_TMP) violated
Failed SQL stmt: INSERT INTO PS_COST_GR2_TMP (PROCESS_INSTANCE, BUSINESS_UNIT, ASSET_ID, BOOK, DT TM_STAMP, MIN_DTTM_STAMP, CF_SEQNO, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, B USINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, PR OJECT_ID, DEPTID, CATEGORY, COST_TYPE, SEQUENCE2, TRANS_TYPE, TRANS_IN_OUT, TRANS_CODE, TRANS_DT, ACCOUNTING_DT, ACTIVITY_SW, RETIRE_SW, QUANTITY, COST, TRANSFER_BU, TRANSFER_ASSET_ID, TRANSFER_BOOK, OPRID, FROM_CUR, CONVENTION, IU_MAP_KEY, GROUP_ASSET_ID, ARCHIVE_ID, GRP_ACCU
Process 12577 ABENDED at Step AMGRPCON.CONS-ADD.Step06 (SQL) -- RC = 805
12577 AMGRPCON CONS-ADD Step06 SQL 805

The issue can be reproduced with the following steps:
1) Go to the Asset Management Business Unit Definition Business Unit/Book Feature page, click on the Summary link, and select Fund Code and Department in the Chartfield Summarization page for BU US003, Book CORP.
2) Go to Express Add, and add a Group Member Asset with 4 cost rows in BU US003:
        Fund F100, Department 13000, Project 0000000107, Cost 100.00
        Fund F200, Department 13000, Project 0000000107, Cost 200.00
        Fund F300, Department 13000, Project 0000000107, Cost 300.00
        Fund F400, Department 13000, Project 0000000107, Cost 400.00
3) Add a second Group Member Asset with 2 cost rows in US003:
        Fund F100, Department 13000, Project 0000000108, Cost 100.00
        Fund F300, Department 13000, Project 0000000108, Cost 200.00
4) Go to Depreciation > Group Asset Depreciation > Consolidate and submit AMGRPCON.

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