My Oracle Support Banner

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

Last updated on MAY 22, 2023

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

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
Symptoms
Cause
Solution


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