Delivery number sequence in multi org
Anybody dealt with the following problem?
When you operate in a multi-org environment, the generation of delivery numbers goes accros organizations. For certain countries it is a legal requirement to generate delivery numbers in one sequence.
Anybody got a solution so that Oracle generates a following sequence of delivery numbers for one org in a multi org instance?
Current behaviour:
Delivery range
Org A 1 - 20
Org B 21 -40
Org A 41 - 60
Org B 61 - 80
Org A 81 - 100
Org B 101 - 120
Required behaviour:
Delivery range
Org A 1 - 10000000000
Org B 10000000001 - 20000000000