BCC adds unnecessary "FAKEDISPLAYNAME%" displayName filter that can cause performance issues
Last updated on JULY 02, 2018
Applies to:Oracle Commerce Platform - Version 11.1 and later
Information in this document applies to any platform.
While trying to browse assets in the BCC a performance issue may be encountered. When reviewing the logs after enabling debug on the product catalog the following query may appear surrounding timeout and/or session killed errors. You may also see errors like "ORA-00028: your session has been killed" but each environment may have different symptoms with regards to the error, but the debugging should show the query below as the culprit regardless of the database being used.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms