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

Last updated on NOVEMBER 23, 2016

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

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 master choice list is changed. Currently this can only be done by creating specific child choice lists for every possible value of the master 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 master 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 (master/parent and detail/child). This would be an implementation of traditional master-detail tables, where a column in the child table that links to the master table is used to determine which child rows are applicable for each value in the master choice list.

This option could define a master-detail relationship between two choice lists that is very easy to maintain. Additional entries in both the master 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

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