Error Applying RPC5 Patch (22644544) On Csmindex.ldt: Unique Constraint Violated NO DATA FOUND

(Doc ID 2304981.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Mobile Field Service - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3

When applying patch 22644544, the following error occurs.

ERROR
-----------------------
Error loading seed data for ASG_PUB_ITEM_INDEX: INDEX_ID = CSF_M_SRTASKS_N1, ORA-00001: unique constraint (ASG.ASG_PUB_ITEM_INDEX_U1) violated
ORA-06512: at "APPS.ASG_ITEM_INDEX_PKG", line 27
ORA-06512: at "APPS.ASG_ITEM_INDEX_PKG", line 179
ORA-01403: no data found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 22644544
2. Error occurred

Changes

 

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