My Oracle Support Banner

All LOVs Are Displayed for Hierarchical Picklist While Querying Data (Doc ID 2337692.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Siebel CRM - Version [IP2014] and later
Information in this document applies to any platform.


We have hierarchical picklist in Service Request BC (Field: INS Area, INS Sub-Area). Since this is a hierarchical picklist, while querying, it is showing the entire values with LOV type as SR_AREA. The picklist is also constrained with a calculated field.

While querying the records, the calculated field is not set and entire LOV is displayed.

Is there any way to set the calculated field while performing query record?


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.