My Oracle Support Banner

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 AUGUST 11, 2022

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

 Customized  RA_CUSTOMER_TRX_LINES_ALL and modified the size of UOM_CODE from VARCHAR2(3) to VARCHAR2(6)

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


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