Importing Journals with Tax Codes fails: Ora-12899: Value Too Large For Column Gl.Gl_interface.Tax_code (Doc ID 577824.1)

Last updated on JANUARY 12, 2025

Applies to:

Goal

- In the table AP_TAX_CODES_ALL, the column TAX_CODE has the type Varchar2(15).
- In the table AR_VAT_TAX_ALL, the column NAME has the type Varchar2(50).
- In the table GL_INTERFACE, the column TAX_CODE has the type Varchar2(15).

The system allows you to create tax_codes longer than 15 characters, but when attempting to import journals with a receivables tax_code longer then 15 characters, an error is thrown due to the column TAX_CODE length in GL_INTERFACE:
ORA-12899: VALUE TOO LARGE FOR COLUMN GL.GL_INTERFACE.TAX_CODE

Solution

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