EBS - SNO: Launching Strategic Network Optimization (SNO) Plan Ends With An Error "Exception caught: SQL Execption occurred: ORA-00911: invalid character"

(Doc ID 2022325.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Strategic Network Optimization - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

Issue in PS 12.1.3.9
Application: SNO Launch
----------------------------

When attempting to launch SNO plan the following error occurs.

ERROR
-----------------------
Exception caught: SQL Execption occurred: ORA-00911: invalid character
. Could not select from tablemsc_int_calendar_tv


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a SNO plan
2. Launch SNO plan & verify that it ends with the mentioned error


Cause

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