My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2022

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.