Unable To Create Task If Customer Name Is More Than 80 Characters (Doc ID 1985202.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Common Applications Calendar - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Service Request Form

When attempting to create task for a customer, whose name is more than 80 characters..

ERROR
-----------------------
ORA-12899: value too large for column "JTF"."JTF_TASK_REFERENCES_B"."OBJECT_NAME" (actual: 125, maximum: 80)

STEPS
-----------------------
1. Define a customer, whose name is more than 80 Characters.
2. Create SR for this customer account and save.
3. Create task and save -> Receive Error message (screenshot is attached.)

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