My Oracle Support Banner

Multiple Projects In PC_POADJUST Run Control - ABENDED At Step PC_POADJUST.3INSCRV.Step01 (SQL) -- RC = 805 (108,524) (Doc ID 2395721.1)

Last updated on MAY 14, 2018

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 : 9.2 version, Functionality

PC_POADJUST running to No Success when run for multiple Projects

ERROR
-----------------------
-- 08:29:22.254 Process 2468756 ABENDED at Step PC_POADJUST.3INSCRV.Step01 (Action SQL) -- RC = 805
ROLLBACK
/
-- 08:29:22.319 SQL Error: {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015}
 DSNT408I SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID
  BECAUSE INDEX IN INDEX SPACE PSRP11QM CONSTRAINS COLUMNS OF THE TABLE
  SO NO TWO ROWS CAN CONTAIN DUPLICATE VALU

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On the run control page for PC_POADJUST process, choose the 'Busienss Unit /Project' option and provide the values. Select all the three 'Application Options'.
2. Click on the '+' symbol and provide a second project.
3. Run the PC_POADJUST process and verify the status in Process Monitor.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.