Getting SQL Errors, Invalid column name 'subType' When Configure Add New OCE Mapping
(Doc ID 2743254.1)
Last updated on JANUARY 20, 2021
Applies to:Oracle WebCenter Sites - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Content and Experience Configure Add New OCE Mapping throws SQL errors
When attempt to "Add New OCE Mapping" from the Admin menu -> Oracle Content and Experience -> Export Mapping -> Configure page and select the checkbox for a flex family asset type, it does not populate the SubTypes container on the page.
This is logged several times in the sites.log (seems to occur for each of our Flex Family assets):
java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'subType'.
The column name in the OCEMapping table is "subtype" (lowercase "t").
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