ELM 9.2: PTSF_GENFEED (LS_LM_ACT_CI Search Defn) Failing with Unique Constraint Error Message
(Doc ID 2416289.1)
Last updated on JULY 16, 2018
Applies to:PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
After ELM 9.2 PUM #17, Rebuild Index Incremental LS_LM_ACT_CI search definition (AE PTSF_GENFEED), failing with Unique constraint error message.
SQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_LM_SRCH_DT1_TBL) violated Failed SQL stmt: INSERT INTO PS_LM_SRCH_DT1_TBL (LM_ACT_ID , LM_CI_ID , LM_ROW_MAINT_DTTM) SELECT EL G.LM_ACT_ID , ELG.LM_CI_ID , CAST(SYSSTAMP AS TIMESTAMP) FROM PS_LM_SRCH_EVENTVW ELG WHERE ELG.L M_UPCOMING_DAYS > 0 AND NOT EXISTS ( SELECT 1 FROM PS_LM_SRCHLSTRUNVW SRC WHERE SRC.LM_ACT_ID = ELG. LM_ACT_ID AND SRC.LM_UPCOMING_DAYS = ELG.LM_UPCOMING_DAYS) AND NOT EXISTS ( SELECT 'X' FROM PS_LM_SR CH_DT1_TBL DT1 WHERE DT1.LM_ACT_ID = ELG.LM_ACT_ID AND DT1.LM_CI_ID = ELG.LM_CI_ID)
Steps to Replicate Issue:
1. Log in as Administrator
2. Navigate to Main Menu> Enterprise Learning > Catalog > Rebuild Index
3. Create a run control for Incremental LS_LM_ACT_CI search definition
4. Submit Run for Process AE PTSF_GENFEED and fail with error message.
What specific scenario that is causing the issue has not been identified
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