Add List To Target Group Via Event Error ORA-01461 Can Bind a LONG Value Only For Insert Into a LONG Column (Doc ID 1929807.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Marketing - Version 12.1.3 and later
Information in this document applies to any platform.
Reviewed 21st Aug 16

Symptoms

Adding a list to a target group via an Event throws an error.

ERROR
---------
Exception Details.
 oracle.apps.fnd.framework.OAException:
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1678
ORA-06512: at line 1


STEPS
---------

Navigate to Oracle Marketing Super User >Event
Create a new Event. Then click on Event schedule in cue card to create a new Event schedule for this event.
After creating new Event Schedule, click on Campaign link in cue card to create a new campaign for this schedule.
Click on Create Button to create new campaign(Make sure to use very large name for this campaign).
After creating campaign, create a new Activity(Make sure to use very large name for this activity) for this campaign.
Now click on Target group tab for this activity to crate a target group.
Create a new target group(Use very big name for this)
Add a list and receive 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