Sometimes business rules require that you have a way to uniquely identify an object other than its POID. Maybe you’re automatically generating service logins when a customer signs up for a new service. Or maybe the item you want to identify isn’t a BRM storable object, and so it doesn’t have a POID.
In this blog, I’ll talk about how to create custom sequences in Oracle BRM and the 4 steps for using them in your custom code. Sequences in BRM are stored in the data_t table with a poid type of /data/sequence. If you look in the data_t table, you’ll see that BRM comes OOB with sequences for things like bill numbers, payments, adjustments, and transaction ids.
That’s great, but let’s get to the good stuff. How do I create my own sequence?
To create a new sequence, there are 3 pieces of information you’ll need to pass in to BRM: