ORA-06502 In OKLLAAPP when Performing a Rebook (Doc ID 2248909.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Lease Authoring

When attempting to rebook a contract and perform a customer change, the contract stays in Approved status and the workflow errors with the following:


ERROR
-----------------------
Error in Workflow OKLLAAPP/4289008 ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Item Type = OKLLAAPP
Item Key = 4289008
User Key =

Error Name = -6502
Error Message = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error Stack =
OKL_KBK_APPROVALS_WF.update_approval_status(OKLLAAPP, 4289008, 248965, RUN)
Wf_Engine_Util.Function_Call(OKL_KBK_APPROVALS_WF.UPDATE_APPROVAL_STATUS, OKLLAAPP, 4289008, 248965, RUN)

Activity Id = 248965
Activity Label = KBK_APPROVAL_CONTROLLER:UPDATE_APPROVAL_STATUS
Result Code = #EXCEPTION
Notification Id =
Assigned User =


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform a rebook for a customer change
2. Try to book the revised contract, it stays in Approved status and workflow shows the error above.

Changes

 

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