My Oracle Support Banner

ORA-01722: Invalid Number When Trying To Create Email Center Custom Queries For Use In Reply Templates (Doc ID 2441360.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Email Center - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Administration

Getting the following error when trying to create a very simple custom reply template for the use in Email Center reply templates according to "How To Create Email Center Custom Queries And Templates For Use When Replying To Emails (Doc ID 1446626.1)"

ORA-01722: invalid number

The issue can be reproduced at will with the following steps:
1. Go to Email Center Administrator responsibility
2. Navigate to Knowledge Base/Query/Create
3. Enter mandatory details
    Click Create
    See the message
        "Please enter values in the required SQL fields and click the "Validate SQL" button below to validate your query"
4. Enter a valid value for the bind variable and click "Validate SQL"
    Error appears


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.