My Oracle Support Banner

Brazil Customer Merge Program Is Writing A High Volume Of Records To Redo Tables - Error 50103 MSG-00001: JL_CMERGE.JL_BR_JOURNALS_UPD ORA-30036 (Doc ID 1530389.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Data Quality Management

Attempting to run Brazil Customer Merge and receive the following error:

ERROR
-----------------------
Error 50103 (C Engine): MSG MSG-00001: JL_CMERGE.JL_BR_JOURNALS_UPD : ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS' 31-JAN-2013 02:02:43

The TKPROF Shows Updating obsolete tables (JL_BR_JOURNALS_ALL, JL_BR_BALANCES) was taking a long time and creating a performance issue.

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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