Transform an Oracle HCM Cloud Extract File to an ANSI 834 Benefits File

Use this recipe to generate and format an ANSI 834 benefits provider input file, based on an Oracle HCM Cloud Extract file loaded from an FTP server.

Note:

This recipe is available as Oracle HCM Cloud — FTP Server | Export Benefits ANSI 834 in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

HCM users require the ability to synchronize HCM benefits data with third-party benefits providers. These providers often expect data to be published using the ANSI 834 EDI Enrollment Implementation Format, which is the standard file format in the United States for electronically exchanging health plan enrollment data between employers and health insurance carriers.

This recipe uses the data mapper capabilities of Oracle Integration to demonstrate how to transform a standard data extract from Oracle HCM Cloud into a Benefit Providers ANSI 834 data structure.

The integration uses Oracle Integration with an FTP server to complete the following actions:

Reads the HCM exported data.
Transforms and formats the file in Oracle Integration mapper.
Produces a valid ANSI 834 file.
Uploads the file to the FTP server.

For ease of setup, this recipe uses an FTP server to replicate the Oracle Fusion Cloud Human Capital Management instance. See the related documentation for details about how to use the Oracle HCM Cloud Adapter to retrieve files from an Oracle HCM Cloud instance via the HCM Extract tool.

Also, this recipe uses no encryption. In a production environment, it is critical that you encrypt data at every stage.

System and Access Requirements

Oracle Integration
FTP server

Install, Configure, and Run the Recipe

For more information and steps to install, configure, and run recipes, see Get Started with Integration Accelerators and Recipes.