Clarification Related To Reinsurance (Doc ID 2816412.1)

Last updated on OCTOBER 22, 2021

Applies to:

Goal

How to handle the following scenarios:

1. In Stg_prop_casualty_contracts: Suppose if one policy with multiple reinsurance contract codes is taken in P&C, then how is it to be taken in table. So if one v_account_number has multiple "v_reinsurance_contract_code", then due to constraint error in stage table there is an issue.

2. In Stg_Reinsurance_Contract_Held: for one v_ri_contract_held_code, suppose if we have multiple products (v_prod_code) linked to it, there will be constraint issue.
 

Solution

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