All Sequences Under Schema RMS_BDI_INT Have Been Reset During 19.3.006 Upgrade
(Doc ID 2865443.1)
Last updated on MAY 03, 2022
Applies to:Oracle Retail Integration Cloud Service - Version 19.1 and later
Information in this document applies to any platform.
All sequences under schema RMS_BDI_INT have been reset during 19.3.006 upgrade. This is causing all BDI jobs to fail.
The issue can be reproduced at will with the following steps:
1. Run the nightly batch in POM
2. Observe the BDI jobs are aborting with unique constraint error
3. Check the sequences in the RMS_BDI_INT schema, eg . select RMS_BDI_INT.PRICE_CHANGE_OUT_SEQ.nextval from dual
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