11i: Replicate Seed Data Fails With ORA-01400 On Table: AR_CONT_ACTIONS_ALL
Last updated on AUGUST 25, 2017
Applies to:Oracle Receivables - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
*** Checked for relevance on 13-Nov-2013 ***
ConcurrentProgram:AKXMOSED - Replicate Seed Data
When attempting to run Replicate Seed Data without parameter (the list of values does not include any parameter)
the following error occurs.
ERROR at line 1:
ORA-20000: ORA-01400: cannot insert NULL into
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
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
The issue has the following business impact:
Due to this issue, users cannot proceed with multi org setup.
MultiOrg should be implemented.
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