My Oracle Support Banner

HOW "FSI_INS_ACCOUNTING_DIM_MAP" TABLE DATA GETS GENERATED? (Doc ID 2984878.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Oracle Insurance Accounting Analyzer - Version 8.1.2 and later
Information in this document applies to any platform.

Goal

When run the SL batch for 31-JUL-2023 and 31-AUG-2023 FSI_INS_ACCOUNTING_DIM_MAP table doesn't load data based on FIC_MIS_DATE.

During August SL batch run it uses 31-JUL-2023 data for execution and doesn't clean up and load data for 31-AUG-2023

 

WHEN WE RUN 31-AUG-2023, IT HAS CLEANUP DATA FOR 31-JUL-2023

FSI_SUB_LED_CSM_GROUP_DIM_MAP HOLD ONLY DATA FOR ONE FIC_MIS_DATE.


 

Solution

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
Goal
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.