My Oracle Support Banner

Evergreen Billing Program Rejecting Contract Numbers >20 Characters (Doc ID 2594540.1)

Last updated on OCTOBER 01, 2019

Applies to:

Oracle Lease and Finance Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Billing Modules

Evergreen Billing program (OKLEVGBILL) rejecting contract numbers >20 characters, the request fails with the following error
 
ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package OKL_EVERGREEN_BILLING_PVT Procedure BILL_EVERGREEN_STREAMS


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Book a contract with >20 characters in the number - give it a short term / end date around now
2. Bill, accrue etc up until end of contract
3. Run Evergreen Billing Concurrent request, and see error in log


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
References


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