Crediting ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2198926.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Run Crediting process error on the child job Generate Direct Incentive Credits

ERROR
ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists
ORA-08103: object no longer exists

OR

End of the procedure CN_RS_ASSIGN_BULK_PUB.process_winner: Unexpected exception
-6502 : ORA-06502: PL/SQL: numeric or value error: character string buffer too small



STEPS
Navigator > Credits and Earnings > Run Crediting
Parameter :
  Business Unit = Energy
  Date Range = 2016-01-01 to 2016-09-30
  Mode = NEW


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