My Oracle Support Banner

11i: Replicate Seed Data Fails With ORA-01400 On Table: AR_CONT_ACTIONS_ALL (Doc ID 403726.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
ConcurrentProgram:AKXMOSED - Replicate Seed Data

Symptoms

When attempting to run Replicate Seed Data without parameter (the list of values does not include any parameter)
the following error occurs.

ERROR
declare
*
ERROR at line 1:
ORA-20000: ORA-01400: cannot insert NULL into
("AR"."AR_CONT_ACTIONS_ALL"."ORG_ID"):ad_morg.replicate_table_data(AR_CONT_ACTIONS_ALL,):
INSERT INTO AR_CONT_ACTIONS_ALL
(CONTINGENCY_CODE, REVREC_EVENT_CODE, DAYS, START_DATE, END_DATE, CREATED_BY,
CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN, ORG_ID) SELECT CONTINGENCY_CODE, REVREC_EVENT_CODE, DAYS,
START_DATE, END_DATE, CREATED_BY, CREATION_DATE,
LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, :X_target_org_id FROM
AR_CONT_ACTIONS_ALL 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_CONT_ACTIONS_ALL WHERE NVL(ORG_ID, -99) = NVL(:X_target_org_id, -99))
ORA-06512: at line 9


STEPS
The issue can be reproduced at will with the following steps:
1. Logon to System Administrator
2. Run Replicate Seed Data without passing any parameter because the list of value does not have any parameter

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot proceed with multi org setup.

Changes

Fresh Install
MultiOrg should be implemented.

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.