My Oracle Support Banner

Profile Upgrade Error: ORA-00001: unique constraint (FUSION.FND_DF_SEGMENTS_TL_U2) violated (Doc ID 2690021.1)

Last updated on MAY 18, 2023

Applies to:

Oracle Fusion Profile Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

Error received while running the 'Upgrade Profile Setup Data' schedule


ERROR
-----------------------

ORA-20001: create_context_sens_segment("10022", "HRT_PROFILE_ITEMS", "PERSON_CMI_MOBILITY_PREFERENCE", "ITEM_TEXT30_8") has failed.
ORA-20001: m_create_segment("10022", "HRT_PROFILE_ITEMS", "PERSON_CMI_MOBILITY_PREFERENCE", "ITEM_TEXT30_8") has failed.
ORA-20001: m_insert_segment("10022", "HRT_PROFILE_ITEMS", "PERSON_CMI_MOBILITY_PREFERENCE", "ITEM_TEXT30_8") has failed.
ORA-20001: Unable to insert "Segment (TL)" into "FND_DF_SEGMENTS_TL". Keys: (application_id: "10022", descriptive_flexfield_code: "HRT_PROFILE_ITEMS", context_code: "PERSON_CMI_MOBILITY_PREFERENCE", segment_code: "ITEM_TEXT30_8"), Language: US
ORA-00001: unique constraint (FUSION.FND_DF_SEGMENTS_TL_U2) violated


STEPS
-----------------------
1. Manage Profile Upgrading Mapping: Define Person Profile Mapping
2. Manage Profile Upgrading Mapping: Submit Upgrade Processes
3. Error on "Upgrade Profile Setup Data"

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

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