My Oracle Support Banner

Null/Unreadable Data Coming in Bucket After Executing Cashflow for FSI_D_CASA (Doc ID 2823263.1)

Last updated on JANUARY 10, 2022

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.6.1.0 to 8.1.2 [Release 8 to 8.1]
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management - ALM
Oracle Financial Services Analytical Applications Infrastructure - AAI
Oracle Financial Services Enterprise Performance Management - EPM
Oracle Financial Services Analytical Applications - OFSAA

Symptoms

On : 8.0.6.1.0 ALM version Null/unreadable data coming in bucket after executing cashflow for FSI_D_CASA

Value is showing as null on database but when querying the data while filtering out data based on filter "IS NULL" there are no records .

Query used ,
select * from res_dtl_216974 where FINANCIAL_ELEM_ID=430 and bucket_032 is null;



But when using the BETWEEN filter for bucket_032 between 0 and 1 , the result contain records.
select * from res_dtl_216974 where FINANCIAL_ELEM_ID=430 and bucket_032 between 0 and 1;


 

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.