Release Notes

November 2024

We have updated our sync strategy for the COMMODITY table. We now sync the table data using the commodities API endpoint.

We have added a new table, SUPPLIER_PREFERRED_COMMODITIES_MAPPING. The table stores the preferred commodities of a supplier.

October 2024

We now capture deletes for the parent tables. We use the _fivetran_deleted column to capture the deletes for these tables. To avoid longer sync times, we perform weekly incremental syncs on Saturdays to capture deletes.

September 2024

We have added the expense_line_id column as a part of the composite primary key in the EXPENSE_ATTENDEE table.

August 2024

We have identified and fixed a bug to prevent sync failures of the INVENTORY_TRANSACTION and CONTRACT_TEMPLATE tables. To sync the tables, update the core.contracts_template.read and core.inventory.transaction.read scopes in your Coupa OAuth Client. We are gradually rolling out this change to all existing connectors.

June 2024

We have added a new column, channel, to the INVOICE_HEADER table. Be sure to re-sync the INVOICE_HEADER table to backfill the historical data for this column or contact our support team to re-sync it for you.

January 2024

We have added a new table, BUDGET_LINE_ADJUSTMENT. Be sure to re-sync the connector to backfill the historical data or reach out to Fivetran Support to re-sync it for you.

December 2023

We have added two new tables, APPROVER and APPROVER_GROUP_USER_MAPPING, to store information about the users involved in the approval. Be sure to re-sync the connector to backfill the historical data or contact Fivetran Support to re-sync it for you.

October 2023

We have fixed a bug where we were facing delays in updating the records of the ORDER_HEADER table. We have updated our sync strategy and implemented a new weekly lookback window of 7 days to avoid data discrepancy issues of the ORDER_HEADER table.

June 2023

We have made the following changes to the INVOICE_LINE_ALLOCATION table:

Added a new column, invoice_header_id.
Changed the primary key of the table. The new composite key is a combination of the following columns:
- id
- invoice_header_id
- invoice_line_id

Be sure to re-sync the table for the latest changes or contact our support team to re-sync it for you.

We have renamed the savings-pact column of the CONTRACT table to savings-pct. Be sure to re-sync the table for the latest changes or contact our support team to re-sync it for you.

March 2023

We have added a new table, SUPPLIER_ITEM. We are gradually rolling out this change to all existing connectors.

November 2022

We have fixed a bug in our Coupa connectors that use OAuth2.0 authentication, where we didn't sync the INVENTORY_TRANSACTION table. To sync the INVENTORY_TRANSACTION table, select the following read scopes for the Client ID when configuring the connector:

core.inventory.transfer.read
core.inventory.consumption.read
core.inventory.adjustment.read
core.inventory.return_to_supplier.read

For existing connectors using OAuth2.0, go to your Coupa portal and add the above scopes to your Client ID.

October 2022

We have fixed a bug in our Coupa connectors that use OAuth2.0 authentication where we didn't sync a few tables.

To sync these tables, select the following read scopes for the Client ID when configuring the connector:

core.easy_form_response.read
core.item.read
core.sourcing.read
core.sourcing.response.read
core.supplier.read

For existing connectors using OAuth2.0, go to your Coupa Portal and add the above scopes to your Client ID.

August 2022

We now support the OAuth 2.0 authentication. If you are using the API Key authentication, you need to migrate to OAuth 2.0 before December 1, 2022. You can migrate to OAuth 2.0 by editing the connection parameters and providing the Client ID and Client Secret instead of the API Key. See our Coupa Setup Guide for details about how to obtain them.

April 2022

We have added a new table, SUPPLIER_ADDRESS, that stores the supplier's address.

February 2022

We are deprecating the following tables:

EASY_FORM
EASY_FORM_WIDGET
EASY_FORM_WIDGET_RULE

January 2022

We have added the following new tables:

EASY_FORM_DATA
EASY_FORM_WIDGET_DATA
EASY_FORM_APPROVAL_MAPPING

We have linked the APPROVAL and EASY_FORM_DATA tables by adding the easy_form_id column as a foreign key in the APPROVAL table.

EASY_FORM_DATA is a child table of the USER table. To sync the EASY_FORM_DATA table, select it on the Schema tab in your Fivetran dashboard and re-sync the USER table.

May 2021

Our Coupa connector is now generally available.

Read our Coupa connector documentation.

We have added a new column, custom_fields, to all the tables except the mapping tables (tables whose names end with the _MAPPING suffix). We will sync the custom fields as JSON objects.

April 2021

We have added two new tables, EXPENSE_LINE_DAILY_PER_DIEM and PER_DIEM_DEDUCTION.

We have renamed the EASYFORM_WIDGET_RULE table to EASY_FORM_WIDGET_RULE.

We have added a new column, custom_fields, to the following tables to sync custom fields as JSON objects:

USER
ORDER_HEADER
INVOICE_HEADER
INVOICE_LINE

We will deprecate the following columns from the USER table after July 30, 2021:

custom_fields_costCenter
custom_fields_dadsArea
custom_fields_dadsDistrict
custom_fields_dadsDivision
custom_fields_dadsStore
custom_fields_division
custom_fields_endDate
custom_fields_orgUnitNName
custom_fields_region

Be sure to update your queries before we deprecate the columns.

March 2021

We have fixed a bug where the attributes of the EXPENSE_MILEAGE_VEHICLE_TYPE table were added to the separate EXPENSE_TRIP_MILEAGE table. We no longer add the attributes of the EXPENSE_MILEAGE_VEHICLE_TYPE table to the EXPENSE_TRIP_MILEAGE table.

We have renamed the following tables in the Schema tab of your connector details page to align them with the source table names:

CHARGES to CHARGE
PROJECT_BUSINESS_GROUP_RELATION to PROJECT_BUSINESS_GROUP_MAPPING
PROJECT_USER_RELATION to PROJECT_USER_MAPPING
SHIPPING_TERM_BUSINESS_GROUP_RELATION to SHIPPING_TERM_BUSINESS_GROUP_MAPPING
UOM to UNIT_OF_MEASURE

These name changes will not impact your destination tables.

February 2021

Coupa is a cloud platform for business spend management.

Read our Coupa connector documentation.