Query Related To Execution Of Iia_ins_cf_data_loader (Doc ID 2916394.1)

Last updated on DECEMBER 26, 2022

Applies to:

Goal

1) Suppose if transition date ='31-dec-2021' and we have 3 cashflow dates data in stg_ins_cohort assumed cfs table i.e 31-dec-2020, 31-dec-2021 and 30-jun-2022.
The FSI_INS_GROUP_CASH_FLOWS table is blank currently. Suppose we just execute 30-jun-2022, we have seen that 31-dec-2021 data is getting populated in FSI_INS_GROUP_CASH_FLOWS table.
Please let us know why?

2) Why 31-dec-2020 data is not flowing into fsi_ins_group_cash_flows for assumed cashflows

3) In case of actuals, is the same process followed as assumed that we execute for 30-jun-2022 and data for past dates will also flow into fsi_ins_group_cash_flows?

4) Suppose if 31-dec-2021 data is already present in fsi_ins_group_cash_flows, then does the data get deleted and re-inserted?
 

Solution

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