My Oracle Support Banner

WCC - Error with View After Removing a Column in a Table (Doc ID 1910760.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.



Reproduce the error in the Configuration Manager applet:
1. Create a new table: TestTable1
  A. Add new columns Testcolumn1, Testcolumn2
2. Create a new View: TestView1
  A. Select TestTable1 > Check both columns Testcolumn1, Testcolumn2 > Finish
  B. View Name and Description: TestView1
3. Go to the Views > select TestView1 > Edit Values... > Add... > Enter: One, Two > OK > Close
4. Go to Options > Publish schema.  It publishes without a problem.
5. Go to Tables > Select TestTable1 > Edit Table > Select Testcolumn1 > Delete > OK.
6. Go to the Views > Edit Values...
7. The error is displayed:

Unable to get edit information for view 'TestView1'. The view column field 'Testcolumn1' in the table 'TestTable1' for the view 'TestView1' is missing. Please reconfigure the view 'TestView1' with respect to the table.



 A columns ws removed in a table.  The view was using the column to generate values.


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.