Manageable Dynamic Dependent Choice Lists that Includes Hundreds of Options and Dependent Options in Enterprise Capture
Last updated on NOVEMBER 23, 2016
Applies to:Oracle WebCenter Enterprise Capture - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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