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:

Symptoms

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").

Changes

Cause

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