A common requirement in Siebel is to configure constrained picklists. First, let’s define what a constrained pick list means. A constrained picklist is a list of values (LOV), in which the values are dependent on another field.
Say we have an applet that has two fields: medical type and medical product.
These are the values for medical type:
- Medical Devices
If you choose vaccines, then the values for medical product would be:
- Hepatitis A
- Chicken Pox
If you choose drugs, the values for products would be:
Configuring Your Picklists in Siebel
So, how do you configure picklists? You need to use both Siebel Tools and the Siebel Open UI.
First, you need to create your picklists in Tools:
Next, you need to create the field on the associated business component (BC) with a normal pick map:
Learn how AI/ML can be used by pharmaceutical and medical device companies to improve the clinical data review and cleansing process.
Next, you need to create the field for the medical product. Note, that for this field, you have two pick maps – the second is flagged as being the field that constrains this field:
After you add those two fields to the applet you want, you are ready to add the LOV data.
First, you need to create the LOV type:
And then the LOV data:
And there you have it!
Learn More About Our Oracle Solutions
Life Sciences leaders rely on us for strategic and technical expertise with Oracle solutions to achieve their missions in a technologically advancing industry. Our experts are here to support you in achieving your business goals and solving your most complex technology challenges.
Download our guide, “Getting Started with Siebel CTMS in the Oracle Cloud” to learn the signs that it’s time for Siebel CTMS, the benefits of Siebel CTMS, how to build a business case for Siebel CTMS, and choosing a Siebel CTMS cloud implementation partner. To learn more or discuss your specific needs, Contact us.