How to Configure Three Level Hierarchical Picklist constraint by multiple values or Grand Parent?

(Doc ID 1358023.1)

Last updated on JUNE 22, 2017

Applies to:

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

Goal

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
i.e.:
"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").

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms