Post Clone: ALTER SEQUENCE GL_JE_BATCHES_S INCREMENT BY N
Background/Scenario: We have downstream systems that pull data from EBS based on GL_JE_BATCHES.JE_BATCH_ID. Sometimes our non-PROD instances process more volume than our PROD instance does, so when we clone PROD down to TEST, the downstream systems can sometimes get duplicate JE_BATCH_ID values in their TEST environment.
Question: Does anyone see any notable risk in altering the GL_JE_BATCHES_S sequence in the TEST instance to set it to a value that is higher than it was before the clone?
Step 1: In Test instance: select max(je_batch_id) max_before from gl_je_batches