My Oracle Support Banner

Hyphens In SQLs Automatically Converted Into A Special Character In Zones (Doc ID 2338023.1)

Last updated on NOVEMBER 26, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version and later
Information in this document applies to any platform.


After upgrading from to, one of our CM zones, which contains SQL statements with negative numbers (number preceded by "-" character), is erroring with invalid SQL errors.
After looking into the issue, we noticed that if a SQL statement in a zone has "-24" (minus twenty four), whenever we make any change in the zone and save it, the minus sign is automatically converted into a special / invalid character.


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.