BUSINESS REQUIREMENT DOCUMENT – ACE Re Ltd & ACE RB Khobar

SIEBEL
CR# 1133 Date:
30/05/2021
Version: 01

Business Requirement: Treaty setup in Siebel.

Current Behavior: Current customized version of Siebel does not provide any provision to capture treaty entries
with the required details.

System Rules:
1) Below fields are enabled for Treaty Slips and are mandatory:
a) Treaty Type : Proportional & Excess of Loss (Non Proportional)
b) Financial Year : Invoicing Year
c) Underwriting Year : Policy incepted year
d) Quarter : Q1 /Q2/Q3/Q4
e) Description : Refer to the attachment “Description_Values.xls”
f) Layer : Layer 1,2 ,3 etc., (in case of XOL type)
g) Contract Period : Policy Period
h) Gross Premium : 100% Premium
i) ACE Share : Gross Premium on ACE Share
2) The above values are propagated to Quote to capture treaty financial recordings inline to the statement
shared by the Cedant against each Reinsurer.
3) A new field called “Treaty Elements” is enabled at the quote level to capture different Treaty elements to
capture the financial recordings against each reinsurer. (Please refer to the attached for
Treaty_elements.xls)
4) “Treaty Elements” multi value field will have below fields:
a. Treaty Element (Please refer to the attached for Treaty_elements.xls)
b. Share % (if applicable)
c. Gross Amount
d. ACE Share Amount
e. Type (Debit or Credit in line to Cedant share)
f. Applicable (yes OR no)
5) Once the above Treaty elements are captured, the quote is approved and below checks are done prior to
quote approval
a. Ceding commission check: Cedant Ceding commission = sum( Reinsurer Ceding commission)
b. Claims Paid check: Cedant Claims Paid = sum( Reinsurer Claims Paid)
c. O/S Loss Reserve check : Cedant O/S Loss Reserve = sum( Reinsurer O/S Loss Reserve)
d. Cash Call check: Cedant Cash Call = sum( Reinsurer Cash Call)
e. Premium Reserve/retained check: Cedant Premium Reserve/retained = sum( Reinsurer Premium
Reserve/retained)
f. Premium Reserve/retained check: Cedant Int on Prem Reserve-Release = sum( Reinsurer Int on
Prem Reserve-Release)
g. Released outstanding loss reserv check: Cedant Released outstanding loss reserv =
sum( Reinsurer Released outstanding loss reserv)
h. Int Released outstanding loss reserv check: Cedant Int Released outstanding loss reserv =
sum( Reinsurer Int Released outstanding loss reserv)
i. Portfolio Premium Entry/Withdrawal check: Cedant Portfolio Premium Entry/Withdrawal =
sum( Reinsurer Portfolio Premium Entry/Withdrawal)
j. Portfolio Loss Entry/Withdrawal check: Cedant Portfolio Loss Entry/Withdrawal = sum( Reinsurer
Portfolio Loss Entry/Withdrawal)
6) VAT Calculations at the quote level from Cedant invoicing and VAT regime perspective for the below
treaty and non-treaty elements:
a. Premium
b. Ceding commission
c. Cash Call
d. Premium Reserve-Released
e. Int on Prem Reserve-Release
 BUSINESS REQUIREMENT DOCUMENT – ACE Re Ltd & ACE RB Khobar
SIEBEL
CR# 1133 Date:
30/05/2021
Version: 01
f. Premium reserve
g. Portfolio Premium Entry
h. Portfolio Premium withdrawal
The above step does not change any calculations on commission VAT.
7) Once above quote is approved cover note button is enabled and cover note is approved to generate debit
and credit memo’s with gross amounts as per the exiting setup without any breakups.
8) The above memos are transferred to Oracle as gross amounts as per the exiting setup without any
breakups.
9) Periodically the below statements can be generated from Siebel.
a. SOA – Cedant (Proportional) (Please refer to the attached template SOA – Cedant.xls )
b. SOA – Reinsurer (Proportional) (Please refer to the attached template SOA – Reinsurer.xls )
c. SOA – Cedant (XOL) (Please refer to the attached template SOA – Cedant_XOL.xls )
d. SOA – Reinsurer (XOL) (Please refer to the attached template SOA – Reinsurer_XOL.xls )
10) Below new endorsements are captured in the system:
a. Cash call
i. Debit and Credit to different parties’ inline to the setup “Survey Fee”.
b. Profit Commission enabled below elements to be captured in the system: (for details please refer
to )
i. Gross Premium
ii. Ceding Commission
iii. Claim Paid
iv. Claim Outstanding
v. Management Expenses
vi. Loss B/F
vii. Profit Commission
viii. Due from RI
11) Periodically the below statements can be generated from Siebel.
a. SOA – Cedant (Proportional) (Please refer to the attached template SOA-
Cedant_Reinsurer_PC.xls)
b. SOA – Reinsurer (Proportional) (Please refer to the attached template SOA-
Cedant_Reinsurer_PC.xls )
12) Below tools will be made available:
a. SAMA fee zero facility to designated personnel with due management approval.
b. Premium VAT zero facility to designated personnel with due management approval.
c. Policy type  Cover Creation facility to designated personnel with due management approval.

Scope of Work:

1) Treaty interface
2) Treaty validation engine
3) Treaty Invoice creation
4) Report (Prop & Non Prop) Setup
5) Endorsement setup

Assumptions:

1) Changes are applied to all RI systems across KSA & OSA.

2) No changes to exiting debit & credit memo structure
3) No changes to the existing interface structure of debit & credit memo that is passed to Oracle and its
concerned accounting entries.
4) Existing Fee setup will used to book Management Expenses Brokerage.
5) This change has zero effect on commission VAT calculations and commission VAT is not in scope.
6) Treaty sections: Point 1 -12
7) Non Treaty Sections: Point 6 & 12
 BUSINESS REQUIREMENT DOCUMENT – ACE Re Ltd & ACE RB Khobar
SIEBEL
CR# 1133 Date:
30/05/2021
Version: 01
8) Accounts Sections: Point 6, 7, 8 & assumptions 2 & 3
9) All mentioned stakeholders will review and sign UAT sign off document

Escalation Model: NA
Effort Estimation: 24 Man-days (UAT excluded)
Developed by: Syed Fayaz
DEFAULT / Vanilla Functionality Change (Y/N): N

Above mentioned process is understood and agreed.

Required Delivery Order: IMMEDIATE

Sl. Remarks/Endorsi
Business Sign-Off Signature – Date
No ng Sections

1 Yolla El Khoury Management / Full BRD

2 Abdul Razaak Abdul Samad Management / Full BRD

OSA Management /
3 Simon Fisher OSA Treaty/Non Treaty
Sections

KSA RI Management /
4 Elie Abboud Full BRD

OSA RI Management /
5 Pantelis Messolonghitis Treaty Sections only

ACE Re KSA/OSA
6 Abdulla Awachi Compliance

OSA RI FAC stake holder

7 Arun Ramdas / Non Treaty Sections

OSA RI Treaty stake

8 Christopher Ysabel holder / Treaty Sections
only

OSA RI Accounts /
9 M.Murali Kumar Applicable Accounts
section

KSA RI stake holder /

10 Abdulla Faisal Alrayyash Full BRD

KSA RI stake holder /

11 Hessa D. Al Bin Ali Full BRD
 BUSINESS REQUIREMENT DOCUMENT – ACE Re Ltd & ACE RB Khobar
SIEBEL
CR# 1133 Date:
30/05/2021
Version: 01

KSA RI Accounts /
12 Sajjad Ali Al Darorah Applicable Accounts
section