Blog

Oracle Integration Cloud – OIC – Introduction – Part 1

by Rochelle Cunningham Rochelle Cunningham No Comments

Oracle Integration Cloud – OIC – Introduction – Part 1

 

The principal aim of writing this blog is to publish the most frequently used real-time industry use cases where OIC is used. For those of you who have limited knowledge of OIC – Oracle Integration Cloud is a cloud based Integration tool. It seamlessly integrates on-prem applications with Oracle Cloud (SaaS) or other Cloud Apps (as Workday, Salesforce etc.) to other Cloud Apps. Like any other integration tool in the market (as Dell Boomi) – OIC relies on ADAPTERS to create connections with the end points. End Points mean source and destination entities between which data is to be exchanged. Imagine OIC as a pipe capable of transforming, mapping data between two discrete entities – Adapters connect to these entities. In OIC – data is read, mapped, transformed, orchestrated from Source via Connection Adapters with usual stuff as fault Handling (local and global) available and is transferred to the Destination again via Connection Adapters.

OIC is a PaaS service as available from Oracle.

Frequently Used Design time Components in OIC
  1. Connections – We need to create Connections by using the Adapters available. Adapters are available for SFTP, ATP Databases (for connecting to Cloud Autonomous Data Waterhouse ADW Database), Salesforce, Workday, Miscrosoft Outlook, Local Databases, Local File Servers, SOAP, REST, Oracle SaaS Applications etc.
  2. Agents – Agents are used by OIC to connect to on-prem entities such as a local database or a local file server (not FTP/SFTP).
  3. Lookups – They are like SOA’s Domain Value Mappings or in simple terms “KEY-VALUE” pairs. We define a lookup say COUNTRY LOOKUP with the values:

US – United States; UK – United Kingdom; IN – India

In the integration, we would invoke look up with the key, say US and get the value United States. Lookups are very handy when migrating integrations from one environment to the other where the values will keep changing. So all such dynamic values will be maintained in the Lookups and referred to in the integration and no need to make changes in the integration post migration.

4. Integration – Now this is the main component i.e. the Integration itself. It will be covered in the next blog.

Understand Integration as the main process that does the fetch, transform, mapping and data transfer between source & mapping.

The next blogs will cover topics which will include

  •    Integration Build
  •    Integration Design Patterns
  •    Fault Handling
  •    Use-Cases in Industry – Use SFTP, SOAP, REST, ATP Adapter connections to integrate applications, understand how to invoke Oracle SaaS (HCM/Financials) FBDI/HDL and load data, understand how to kick of ESS programs in SaaS from OIC, understand how to launch BI Publisher Reports in SaaS and extract data to OIC.
  •    Migration of OIC components from one instance to other

This is just a draft article that is put together to explain OIC – about which a lot of stuff is present on the web in cryptic language .The main intent behind this was to explain OIC in a language that is easier to understand.

If you would like to know more about OIC,feel free to Contact Us.

 

About the Author 

Bipul Shukla is the lead integration architect at Fusion Practices working on technologies.He has been working on Oracle Integration Cloud (OIC) since a year ago and in the past 12 months has gained a lot of knowledge on the subject.

 

IFRS 17

by Rochelle Cunningham Rochelle Cunningham No Comments

 

IFRS 17

  •    Background Information
  •    Why is IFRS 17 replacing something that already exists?
  •    What are the major changes that will happen in IFRS 17
  •    Models which IFRS 17 will make use of
  •          Building Block Approach (BBA)
  •          Premium Application Approach (PAA)
  •          Variable Fee Approach (VFA)
  •    How will it affect you?

 You have to know accounting . Its the language of Practical Business Life. It was a very useful thing to deliver to civilisation.

                                                                                                                                                               

Background Information

International Accounting Standards Board (IASB) which has been around for a few years (since 01 April 2001) has set to replace International Financial Reporting Standard 4 more commonly referred to as IFRS 4 with IFRS 17.

It is a common practise that insurance companies collect money upfront and earn it during the lifecycle of the policy. For example, an insurance company may receive a premium of the annual car insurance policy at the start of the policy, but that is reflected in their General Ledger during the duration of the policy contract. However, the claims will be normally posted as they occur leading to fluctuations in profit reporting when claims are suddenly reported. Depending on the type of insurance product, claims occur at different times, and therefore it is hard to trust the profitability of the insurance company at any point in time because profits can have wild swings. The purpose of IFRS 17 is to smoothen this out and present health of the company and the risks from insurance cover consistently in General Ledger.

