OIPA DATAINTAKE Guide

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

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.