My Oracle Support Banner

Query Related To Cashflow Types (Doc ID 2816399.1)

Last updated on MAY 24, 2023

Applies to:

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

Goal

Queries related to cashflow types pertaining to the tables stg_ins_cohort_assumed_cfs & stg_ins_cohort_actuals
1. Cashflow type =90 (Earned premium), here there is no transaction type mapped in dim_transaction_type_attr. So for taking the data, do we need to create a transaction type code and map to cashflow type =90?
2. Further, earned premium needs to be taken as actual(stg_ins_cohort_actuals) cashflow? if yes then what should be the cashflow date as it is a notional amount.
So suppose if the as of date = 31-dec-2020, then for computation, should the cash_flow_date be 31-dec-2020?
 

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


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