High-Level Specification

Functional Overview

The objective of this integration is to establish a robust middleware process that facilitates the automated transmission of Currency Exchange Rate Master data from SAP ECC(PRS, PF2-050) to the Icertis Contract Intelligence(ICI) platform. The integration ensures that Icertis always has up-to date currency and exchange-rate information essential for contract calculations and validations. This process performs the following functions.

• Receives currency and exchange-rate data from SAP ECC (PRS, PF2-050) through the ERP-110 Interface.
• Maps and transforms the data to align with the structural and validation requirements of the Icertis APIs.
• Orchestrates the end-to-end data flow, including transmission, response handling and error management.

This integration is triggered daily through a scheduled job to ensure that Icertis consistently receives the most recent exchange-rate information required for contract evaluation and processing.

Scope and Objectives

• Scope:
  This request covers the end-to-end integration logic required to transform, and create/update currency exchange rate data from SAP ECC(PRS, PF2-050) to Icertis.
• Objectives:
  • Automate the transfer of currency/exchange rate data.
  • Ensure data is mapped to Icertis API specifications.
  • Handle exceptions and retries for robust data delivery.
  • This interface fills the gap by providing custom mapping and orchestration between  SAP ECC(PRS, PF2-050) and Icertis for Currency Exchange Rate.

Process Flow Diagram

Assumptions

• SAP ECC(PRS, PF2-050) provides clean, validated currency/exchange rate data.
• Icertis APIs are available and documented for currency master data ingestion.
• Middleware platform supports secure API calls, error handling, and logging.
• Performance requirements are met (e.g., data transfer completes within batch window).

Dependencies

• Availability of ERP-110 (Source system interface) and ERP-290 (Target system interface).
• Timely updates to currency/exchange rate data in SAP ECC(PRS, PF2-050) .
• Coordination with SAP and Icertis teams for API changes or enhancements.
• Batch job execution in SAP ECC(PRS, PF2-050).

Security, Integrity and Controls

• Secure authentication for middleware to access Syniti and ICertis (API keys, certificates).
• Audit logging for all integration transactions.

Configuration Requirements

• API endpoints and credentials for Icertis.
• Data mapping rules in CPI and Icertis (currency codes, exchange rate formats).
• Error handling and retry parameters.
• Logging and monitoring setup.

Design Rationale

This interface is designed to facilitate seamless integration between Syniti (source) and Icertis (target) for currency/exchange rate master data. The middleware orchestrates the data flow, ensuring mapping, transformation, and reliable delivery

Data Structure

The following fields will be used to provide the required data structure of the interface:

Requested Sample (Extract from SAP ECC):

 Currency conversion file generated as per ERP-110 Currency Conversion into Ariba .FS should be re-used for Icertis as well. CPI will filter out the EUR conversion rate.

 Transformation in CPI (Icertis required format):

Processing Logic

• Inbound Trigger

  • CPI receives the currency exchange rate data file from SAP ECC(PRS, PF2-050).

• Data Validation

  • If any record fails validation, CPI rejects the entire batch and sends an error notification to the Integration support.

• Transformation

  • CPI applies any required transformation rules:
    • Maps source field names/formats to the target structure required by Icertis

• Routing

  • CPI routes the validated data to the next integration step (e.g., prepares payload for Icertis Business API).
  • Ensures secure transmission (e.g., via HTTPS, OAuth2).

• Error Handling

  • If any error occurs during processing (validation, transformation, routing), CPI logs the error, stops the process, and sends an alert to the Integration support team.
  • No partial loads—either the entire batch is processed successfully, or it is rejected.

• Monitoring & Logging

  • CPI maintains detailed logs for each integration run.
  • Job status, error details, and audit trails are available on the CPI monitoring dashboard.
  • Email alerts are sent for failures.

Delta or Full Load Requirements

• Full Load:
  • The interface always pushes the complete set of exchange rates for all supported currencies.
  • No delta tracking is required since the data is refreshed daily.

Language Requirements

• No multilingual support required for exchange rate data.
• All fields are numeric or standard ISO codes.

User Interface Requirements

Not Applicable

Volumetrics

• Daily load of 70 currency pairs to be created/updated in bulk
• The first load will create the currency exchange masterdata
• Subsequent loads will update the existing currency exchange masterdata

Performance Consideration

Scheduling and Execution Window

• The integration job should be scheduled during off-peak hours (e.g., early morning) to avoid contention with other system processes.

Error Handling

1. Validation Errors

• Cause: Missing mandatory fields, invalid currency codes, negative exchange rates.
• Handling:
  • Reject the whole batch.
  • Log the error with detailed message.
  • Notify integration support team via email or dashboard.
  • Continue processing remaining records.

2. API Failures

• Cause: Icertis Business API is unavailable, authentication failure, timeout.
• Handling:
  • If retries fail, log the failure and raise an alert.
  • Notify support team with error code and timestamp.

3. Data Load Failures

• Cause: Payload formatting issues, bulk upsert failure.
• Handling:
  • Validate payload structure before submission.
  • Use staging logs to identify failed records.
  • Allow manual reprocessing of failed records.

4. Partial Success

• Cause: Some records succeed, others fail due to validation or API issues.
• Handling:
  • Reject the whole record and notify the admin team on failure

5. Monitoring and Alerts

• Tools: Integration monitoring dashboard, email notifications, log files.
• Recipients: Integration support team, business operations team.
• Alert Types:
  • Job failure

 Interface Alert & Monitoring

• Alerts should be configured for:
  • API failures
  • Validation errors
• Monitoring tools (middleware logs) should notify:
  • Integration support team
  • Business users (email)
• Retry logic should be in place for transient failures.

Testing

Test Conditions and Expected Results

Test Considerations/Dependencies

Development Details

Package

Other Development Objects

Appendix

Sample payload:

{
    "Data": {
        "JobItems": [
            {
                "SysId": "96c08d87-3c89-4b7d-b075-e360bb41db07",
                "UseExternalId": "false",
                "NextState": "",
                "EndPointVersion": "3",
                "RequestIdentifier": "1",
                "RequestBody": {
                    "ICMFromCurrency": "INR",
                    "ICMRate": "0.0094",
                    "Name": "INR:EUR",
                    "ICMToCurrency": "EUR"
                }
            },
            {
                "SysId": "5449222c-3d3a-4044-baae-a17165381ed1",
                "UseExternalId": "false",
                "NextState": "",
                "EndPointVersion": "3",
                "RequestIdentifier": "2",
                "RequestBody": {
                    "ICMFromCurrency": "AUD",
                    "ICMRate": "0.54",
                    "Name": "AUD:EUR",
                    "ICMToCurrency": "EUR"
                }
            }
        ],
        "HasMoreData": "false",
        "ContractTypeName": "ICMCurrencyExchangeRate"
    }
}

See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log