Import Supplier Records from SAP S/4HANA to Oracle ERP Cloud

Import Supplier Records from SAP S/4HANA to Oracle ERP Cloud

Use this recipe to import supplier records from SAP S/4HANA to Oracle ERP Cloud.

Note: This recipe is available as SAP S/4HANA — Oracle ERP Cloud | Import Supplier Records in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe imports supplier records from SAP S/4HANA to Oracle ERP Cloud according to a schedule specified in Oracle Integration.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package. Subsequently, you can activate and run the integration flow of the package manually or specify an execution schedule for it. When triggered, the integration flow reads the supplier records from the SAP S/4HANA instance and, in turn, creates corresponding records in your Oracle ERP Cloud instance. SAP S/4HANA supplier records along with their associated data (such as name, alternate name, tax organization type, and business relationship type) are imported to Oracle ERP Cloud.

System and Access Requirements

Before You Install the Recipe

You must perform the following configuration tasks on your SAP S/4HANA and Oracle ERP Cloud instances in order to successfully connect to these external systems using Oracle Integration and transfer supplier records between them.

Configure SAP S/4HANA

To configure SAP S/4HANA, see Prerequisites for Creating a Connection.

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud instance from Oracle Integration, you’ll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.

  1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You’ll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.

  2. Assign the following roles to the user account. For more information on these roles, see Assign Required Roles to an Integration User.

    • Integration Specialist

    • Oracle ERP Cloud-specific data access to the integration user

Install and Configure the Recipe

On your Oracle Integration instance, install the recipe package to deploy and configure the integration and associated resources.

  1. On the Oracle Integration home page, scroll to the Accelerators & Recipes section.

  2. Click Search All.

  3. Find the recipe package that you want to install.

  4. Select the package, and then click the Install Install icon icon.

  5. After the package is installed, click the Configure Configure icon icon on the recipe card to configure the resources deployed by the package.

    The Configuration Editor page opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.

Configure the Oracle S/4HANA Connection

  1. On the Configuration Editor page, select Oracle S/4HANA Connection.

  2. Click Edit Edit icon.
    The connection configuration page appears.

  3. In the Connection Properties section, enter the host name of the SAP S/4HANA instance.

  4. In the Security section, enter the username and password of the Communication User created in the SAP S/4HANA instance. See Configure SAP S/4HANA.

  5. Click Save. If prompted, click Save for a second time.

  6. Click Test to ensure that your connection is successfully configured. A confirmation message is displayed if your test is successful.

  7. Click Back Back icon to return to the Configuration Editor page. Click Save again if prompted.

Configure the Oracle ERP Cloud Connection

  1. On the Configuration Editor page, select Oracle ERP Cloud Connection.

  2. Click Edit Edit icon.
    The connection configuration page appears.

  3. In the Connection Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.

  4. In the Security section, enter the following details.

    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.

  5. Click Save. If prompted, click Save for a second time.

  6. Click Test to ensure that your connection is successfully configured.
    A confirmation message is displayed if your test is successful.

  7. Click Back Back icon to return to the Configuration Editor page. Click Save again if prompted.

Configure the Lookup Table

Edit the lookup table to map SAP S/4HANA data fields to Oracle ERP Cloud fields. In addition, enter an email ID to receive error messages.

  1. On the Configuration Editor page, select the lookup table, and click Edit Edit icon.

  2. In the Property column, enter the field names of SAP S/4HANA.

  3. In the Value column, enter the corresponding field names of Oracle ERP Cloud, which are to be mapped to the S/4HANA fields.

  4. In the last row, enter EmailTo in the Property column, and enter an email ID of your choice in the Value column.

  5. Click Save. If prompted, click Save for a second time.

  6. Click Back Back icon to return to the Configuration Editor page.

Activate and Run the Recipe

After you’ve configured the connections and the lookup table, activate the recipe package and run it.

  1. On the Configuration Editor page, click Activate in the title bar. In the Activate Package dialog, click Activate again.
    A confirmation message is displayed informing that the integration has been submitted for activation. Refresh the page to view the updated status of the integration.

    Note: The recipe’s integration flow contains the following property:
    • RecordCount: This integration property defines the number of supplier records to be viewed in the SAP S/4HANA instance during the integration runtime.
      Optionally, you can add or update the value for this property after the integration flow has been activated. For the procedure to update integration properties, see Steps 7 to 9 in Override Design-Time Properties in an Integration.

  2. Run the recipe.

    1. On the Configuration Editor page, select the integration flow.

    2. Click Run Run icon, then click Submit Now.

    3. In the dialog that appears, click Confirm.
      The Schedule Parameters page is displayed, where you can specify a value for the lastRun parameter. This parameter stores the date and time of the most-recent successful run of the integration flow. The parameter’s value is automatically updated after each successful run, and only the S/4HANA supplier records created after the date-time stamp stored as parameter’s Current Value are processed by the integration in each run. If you want to change the date-time stamp for a specific scenario, enter the date and time of your choice in the New Value field in the format, yyyy-MM-dd HH:mm. To fetch all the supplier records from the beginning, set the value as zero.

    4. Click Submit on the Schedule Parameters page.
      You’ve now successfully submitted the integration for execution.

      Note: You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.

  3. Monitor the execution of the integration flow in Oracle Integration.

    1. On the Configuration Editor page, select the integration flow.

    2. Click Run Run icon, then click Track Instances.

    3. On the Track Instances page, you’ll see the integration flow of the recipe being triggered and executing successfully.
      The recipe now imports supplier records from SAP S/4HANA to Oracle ERP Cloud.

  4. Log in to your Oracle ERP Cloud instance and check for the new suppliers created.

    1. On the home page, click Menu Menu icon.

    2. From the list, under the Procurement section, click Suppliers.
      The list of suppliers is displayed, which contains the records imported from SAP S/4HANA.

Related Documentation