PRP 28539902 Getting error at step Running the PRP-Package Impact Analysis Process
PeopleTools 8.57.05 - Application Engine
Copyright (c) 1988-2019 Oracle and/or its affiliates.
All Rights Reserved
Begin to run PRP confilict calculation with control ID: OPRJ28539902 (0,0)
Message Set Number: 0
Message Number: 0
Message Reason: Begin to run PRP confilict calculation with control ID: OPRJ28539902 (0,0) (0,0)
SQL error. Function: SQLExec
Error Position: 0
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PTIASPPRPCALC) violated
Statement: INSERT INTO PS_PTIASPPRPCALC(PTIASPPRPNAME , PTIASPRPTNO , SEQNBR) SELECT :1 , PTIASPRPTNOPRE , :2 FROM PS_PTIASPRPTREQS WHERE PTIASPREQTYPE IN ( 'REQUISITE','GP CALC','FUNCTIONAL','TRUE REQUISITE','ADS CALC' ) AND PTIASPREQDIRECTN IN ('BOTH','DOWN') AND PTIASPRPTNOPRE <> PTIASPRPTNO AND PTIASPRPTNO IN ( SELECT PTIASPRPTNO FROM PS_PTIASPPRPCALC WHERE PTIASPPRPNAME = AND SEQNBR= :4) AND PTIASPRPTNOPRE NOT IN ( SELECT PTIASPRPTNO FROM PS_PTIASPPRPCALC WHERE PTIASPPRPNAME = :5) AND PTIASPRPTNOPRE IN ( SELECT PTIASPRPTNO FROM PS_PTIASPRPTHEADVW)