Autoinvoice Errors With ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 1532021.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle Receivables - Version 12.1.2 and later
Oracle Order Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

Autoinvoice fails with the following errors in a log file:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error calling arcdaa_do_autoaccounting()

Debug log shows:

ar.plsql.default_contingencies rows inserted in rule gt: 18
ar.plsql.default_contingencies OTHERS: default_contingencies
ar.plsql.default_contingencies ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ar.plsql.default_contingencies (2) OTHERS: line_collectibility
ar.plsql.default_contingencies ORA-06502: PL/SQL: numeric or value error: character string buffer too small
..

Steps to Reproduce:
1) Define a revenue contingency rule in Revenue management super user.
2) Select Bill to Customer as the Criteria
3) Add more that 140 customers to this criteria.
4) Run Autoinvoice

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