PC_PO_TO_PC Process ABENDED at Step CA_SUM_RFSH.ChkNw1.NewInUse (SQL) -- RC = 805 (108,524) (Doc ID 1632438.1)

Last updated on JUNE 20, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : 9 version, Purchasing Integration

When attempting to run PC_PO_TO_PC process,
the following error occurs.

ERROR
-----------------------
File: e:\pt85207a-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_CA_SUM_IN_USE' with unique index 'PS_CA_SUM_IN_USE'. The duplicate key value is (CHESP, 1260700400, CONSTRUCTION, COM, N, I, USD, , , 0, ).
Failed SQL stmt:INSERT INTO PS_CA_SUM_IN_USE (BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, BI_DISTRIB_STATUS, GL_DISTRIB_STATUS, FOREIGN_CURRENCY, CONTRACT_CURRENCY, CONTRACT_NUM, CONTRACT_LINE_NUM, CA_FEE_STATUS, IN_USE_FLAG) SELECT BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, BI_DISTRIB_STATUS, GL_DISTRIB_STATUS, FOREIGN_CURRENCY, CONTRACT_CURRENCY, CONTRACT_NUM, CONTRACT_LINE_NUM, CA_FEE_STATUS, IN_USE_FLAG FROM PS_CA_SUM_T2_TAO51 WHERE PROCESS_INSTANCE = 2942128

Process 2942128 ABENDED at Step CA_SUM_RFSH.ChkNw1.NewInUse (SQL) -- RC = 805 (108,524)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Project Costing > Cost Collection > Purchasing Integration
2. Process abends with above message

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