My Oracle Support Banner

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.

Symptoms

All sequences under schema RMS_BDI_INT have been reset during 19.3.006 upgrade. This is causing all BDI jobs to fail.

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


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