My Oracle Support Banner

Alerts :: NVL Condition In SELECT Clause Creating Errors (Doc ID 2877025.1)

Last updated on JUNE 21, 2022

Applies to:

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

Symptoms

On : 14.5.0.0.0 version, Implementation Support

Alerts :: NVL condition in SELECT clause creating errors

Bank have a requirement to create an alert with NVL condition in SELECT clause. Total we have 10 columns in select, but in package col11 is being referred too (Dynamic package is created based on commas in select clause to find number of columns and NVL condition is adding an extra column). But this is leading to compilation errors of dynamic package created

ERROR
-----------------------
IT-ALRT-004

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a alert criteria code such that in select, nvl condition is handled
2. Map the alert criteria code to a new alert definition
3. Save and authorize the alert definition.
4. Verify if the dynamic pkg is created successfully without any errors.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot authorize the alert definition.

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
References


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