My Oracle Support Banner

Getting SQL Errors, Invalid column name 'subType' When Configure Add New OCE Mapping (Doc ID 2743254.1)

Last updated on JANUARY 06, 2023

Applies to:

Oracle WebCenter Sites - Version 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

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