If you are new to the way of how the International Accounting Standard Board works, let me help you with it. Each number specified by IFRS deals with a unique sector. With all the talk going around about IFRS 17, what exactly does this number represent? IFRS 17 is set to deal with Insurance Contracts and the way organizations operate them and the way customers view it.L et me take this moment to emphasis on that fact that it is only for Insurance Contracts and it does not affect any other sector like Assets Management, Leases or Foreign Exchange Rates to name a few.

 IFRS 17 Timeline

                             Timeline to Show the Evolution of IFRS 4 and IFRS 17

Initially, when IFRS 17 standards came out in 2017, most organizations had to make a lot of changes to deal with the new standard being put into place. This sparked a lot of conversation and after a fair amount of debate and spectacle, the implementation of IFRS 17 got delayed and was set to be implemented on 01 January 2021. But upon further thought and discussion, it is delayed by another year and is set to come into effect on 01 January 2022.

Why is IFRS 4 being replaced by IFRS 17?

IFRS 4 the already existing system is an interim standard. This allows organizations to continue to apply accounting policies and practices that existed preceding to the time that an organization adopted International Financial Reporting Standards(IFRS). Many of those accounting policies result in the lack of useful information and hampers the understanding of how an organization is performing.

The existing accounting policies result in the lack of transparency about profitability. This allows for a myriad of different accounting policies even within insurances resulting in a lack of comparability. It is often very hard to understand how profit is earned from different insurance contracts. IFRS 4 imparts an exclusion to the requirement that IFRS prefers which are required to have consistent accounting policies.

In order to overcome these concerns, IFRS 17 is set to replace IFRS 4. IFRS 17 provides a robust standard for accounting policies thereby reducing the lack of comparability. IFRS 17 is set to be the first harmonized accounting model for insurance contracts.

About Fusion Practices – We have been advising our clients in the insurance sector on how they can restructure their General Ledger, especially those in Oracle EBS and Fusion Cloud ERP, allowing them to make the transition to IFRS 17 much easier.

What are the major changes that will happen in IFRS 17?

The central change that IFRS 17 will bring about includes complex fundamental changes to accounting in:

  •      Liability Measurement and
  •      Profitability Recognition for Insurance Contracts.

Presentation in the statement of financial performances

One of the changes that IFRS 17 will bring is a way in which the Statement of Financial Performance is presented. The organisation will have to separate the sum recognised in the statement of financial performance into

  •      Insurance Service Result,
  •      Comprising Insurance Revenue and Insurance Service Expenses,
  •      and Insurance Finance Income or Expenses.

Income or expenses from Reinsurance Contracts which are held should be presented independently from the income or expenses from Insurance Contracts which are issued.

An organisation should present all the mentioned in their Profit or Loss Statement

  •      Revenue that is surfacing from the groups of insurance contracts issued,
  •      Insurance service expenses surfacing from a group of insurance contracts it issues, comprising incurred claims and other incurred insurance service expenses.

Both Revenue and Insurance Service Expenses should not hold any investment components.

Models which IFRS 17 will make use of

There are 3 models for different contract types which IFRS 17 will have to make use of. They can be broadly classified as

  •            Building Block Approach (BBA)
  •            Premium Application Approach (PAA) and
  •            Variable Fee Approach (VFA)

Building Block Approach

Building Block Approach or BBA is a default model for liability calculation for insurance contracts. One key component is the Central Service Margin (CSM) calculation which is suspected profit. It’s done at the inception of the contract.

Since Building Block Approach is said to be the default and the most common approach to be made use of, let’s delve into it a little deeper for better comprehension.

Building Block Approach(BBA)

When there is a new entry in the insurance contract the Organization will have to make an estimate of all the cash flows that can be expected to be received and expected to pay over the coverage period.

  •     Initially, the organization records all future cash inflows such as insurance premiums.
  •     They then deduct all estimated future outflows such as claims administration and acquisition expenses.
  •     After which the cash flows will be discounted to their present value.
  •     This is where IFRS 17 comes in to play a major part and applies a risk adjustment which basically represents compensation for the risks taken by the policyholders.
  •     These steps represent the fulfilment cash flows that are fulfilling any organizations moral imperative to their customers.
  •     The final step is the contractual service margin or CSM. The CSM reflects the profit that the organization expects to earn over the lifetime of contracts.

