Queries In Data Analysis Of Fsi_ins_lc_grp And Discount engine (Doc ID 3041591.1)

Last updated on AUGUST 22, 2024

Applies to:

Goal

1. How can we add data into STG_INS_POLICY_CASH_FLOW table in amount column If we get the claims data in percentage instead of direct amount. 

1A. How will data load into these tables?

2. How can calculate the claims data in % percentage instead of direct amount for acquisition expenses, claim payment pattern and earned premium.

3. Need table names which stores input variables master list and properties.

4. How can we see all columns in LC group table where we have data as an input in our cash flow table.

In 'Input variable & FE relationship' tab. We are getting zero amount for the input variables

We want to understand weather it is correct as we can identify the cashflow date for the sum of the transaction are outside of reporting period.

5. how discounting is happening? Is it monthly, quarterly, annually.

Example: Policy A is issued on 1 june 2021 and end data is 31 may 2022. My run date is 31 dec 2021.

Solution

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