Content UI Does not Show Values in Child Field of DependentChoiceLists (DCL) but NativeUI does (Doc ID 2038258.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

In Content UI with Dependent Choice List(DCL), values are not listed in the child field even after choosing a value in the parent field.
(In Native UI, the child values are shown expectedly under the same scenario .)

When the issue happens, you can find below messages in the Content Server log.

Changes

 The issue occurs when the column of the relationship for DCL is set something
other than Parent View's internal column .

For example, you can reproduce the issue with the following steps.

1. Login the Native UI as an administrator.
2. Open "Admin Applets" in the "Administration" tab, then launch Configuration Manager applet.
3. Open "Views" tab and create 2 views as following:
   View Name:testParentView
   

   tc_id	label
   1	Database
   2	Middleware

   
   View Name:testChildView
   

   tcl_id	tc_id	label
   1	1	Database Standard Edition
   2	1	Database Enterprise Edition
   3	2	WebLogic Server
   4	2	WebCenter Content

4. Open "Relations" tab and add a relationship.
   Relationship Name:Parent2Child
   

   	Parent Info	Child Info
   table	testParentView	testChildView
   column	tc_id	tc_id

5. Back to "Views" tab, select "testParentView" and click [Edit].
6. Open "Info" tab and set the columns as following:
     - Internal Column = label
     - Visible Column = label
   Then click [OK].
7. On the "Views" tab, select "testChildView" and click [Edit].
8. Open "Info" tab and set the columns of the child view as following:
     - Internal Column = label
     - Visible Column = label
   Then click [OK].

Cause

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