My Oracle Support Banner

FCELCM-14.5-Data In 'GETB_FACILITY_MAIN_BLOCKS' Not Updated After EOD. (Doc ID 2888738.1)

Last updated on AUGUST 23, 2022

Applies to:

Oracle FLEXCUBE Enterprise Limits and Collateral Management - 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

ACTUAL BEHAVIOR
---------------
Data in 'GETB_FACILITY_MAIN_BLOCKS' not updated after EOD. with version 14.5.3v


STEPS
-----------------------

1.Facility A.3 with Liab No: XXXX1, Liab Branch : YY1, Line Currency: BRL, Main_Line Code: LIMIT.3
2.Facility LIMIT.3 is with line currency: USD
3.Currency Rate between USD and BRL is 9.8
4.Created Block for A.3 of amount 2XXX with block currency: BRL
5.After Block Creation Block Amount in Facility Screen for A.3 is 2XXX BRL and for LIMIT.3 is 2YY.8 USD which is expected.
6.Now modified currency rate from 9.8 to 8 between USD and BRL.
7.RUn EOD.
8.After EOD, Block amount in Facility LIMIT.3 got successfully updated from 204.8 to 250 USD which is expected.
9.But after EOD, if we check the table GETB_FACILITY_MAIN_BLOCKS, the data is not updated. It is same before and after EOD.
10.Expected is Limit_block and exchange rate should be updated after EOD.

Changes

 Fix provided to update the main blocks as well incase there is a difference in parent block.

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


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