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

(Doc ID 370807.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.

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

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