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 to [Release 1.0]
Information in this document applies to any platform.


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


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)

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. 


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