My Oracle Support Banner

BICC: Wrong Size Of Comments field in CrmAnalyticsAM.PartiesAnalyticsAM.PartyPerson VO (Doc ID 2504628.1)

Last updated on NOVEMBER 01, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.10.0 and later
Oracle Fusion Engagement Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Analytics

ACTUAL BEHAVIOR
---------------
BICC Data Store CrmAnalyticsAM.PartiesAnalyticsAM.PartyPerson have COMMENTS field showing VARCHAR 255, but when extracting the data, there are rows with 761 chars.

EXPECTED BEHAVIOR
-----------------------
Expect to have only 255 characters in it

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable CrmAnalyticsAM.PartiesAnalyticsAM.PartyPerson for extraction
2. After extracting the file, there are rows where COMMENTS field shows more than 255 characters

By checking in application, we can enter more than 255 chars

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload the data into a data base because wrong information

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.