Incentive Compensation Transaction Import Fails With Error: ORA-12899: value too large for column (Doc ID 2010190.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0
When attempting to import transactions to IC the import process failed.


ERROR
-----------------------

Record 1: Rejected - Error on table CN_TP_TRANSACTIONS_STAGING_T, column SOURCE_TRX_NUMBER.
ORA-12899: value too large for column "FUSION"."CN_TP_TRANSACTIONS_STAGING_T"."SOURCE_TRX_NUMBER" (actual: 32, maximum: 30)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Run transaction import process.
2.  The Import process submitting a child job that ended in a warning
3. Go to 'Credits and Earnings > Manage Credits' .   The transactions are not available. 



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