Entity Name is not in List for UPD905422_ADDL_SUP_01.DOC Delivered with Bundle 33 - Generates Errors ORA-00001 and ORA-00904

(Doc ID 1673197.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR  
---------------
While applying CS Bundle 33 users get to the manual steps that need to be followed for the supplemental doc UPD905422_ADDL_SUP_01.doc.  That doc instructs users to update the Common Attribute Framework Record for the 'SAD_TESTDT'.  It tells the users to expand the Entity Associations within the Attributes section to associate the recently delivered IELTS with the Entity name 'Test ID International English' which is a valid Entity and the PTE with 'Test ID Pearson Test of Englis' also a valid Entity.  The problem is that even if a user runs the entity sync process, these entities do not show up as valid values on the prompt for the field Entity Name.

EXPECTED BEHAVIOR
-----------------------
Expect these values to show in the dropdown.

ERROR(S)
-----------------------
ORA-00001: unique constraint (SYSADM.PS_WL_TEMPLATE_GEN) violated
Failed SQL stmt: UPDATE PS_WL_TEMPLATE_GEN SET WL_TEMPLATE_ID='GRADE_CHANGED_PUSH' WHERE WL_TEMPLATE_ID IN ('FINAL_GRADES_CHANGED_PUSH')
Process 1808 ABENDED at Step UPD905422_A2.MAIN.Step01 (SQL) -- RC = 805 (108,524)

ORA-00904: "SCC_NTF_CON_ID": invalid identifier
Failed SQL stmt: INSERT INTO PS_SCC_NTFBEVT_CON (OPRID , RUN_CNTL_ID , SCC_NTF_CON_ID , SCC_STATUS) SELECT OPRID , RUN_CNTL_ID , SCC_NTF_CON_ID ,'A' FROM PS_BATNTF_RC_TMP
Process 1864 ABENDED at Step UPD905422_A3.MAIN.Step01 (SQL) -- RC = 904 (108,524)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Follow the steps in the supplemental doc UPD905422_ADDL_SUP_01.doc

BUSINESS IMPACT
-----------------------
The issue has the following business impact:


Due to this issue, users cannot complete this manual step of the implementation of bundle 33

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