My Oracle Support Banner

SAEXPSIM Fails With ORA-00001 After Store_day Deletion (Doc ID 2964076.1)

Last updated on JULY 28, 2023

Applies to:

Oracle Retail Sales Audit - Version 16.0.1 and later
Information in this document applies to any platform.


On : 16.0.1 version, Other

SAEXPSIM fails with ORA-00001 after store_day deletion when a revision was made in the initial loading (before deleting store_day) to a VOID CANCEL transaction.

"saexpsim_1~20221121090422~markTransactionExportedFlush~sa_exported~-1~ORA-00001: unique constraint (RMS.SA_EXPORTED_I1) violated~INSERT: NUM_RECORDS_PROCESSED=0 store_day_seq_no=15380601 system_code=SIM tran_seq_no=559356007"

The issue can be reproduced at will with the following steps:
1. Load one RTLOG containing VOID/CANCEL transactions.
2. In RESA application, create a revision to one of those VOID/CANCEL transactions, removing all line item information (delete line items).
3. Run SAEXPSIM. Transaction with revision will be exported to system_code SIM.
4. Delete store_day in RESA application
5. Load same RTLOG from step 1, again.
6. Run SAEXPSIM and verify that job fails with the above error


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

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