Creating A Custom Sequence in Oracle BRM

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:

Articles & Resources

To access this premium content, please fill out the form to receive an email with the access token.

* required fields

Horton Works

Hortonworks is a leading innovator in the industry, creating, distributing and supporting enterprise-ready open data platforms and modern data applications. Our mission is to manage the world’s data. We have a single-minded focus on driving innovation in open source communities such as Apache Hadoop, NiFi, and Spark. We along with our 1600+ partners provide the expertise, training and services that allow our customers to unlock transformational value for their organizations across any line of business. Our connected data platforms powers modern data applications that deliver actionable intelligence from all data: data-in-motion and data-at-rest. We are Powering the Future of Data™.