OIC High-Volume Data Transformation

Content

Hi,

We have a project for ERP Integrations (FBDI Import and Load) using Autonomous Integration Cloud.

For the GL Integrations, the expected flow is:
    1. Read the incoming file from the different source systems,
    2. Transform to FBDI format,
    3. Import and Load to ERP.

In the second step during transformation, we need to map the old COA (Chart of Accounts) values to new COA values.
These are the different options that we have:
    1. Store the values in a database (customer has MySQL on Cloud), get the values into OIC, transform incoming file to FBDI format.
    2. Store the values in lookup(s), get the values and transform incoming file to FBDI format.