Market Message Portal Issue - UNIION ALL (Doc ID 2767336.1)

Last updated on AUGUST 16, 2024

Applies to:

Goal

Market Message Portal Issue - UNION ALL

Market Message Portal Issue - When we search for Market Message using
Market Message Type throws an error because of the generation of issue.
This issue exists only in the cloud environment. It works in an On-Premise environment

UNION ALL keyword is being converted to UNIONALL by CustomSQL Parser

Steps to replicate:-

1.Create a custom zone(CM), use UNION ALL in zone query.
2.Attach the zone to the portal.
3.Navigate to the Portal and go to the Zone.

NOTE:
spl.runtime.customSQLSecurity property should be enabled to be able to recreate the issue

Actual output: Error Message Number 11007,11013

Expected output: no error should not be encountered
 

Solution

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