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

Last updated on JUNE 21, 2022

Applies to:

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

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