My Oracle Support Banner

Oracle Product Lifecycle Analytics (OPLA) 3.6 Masterd Data Schema (MDS).MDS_PPM_ACTIVITY_FS_PRO Failed During Change Data Capture (CDC) Load (Doc ID 2438845.1)

Last updated on APRIL 01, 2019

Applies to:

Oracle Product Lifecycle Analytics - Version 3.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 3.6.0 version

Getting the below error in OPLA environment during MDS CDC load and this issue is not occurring for FULL load.

ERROR
-----------------------
plsql block.MDS.MDS_PPM_ACTIVITY_FS_PRO -
Error occurs while fetching the journal entries;...Error:ORA-06502: PL/SQL:
numeric or value error: character string buffer too small

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run MDS CDC Load

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
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.