integrate Oracle ERP Cloud general ledger (GL) data using the Oracle Integration Cloud (OIC) adapter

## Overview

To integrate Oracle ERP Cloud general ledger (GL) data using the Oracle Integration Cloud (OIC) adapter, follow these key steps:

1. Create OIC Connection to Oracle ERP Cloud:

- Create a new connection to your Oracle ERP Cloud instance in the OIC console.

- Configure the connection with your ERP Cloud instance URL, username, and password.

- Test the connection to ensure it is working correctly.

2. Create OIC Integration Flow:

- In the OIC console, create a new integration flow.

- Add the Oracle ERP Cloud adapter as the trigger (source) and configure it to fetch GL data.

- Configure the adapter with the appropriate GL parameters such as ledger, period, and account.

- Add a target adapter (e.g., database, file storage) to receive the GL data.

- Map the GL data fields from the source to the target.

3. Configure GL Data Fetch:

- In the ERP Cloud adapter configuration, select the appropriate GL data to fetch:

- Ledger

- GL Account

- GL Period

- Additional filters as needed

- Optionally, you can configure the adapter to fetch data incrementally based on the last processed date.

4. Customize Mapping and Transformation:

- Map the GL data fields from the ERP Cloud adapter to the target adapter.

- Apply any necessary data transformations, calculations, or enrichment within the integration flow.

5. Test and Deploy Integration:

- Test the integration flow with sample data to ensure it works as expected.

- Deploy the integration flow to the production environment.

Here's some sample code to get you started with the Oracle ERP Cloud adapter configuration in OIC:

```XML

<?xml version="1.0" encoding="UTF-8"?>

<configurations>

<configuration>

<properties>

<property name="username">your_erp_cloud_username</property>

<property name="password">your_erp_cloud_password</property>

<property name="endpoint">https://your-erp-cloud-instance.com</property>

<property name="ledger">your_ledger_name</property>

<property name="glPeriod">your_gl_period</property>

<property name="account">your_gl_account</property>

</properties>

</configuration>

</configurations>

```

Remember to replace the placeholders with your actual Oracle ERP Cloud instance details and the GL data you want to fetch.

Let me know if you have any other questions!