ORA-12899 Error When Deploying a Rest Custom Service

(Doc ID 2302443.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Installation Issues

When attempting to deploy a custom service ,
the following error occurs.

ERROR
-----------------------
Error encountered in remote method.oracle.apps.fnd.isg.common.error.ISGException : Error in updating Exception Info for class name = CUSTOM_PKG_NAME java.sql.SQLException :
ORA-12899: value too large for column "APPLSYS"."FND_SOA_SERVICE_DT_ERRORS"."OPERATION" (actual: 1455, maximum: 30)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Integrated SOA Gateway
2. Integration Repository
3. Find the service
4. Click on Deploy

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