Replicate Seed Data Error: ORA-20000: ORA-00001: unique constraint (AR.AR_MEMO_LINES_ALL_TL_U2) (Doc ID 370807.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

You are setting up a new organization. When you run 'Replicate Seed Data' as one of the setup steps, the following error occurs:

declare
*
ERROR at line 1:
ORA-20000: ORA-00001: unique constraint (AR.AR_MEMO_LINES_ALL_TL_U2)
violated:ad_morg.replicate_table_data(AR_MEMO_LINES_ALL_TL,439):INSERT INTO
AR_MEMO_LINES_ALL_TL (MEMO_LINE_ID, NAME, DESCRIPTION,
LANGUAGE, SOURCE_LANG, LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY,
LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORG_ID) SELECT
MEMO_LINE_ID, NAME, DESCRIPTION, LANGUAGE, SOURCE_LANG, LAST_UPDATE_DATE,
CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, :X_target_org_id FROM AR_MEMO_LINES_ALL_TL A WHERE
NVL(ORG_ID, -99) = nvl(:X_source_org_id, -99) AND NOT (ORG_ID
= -3114 AND :X_target_org_id IS NOT NULL) AND NOT EXISTS ( SELECT NULL FROM
AR_MEMO_LINES_ALL_TL WHERE NVL(ORG_ID, -99) =
NVL(:X_target_org_id, -99) AND MEMO_LINE_ID = A.MEMO_LINE_ID AND LANGUAGE =
A.LANGUAGE)
ORA-06512: at line 9

Cause

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