My Oracle Support Banner

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:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
Advanced Global Intercompany System(AGIS)
AKXMOSED: Replicate Seed Data

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

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
References


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