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 laterInformation 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 |