My Oracle Support Banner

シードデータの複製でエラー: ORA-20000: ORA-00001: unique constraint (AR.AR_MEMO_LINES_ALL_TL_U2) (Doc ID 1617680.1)

Last updated on JULY 10, 2020

適用範囲:

Oracle Receivables - バージョン 11.5.10.0 以降
この文書の内容はすべてのプラットフォームに適用されます。
Checked for relevance 03-Apr-2013

現象

あなたは新しい営業単位のセットアップをしています。あなたがシードデータの複製を実行中に以下のエラーが発生しました。:

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


変更点

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.