UpdatedealsIn Adaptor throws Error When Restriction Comment Field length is 3000 characters. (Doc ID 1342469.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Media Intellectual Property Management - Version 3.3.3.0 to 3.3.15.0 [Release 3.3.0]
Information in this document applies to any platform.

Symptoms

Getting error if the RESTRICTION_COMMENT exceeds the length of 3000 characters.

Problem Description:

1. We are creating restrictions against a deal using the updatedealsin adaptor by passing XML to it.
2. UpadteDealsIn adaptor is throwing an infinite error, when the value for the RestrictionComment tag in the XML is having 3000 characters. It is not allowing more than 980 characters (approximately).
3. In the RESTRICTION_DISPLAY table, the length for RESTRICTION_FIELD column is 3000 (VARCHAR2). But the adaptor does not accept this quantum of data when the same is passed in the XML.

Expected Solution:
ResctrictionComment should be passed with length of 3000 characters.


Changes

 

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