My Oracle Support Banner

CI -The Effective Dates Are Null During Query of Account In CIDACCVM Screen (Doc ID 2715237.1)

Last updated on JULY 26, 2021

Applies to:

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


CIDACCVM UDE issue maint_rslv_flag type R

Bank was facing an issue on the VAMI screen (CIDACCVM) screen. The issue is that for instance there is a contract that has has revisions for a UDE and it has maint_rslv_flag as R when they click execute query on this screen then system in the effective date grid shows the dates but there is no data in the User Defined Element Value grid, hence everything is null.

When we looked into the problem we saw that in package cipks_cidaccvm_utils theres a function named as fn_query_master, the cursor that has the query attached to it is only picked up those data with maint_rslv_flag as "M" only, our concern is that it should also pick up the "R" value flag as well.

Because if it is not supposed to pick up the "R" flag values then system should not have displayed the effective dates for it either.

System should display all the ude rate records.

The issue can be reproduced at will with the following steps:
1. Query a CI account with ude having maint_rslv_flag as R
2. Check whether those ude dates value is displayed in the details tab.

The issue has the following business impact:
Due to this issue, users cannot view the details.


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

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