IFRS 17 does not allow the organization to acknowledge any of the profit when they issue the contracts but instead allows the organization to acknowledge it slice by slice as they realize their promises to their policyholders. Over time this represents the organization’s profit for the period, assembling estimates of all the cash inflows and outflows.

This requires the said organization to look much ahead of their time and into the future, particularly for any long duration insurance business. At each reporting date, the updates must be made of all the estimates they have derived. These updates may also have an influence on the profit that the organization expects to earn from the contracts.

The predominant changes and the organization’s financials, on one hand, is to act as a guide that the profit is based on current measurements and will acknowledge it as and when the organization provides Insurance Services to the customers. On the other hand you as a customer you will be able to find the Contractual Service Margin in the Balance Sheet evaluating the future profits the organization anticipates to make from the core Business Insurance Contracts.

The CSM during the coverage period total liability has two components.

Liability for remaining coverage exists since the cash flows at the beginning of the period has not been earned. This could imply that insurer has not yet been released from risk.

The cash flow is of time value and it’s risk adjustments are considered as a liability. Liability for incurred claims refers to unpaid claims for insured events that have happened. Insurers are not consistently mindful of every incurred claim at the current accounting period. This being as the primary reason liability is calculated as a risk-adjusted discounted cash flow.

The building blocks which are a major part of BBA are handled differently during profit recognition. Changes that occur in cash flows and risk adjustments associated with future services are recognized by finetuning CSM Amortization, while those which are associated to the past and current services flowing to Profit and Loss statement. The facts of changes in Discount Rates can be recognizing other comprehensive income or going through the Profit and Loss statement.

Why is all this important? Knowing the principles and advantages of IFRS 17 means being able to understand and communicate the financial strength of the organisation. In addition, this change will increase the transparency of any organization’s financials making the value that they create for the customers and shareholders more apparent.

Premium Application Approach

In IFRS 17 a substitute simpler model named Premium Allocation Approach or PPA can be used for some short term contracts. Short term contracts can be those which are less than a year in calculating pre-claims liability. Premiums received on the first day or unearned premium component coupled with the upfront acquisition cost component are documented as a current liability and a cash fragment in the asset. This is because the coverage period is yet to be fulfilled and the premium has not actually been obtained till date.

As insurers are cautiously detached from risk, as time passes by, the unearned premium moves from liability into the revenue account.

Premium Allocation Approach is a much more straightforward model in comparison to Variable Fee Approach(VFA) and can be made use of for Short Term General Insurance or any Particular Group Contract.

Variable Fee Approach

The Variable Fee Approach (VFA) is an alternative form of the Building Block Approach(BBA). It pertains to with-profit contracts,unit-linked contracts, active index-linked contrast and other similar contracts. These contract are mainly Life Contracts and Pension Contracts. Fund from investors are invested into a mixture of contracts to average out the forever fluctuating market so that it always provides a continuous and straightforward return. A reasonable share of returns from these items are paid out for these contracts.

How will IFRS 17 affect you?

This is a burning question that needs to be answered and if left unanswered would just be unacceptable.

Firstly if you are an Insurance Organization, let’s start with you.

Replacing the already existing IFRS 4 with IFRS 17 can demand a lot of work from your side. So much of work that even the way you present you P&L Statement will have to be amended. But as the saying goes there are two sides to every coin, this will make the working of your entire organization transparent and will aid in gaining customers trust and loyalty. Profit will not be visible at the beginning but will be gained over a period of time in fractions as and when you fulfil your promises towards your customers. Now, this can be a drawn affair but the chief reason it works for you is that you keep your customers happy throughout the entire process of having them with you.

P&L Statement

You may think, not everyone can be a part of an Insurance Organization but even as a customer you tend to play a major part in the Organisation.IFRS 17 holds huge benefits for you as a customer. The whole purpose of replacing IFRS 4 with IFRS 17 is to make the entire system transparent. This means that comparing different organizations has become simple and will be hassle-free.

With the changes that are to be implemented and the way the Profit and Loss Statements are to be presented,understanding of the Organisations financial strength will be effortless for you as a customer.

The most important thing to look at when choosing any Insurance company is their Claims Service and the Profit and Loss Statement.