My Oracle Support Banner

SqlPassThrough Queries Return The Super-Type Of An Asset Instead Of The Appropriate Sub-Type (Doc ID 2500914.1)

Last updated on FEBRUARY 13, 2020

Applies to:

Oracle Commerce Platform - Version 11.3 and later
Information in this document applies to any platform.


SqlPassThrough queries return the super-type of an asset when trying to retrieve the sub-type.

This leads to property not found errors when attempting to access the property of the asset which is part of the sub-type the asset belongs to, e.g. :

The issue does not occur when lazyLoading is set to 'false' to the corresponding repository.


 Upgraded environment from version 10.2 to version 11.3. On version 11.3 lazyLoading is enabled by default on all Repositories contrary to previous versions.


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.