PC_EXPRSS_AM Process 621899 ABENDED at Step PC_EXPRSS_AM.PctRows.InsRsTa2 (Action SQL) -- RC = 805

(Doc ID 2308622.1)

Last updated on OCTOBER 03, 2017

Applies to:

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

Symptoms

On :  Project Costing 9.2, Interfaces

When running the PC_EXPRSS_AM express application engine, the process fails with the following unique constraint error:


ERROR
-----------------------
-- 13:49:25.457 Process 621899 ABENDED at Step PC_EXPRSS_AM.PctRows.InsRsTa2 (Action SQL) -- RC = 805
ROLLBACK
/
-- 13:49:25.518 SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_PC_AM_RS1_TAO4' with unique index 'PS_PC_AM_RS1_TAO4'. The duplicate key value is (621899, 10000, 10RH1402, CNV_OPEN_EXP, 20099720            , 10000,


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Project/Activity and set up Asset Integration rules such that it uses Project Percent Distribution
2. Define express asset definition to distribute the amounts to 17 assets with following percentages

7.071, 7.14, 7.14, 6.977, 7.14, 7.139, 7.139, 4.402, 7.631, 5.393, 3.869, 4.826, 4.536, 6.622, 7.017, 2.275, 3.275 - net to 100%

3. Create the 10 ACT rows with following amounts
-889416.03
889416.03
-889416.03
82206.42
184616.36
232421.11
98375.65
10204.02
85886.2
195706.27

They all together net to 0

4. Run PC_EXPRSS_AM process. Notice that some of the targets will have AM_DISTRIB_STATUS of 'N' for the some Assets and these will not be there in PROJ_AM. Some of the targets will have AM_DISTRIB_STATUS of 'D' for the some Assets and these will be there in PROJ_AM (for tiny rounding amounts).
5. Run PC_EXPRSS_AM process again and the process abends with the above error

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