General Ledger - EBS (MOSC)

MOSC Banner

Post Clone: ALTER SEQUENCE GL_JE_BATCHES_S INCREMENT BY N

edited Apr 6, 2016 3:46PM in General Ledger - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center