My Oracle Support Banner

CL Product Maintenance Status Rule For Loss To Doub Getting Error On Save (Doc ID 2774168.1)

Last updated on NOVEMBER 08, 2021

Applies to:

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

Symptoms

CL _PROD MAINTAIN STATUS RULE FOR LOSS TO DOUB GETTING ERROR ON SAVE

1. Modify CL product,

Maintain status rule for LOSS to DOUB like below, system shows error on save,

((TENOR<=375 AND (((PRINCIPAL_OVR_DAYS>=61 AND PRINCIPAL_OVR_DAYS<=90) AND (MAIN_INT_OVR_DAYS>=61 AND MAIN_INT_OVR_DAYS<=90) AND (ADMIN_FEE_OVR_DAYS>=61 AND ADMIN_FEE_OVR_DAYS<=90)) OR
(PRINCIPAL_OVR_DAYS<=90 AND (MAIN_INT_OVR_DAYS>=61 AND MAIN_INT_OVR_DAYS<=90) AND (ADMIN_FEE_OVR_DAYS>=61 AND ADMIN_FEE_OVR_DAYS<=90)) OR
((PRINCIPAL_OVR_DAYS>= 61 AND PRINCIPAL_OVR_DAYS <= 90) AND (ADMIN_FEE_OVR_DAYS >= 61 AND ADMIN_FEE_OVR_DAYS <= 90) AND (MAIN_INT_OVR_DAYS <= 90)) OR
((PRINCIPAL_OVR_DAYS>=61 AND PRINCIPAL_OVR_DAYS<=90) AND (MAIN_INT_OVR_DAYS>=61 AND MAIN_INT_OVR_DAYS<=90) AND (ADMIN_FEE_OVR_DAYS<=90)) OR
(PRINCIPAL_OVR_DAYS<=90 AND ADMIN_FEE_OVR_DAYS<=90 AND (MAIN_INT_OVR_DAYS>=61 AND MAIN_INT_OVR_DAYS<=90)) OR
(PRINCIPAL_OVR_DAYS<=90 AND MAIN_INT_OVR_DAYS<=90 AND (ADMIN_FEE_OVR_DAYS>=61 AND ADMIN_FEE_OVR_DAYS<=90)) OR
(ADMIN_FEE_OVR_DAYS<=90 AND MAIN_INT_OVR_DAYS<=90 AND (PRINCIPAL_OVR_DAYS>=61 AND PRINCIPAL_OVR_DAYS<=90)))) OR
(TENOR>375 AND (((PRINCIPAL_OVR_DAYS>=180 AND PRINCIPAL_OVR_DAYS<360) AND (MAIN_INT_OVR_DAYS>=180 AND MAIN_INT_OVR_DAYS<360) AND (ADMIN_FEE_OVR_DAYS>=180 AND ADMIN_FEE_OVR_DAYS<360)) OR
(PRINCIPAL_OVR_DAYS=180 AND MAIN_INT_OVR_DAYS<360) AND (ADMIN_FEE_OVR_DAYS>=180 AND ADMIN_FEE_OVR_DAYS<360)) OR
((PRINCIPAL_OVR_DAYS>=180 AND PRINCIPAL_OVR_DAYS<360) AND (ADMIN_FEE_OVR_DAYS>=180 AND ADMIN_FEE_OVR_DAYS<360) AND (MAIN_INT_OVR_DAYS<360)) OR
((PRINCIPAL_OVR_DAYS>=180 AND PRINCIPAL_OVR_DAYS<360) AND (MAIN_INT_OVR_DAYS>=180 AND MAIN_INT_OVR_DAYS<360) AND (ADMIN_FEE_OVR_DAYS<360)) OR
(PRINCIPAL_OVR_DAYS180 AND MAIN_INT_OVR_DAYS<360)) OR
(PRINCIPAL_OVR_DAYS180 AND ADMIN_FEE_OVR_DAYS<360)) OR
(ADMIN_FEE_OVR_DAYS180 AND PRINCIPAL_OVR_DAYS<360)))))

ERROR
-----------------------

Error in validating rule Expresssion.



STEPS FOLLOWED
-----------------------
The issue can be reproduced at will with the following steps:
1. Modify Cl product
2. Maintain status rule for LOSS to DOUB
3. System throws error.


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.