AGIS: AKXMOSED: Replicate Seed Data Errors for AGIS Organizations: ORA-20000: ORA-00001: unique constraint (AR.RA_BATCH_SOURCES_U1) (Doc ID 2788198.1)

Last updated on JULY 05, 2021

Applies to:

Symptoms

Program AKXMOSED: Replicate Seed Data was run as part of AGIS Setup completion process and it errors as following.

Also it has been noticed that the AGIS batches do not flow to Oracle Receivables (AR) but stay stuck as SENT.

ERROR:

Log file:

AKXMOSED: Replicate Seed Data

Arguments
------------
700

Concurrent Manager encountered an error while running SQL*Plus for your concurrent request < >.

Review your concurrent request log and/or report output file for more detailed information.

Output:

declare
*
ERROR at line 1:
ORA-20000: ORA-00001: unique constraint (AR.RA_BATCH_SOURCES_U1)
violated:ad_morg.replicate_table_data(RA_BATCH_SOURCES_ALL,700):INSERT INTO RA_BATCH_SOURCES_ALL (BATCH_SOURCE_ID,
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, NAME, DESCRIPTION, STATUS, LAST_BATCH_NUM, [...]

EXPECTED BEHAVIOR
Expected that running the standard program as part of the setup completion should not error.

STEPS:
The issue can be reproduced at will with the following steps:
1. Oracle Receivables Responsibility > View > Requests > Submit a New Request
2. Run Program AKXMOSED: Replicate Seed Data for AGIS organization
3. Observe it errors

Changes

 AGIS setup completed recently.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.