My Oracle Support Banner

OFSLL UAT - Error In : Cmnlkc_cl_000_01.get_lookup (Doc ID 3007749.1)

Last updated on MARCH 03, 2024

Applies to:

Oracle Financial Services Lending and Leasing Cloud Service - Version 14.12.0.0.0 to 14.12.0.0.0 [Release 14]
Information in this document applies to any platform.

Symptoms

OFSLL UAT - Error in : cmnlkc_cl_000_01.get_lookup

Frequently getting this error in UAT, can check what is the wrong with the package. Please see the attached for fill list.

ERROR
-----------------------
  Ora Error Msg : ORA-06502: PL/SQL: numeric or value error: character to number conversion error
  Error in : cmnlkc_cl_000_01.get_lookup
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Modify the lookups and update the sort field with more then 5 digits
2. Save the record
3. Log-off and Log-in to the application
4. Verify the alert.log for any errors

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users are not able to see the new lookups on the screen

Changes

 

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
Changes
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.