My Oracle Support Banner

How to Configure Three Level Hierarchical Picklist constraint by multiple values or Grand Parent? (Doc ID 1358023.1)

Last updated on DECEMBER 03, 2019

Applies to:

Siebel Tools - Version SIA[21219] and later
Information in this document applies to any platform.


User was facing issue in configuring the Three Level Hierarchical Pick list constraint by Parent and Grand Parent field values.

For the reference the scenario is given below:

Current Data model (LOV) for these picklists is as below: This is the Data Model which customer is using:
TYPE Name (LIC) Val Parent LIC

TYPE                    LIC                            Display               PLIC
SR_AREA            CLAIM                        Claim                                                     (Type PL)
SR_AREA            CLAIM_INFO               Claim Info            CLAIM                          (Area PL)
SR_AREA            CLAIM_REQUEST        Claim Request       CLAIM                          (Area PL)
SR_AREA            CLAIM_STATUS          Claim Status          CLAIM CLAIM_INFO       (Sub Area PL)

As per the current data model,
Type PL: displays the LOVs which has order number 1000 or more and No Parent LIC
Area PL: Has Parent LIC as LIC in Type LOV
Sub Area PL: has the Parent LIC as the combination of LIC in Type and Area
"Claim" is the LOV for Type PL,
"Claim Info" and "Claim Request" is the LOVs for Area PL (which has "Claim" as the
Parent LIC)
"Claim Status" is the LOV for Sub - Area PL( which has the " CLAIM CLAIM_INFO " as Parent LIC which is the combination of " CLAIM" and "CLAIM_INFO").


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.