Introduction

This document describes the solution proposed by Oracle Insurance for importing and processing files that are received by an insurance carrier from Group Customers.

Customer Support

If you have any questions about the installation or use of our products, please visit the My Oracle Support

website: https://support.oracle.com or call (800) 223-1711.

Oracle customers have access to electronic support through My Oracle Support. For information, visit

http://www.oracle.com/us/corporate/accessibility/support/index.html#info or visit http://www.oracle.com/us/corporate/accessibility/support/index.html#trs if you are hearing impaired.

OIPA

OIPA is the Oracle Insurance Policy Administration system responsible for managing a carrier's insurance business. It is responsible for receiving a file and corresponding family records, and executing the file as a set of changes to entities in the system. OIPA performs the following Data Intake functions:

Pre-processes a file to determine if it can successfully be executed. This includes validating fields, calculating changes, and examining the file and its changes against acceptable thresholds.

If pre-processing is successful, OIPA will calculate the changes to the system for each of the family records for the file. Changes can include a net add, a net removal, or a net change to the sponsor / primary participant, the sponsor's employment information, sponsor's dependents, or coverage.

After processing a file, provides the ability to rollback a file, undoing all of the changes for all of the family records that were processed for that file. OIPA will only allow one file at a time to be backed out for a Group Customer.

OIPA Grid

Note: The Data Intake capability in OIPA is built into OIPA Cycle. Each node that is receiving requests and processing files will be an instance of a cycle agent with Data Intake enabled.

The OIPA Grid is a set of interconnected computing nodes that work together in order to process long and/or process intensive tasks in parallel. The Data-Intake solution uses the OIPA Grid for processing. The OIPA Grid supports the parallel, high volume execution of work across a grid of interconnected computing nodes. Each work item that is submitted to the OIPA Grid is called a Task. There are two kinds of tasks that are executed in the OIPA Grid:

A Resumable Task has the ability to execute for a long period of time, go through a sleep / wake process, report progress and return a result. There are typically very few Resumable Tasks running at the same time in the Grid.

A Runnable Task is a discrete unit of execution that executes in a short period of time, on a single thread in a single node in the compute grid. It cannot be suspended, report progress, or return a result. Runnable Tasks are isolated and can be executed in parallel. Runnable Tasks make up the volume of work that is executed in the Grid. While there may only be a handful of Resumable Tasks executing at one time in the Grid, there may be thousands or millions of Runnable Tasks executing at the same time.