3CENGINE Process Failed With Unique Constraint Error (Doc ID 1932057.1)

Last updated on MARCH 07, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the 3C engine to assign checklist items the following error occurs.

ERROR
-----------------------
File: e:\pt85305c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PERSON_CHECKLST) violated Failed SQL stmt: INSERT INTO PS_PERSON_CHECKLST (COMMON_ID, SEQ_3C, SA_ID_TYPE, CHECKLIST_DTTM, ADMI N_FUNCTION, CHECKLIST_CD, CHECKLIST_STATUS, STATUS_DT, STATUS_CHANGE_ID, DUE_DT, CURRENCY_CD, DUE_AM T, DEPTID, RESPONSIBLE_ID, INSTITUTION, TRACKING_SEQ, ORG_CONTACT, CONTACT_NAME, VAR_DATA_SEQ) SELEC T A.COMMON_ID, 1, A.SA_ID_TYPE, CAST(SYSTIMESTAMP AS TIMESTAMP), A.ADMIN_FUNCTION, A.CHECKLIST_CD, A .CHECKLIST_STATUS, A.STATUS_DT, '1006791', A.DUE_DT, A.CURRENCY_CD, A.DUE_AMT, ' ', A.RESPONSIBLE_ID , A.INSTITUTION, 0, 0, ' ', 0 FROM PS_ENG_CHK_TMP4 A WHERE A.COMMON_ID = '######' AND A.SA_ID_TYPE = 'P' AND A.INSTITUTION = 'PSUNV' AND A.EVENT_3CS_ID = 'FTYL_I' AND A.CHECKLIST_CD = 'FTYL' AND A.SE

Process 1287152 ABENDED at Step 3CENGINE_LIB.CHKINST.Step02 (SQL) -- RC = 805

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a checklist item.
2. Create a checklist code.
3. Create a 3C Event definition.
4. Run the 3C Engine process.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot assign checklists to students in batch.

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