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

Last updated on AUGUST 24, 2016

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.
*** Checked for relevance on 13-Nov-2013 ***
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

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