My Oracle Support Banner

LCDTRONL - Unhandled Exception When Difference Between Expiry And Shipment Date Goes Above 3 Digit (Doc ID 2971936.1)

Last updated on SEPTEMBER 03, 2023

Applies to:

Oracle FLEXCUBE Universal Banking - Version 11.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.10.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
LCDTRONL - Unhandled exception when difference between expiry and shipment date goes above 3 digit.

System is throwing unhandled exception when difference between expiry date and shipment date goes above 3 digit (example 999 days)

ERROR
-----------------------
Noticed its failing in LCPKS_LCDTRONL_UTILS package under Fn_Validate_Ship_Docs while calculating period for presentation.
Period for presentation is having size 3. Hence, its failing.

ORA-06502: PL/SQL: numeric or value error: number precision too large

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open LCDTRONL and click on NEW
2. Input Expiry Date and Latest Shipment Date with difference between them having more than 999 days (for example : Expiry Date as 20/08/2026 and Latest Shipment Date as 20/08/2023)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, System is throwing unhandled exception, Input Expiry Date and Latest Shipment Date with difference between them having more than 999 days

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.