My Oracle Support Banner

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

Last updated on MAY 26, 2023

Applies to:

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


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. Create data file where the transaction number ( SOURCE_TRX_NUMBER ) value is larger than 30 characters
2. Run transaction import process.
3. The Import process submitting a child job that ended in a warning
4. Review the import log and see the error


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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