Accounting Program fails with Error ORA-12899: value too large for column "AR"."AR_XLA_LINES_EXTRACT"."UOM_CODE" (Doc ID 2274047.1)

Last updated on JUNE 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Subledger Accounting Uptake for Receivables

When attempting to run Create Accounting,the Accounting program fails with the following error in the log file 

ERROR
-----------------------
EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd
Error :ORA-12899: value too large for column "AR"."AR_XLA_LINES_EXTRACT"."UOM_CODE" (actual: 6, maximum: 3)

Changes

 Customer has customized  RA_CUSTOMER_TRX_LINES_ALL and modified the size of UOM_CODE from VARCHAR2(3) to VARCHAR2(6)

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