In Multi Schema Implementation Sequencer Generates the Same Sequence
(Doc ID 1942439.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]Information in this document applies to any platform.
Goal
On all versions of Oracle Communications Billing and Revenue Management (BRM), in a multi-schema BRM implementation, there is an issue in the sequence generation while using for some custom reports.
Scenario:
- 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
Controller
{
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.
Question:
What is the issue in the sequencer module in this scenario ?
Solution
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
| Goal |
| Solution |
| References |