German Localization CLE: German VAT Reports Completed with Error due to Table Size Limitation for Tax Account Segment (Doc ID 2201313.1)

Last updated on NOVEMBER 08, 2016

Applies to:

EMEA Add-on Localizations - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, DE Add-on Localizations

CLE: German VAT Reports completed with error due to table size limitation for Tax Account Segment


ERROR
-----------------------
The error reported is:

[100716_013246316][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-20101: CLE_F250_UNEXPECTED_ERROR (ERROR=ORA-12899: value too large for column "CLE"."CLE_F250_VAT_TRANS_TEMP"."REV_COST_ACCOUNT" (actual: 12, maximum: 10)) (PROC=Assigning dates to the Global Date parameters)
ORA-06512: at "APPS.CLE_F250_VDTRC_PKG", line 636
ORA-06512: at line 4


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. CLE: German VAT Reports


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the reports

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