In Multi Schema Implementation Sequencer Generates Same Sequence

(Doc ID 1942439.1)

Last updated on NOVEMBER 21, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


In a multi-schema BRM implementation, there seems to be an issue in the sequence generation while using for some custom reports.


*  One is using the out of box (OOB) sequencer module to generate sequence number for some custom reports.
*  The table is on integrate schema and it is referred by all 10 PINs (schemas).
*  Below is the registry snippet :

        Source = Database
              SequencerType = Generation
              DatabaseConnection = ifw.DataPool.Login
              ReuseGap = True
              SequenceLength = 6

*  See below for example, couple of reports generated with same sequence :

voice_000158_10_20140905124122.dat  ( generated by pipeline on schema 10 )
voice_000158_2_20140905124122.dat  ( generated by pipeline on schema 2 )

voice_000025_7_20140904055844.dat  ( generated by pipeline on schema 7 )
voice_000025_10_20140904055844.dat  ( generated by pipeline on schema 10 )

*  As the source for sequence number is same table, one would expect that the sequence number should never be same for different schema.


What is the issue in the sequencer module in this scenario ?


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms