NIT LENGTH ON JL_CO_GL_NITS TABLE NEEDS TO BE INCREASED (Doc ID 2070033.1)

Last updated on FEBRUARY 03, 2016

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.
Colombian Foreign Taxpayer ID

Symptoms

For Magnetic Medias there are customers and suppliers with NITs having 18 characters or more.
Need to change the field length of NIT column on JL_CO_GL table from maximum 14.

There is recent change in legislation (RESOLUTION NUM. 000228 of Oct 31 2013) that is now requiring Colombian companies to report the taxpayer id of foreign entities exactly how they are granted in their home countries, using Document Type 42.  In such cases, certain foreign taxpayer ids will not fit into 14 positions.

 																				

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