About This Recipe

This recipe demonstrates how you can use the data mapper capabilities in Oracle Integration to transform standard data extracted from Oracle HCM Cloud into the data structure of an ANSI 834 benefits provider file.

To use the recipe, you must install the recipe and configure the connection and other resources within it. Subsequently, you can activate the integration flow of the recipe. When triggered, the integration flow of the recipe performs the following:

• Reads the Oracle HCM Cloud data extract file from an FTP server.
• Transforms and formats the extracted data using the Oracle Integration data mapper.
• Generates a valid ANSI 834 benefits provider file.
• Uploads and writes the ANSI 834 benefits provider file to the FTP server.

System and Access Requirements

• Oracle Integration, Version 24.04 or higher

• A secure FTP (sFTP) server

• An FTP client to access the sFTP server

• Oracle HCM Cloud

• An account on Oracle HCM Cloud with the Administrator role