OIC: Manual Import Failed With Pl Sql Error In Package CN_IMP_TRXAPI_PVT Procedure Trxapi_Import

(Doc ID 2220624.1)

Last updated on JANUARY 07, 2017

Applies to:

Oracle Incentive Compensation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms




Issue:
While trying to upload the attached template and trying to Import the data,standard Import fails with the following message,

Trxapi_Import : ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package CN_IMP_TRXAPI_PVT Procedure Trxapi_Import : -6502ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ERROR
-----------------------
Trxapi_Import : ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package CN_IMP_TRXAPI_PVT Procedure Trxapi_Import : -6502ORA-06502: PL/SQL: numeric or value error: character string buffer too small



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. IC Manager Responsibility
2. Tasks
3. Import/Export
4. Error


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