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 JULY 31, 2017

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

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