Manageable Dynamic Dependent Choice Lists that Includes Hundreds of Options and Dependent Options in Enterprise Capture (Doc ID 2205800.1)

Last updated on MARCH 04, 2024

Applies to:

Goal

In WebCenter Enterprise Capture (WEC) 11g, it is possible to create dependent choice lists, where the values of a choice list change when the value of the primary choice list is changed. Currently this can only be done by creating specific child choice lists for every possible value of the primary choice list and then creating a specific dependent choice list for each combination.

This is not useable for a customer use case, where the parent choice list has a few hundred items. It is not feasible to create hundreds of dependent choice lists, and since those primary values can change over time, it will also be very difficult to maintain. Another issue is that we use database tables/views for the choice lists, and we would have to create a specific view for each possible child choice list.

Is it possible to have dynamic dependent choice lists where only one dynamic dependent choice list has to be defined plus two database based choice lists (primary/parent and detail/child). This would be an implementation of traditional primary-detail tables, where a column in the child table that links to the primary table is used to determine which child rows are applicable for each value in the primary choice list.

This option could define a primary-detail relationship between two choice lists that is very easy to maintain. Additional entries in both the primary and detail tables would immediately be applied to the application, without having to define the changes in the WEC console.

This feature would be very useful for all administrators for WEC. 

Solution

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