Create Suppliers in SAP Ariba for Vendors in SAP ERP

Create Suppliers in SAP Ariba for Vendors in SAP ERP

Use this recipe to create corresponding supplier records in SAP Ariba when vendor records are created in SAP ERP.

Note: 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 is an application-driven recipe that creates a supplier in SAP Ariba whenever a vendor is created in SAP ERP.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package. When a vendor record is created in the SAP ERP instance, the integration flow of the recipe is triggered, and it creates a corresponding supplier record in SAP Ariba. Basic data, such as contact, contact ID, email address, fax, name, and postal address, are synchronized between the SAP ERP and SAP Ariba platforms.

System and Access Requirements

Before You Install the Recipe

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

Configure SAP ERP

To configure SAP ERP, see Prerequisites for Creating a Connection.

Configure SAP Ariba

To configure SAP Ariba, see Complete Ariba SOAP Web Services Prerequisites.

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 SAP ERP Connection

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

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

  3. In the Connection Properties section, upload the JCO connection properties file.

    You must upload the following type of JCO file:

    • Adapter inbound properties file: To configure the SAP Adapter for both trigger and invoke connections (for example, the Adapter_inbound_Direct.properties file).
  4. In the Security section, enter the username and password to connect to the SAP ERP instance.

  5. In the Agent Group section, configure an agent group for accessing the service hosted on your premises behind the firewall.

    1. Click Configure Agents. The Select an Agent Group page appears.

    2. Click the name of the agent group.

    3. Click Use.

    To configure an agent group, you must download and install the on-premises connectivity agent. See Download and Run the Connectivity Agent Installer.

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

  7. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A confirmation message is displayed if your test is successful.

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

Configure the Oracle SAP Ariba Connection

  1. On the Configuration Editor page, select Oracle SAP Ariba Connection, then click Edit Edit icon.
    The connection configuration page appears.

  2. In the Connection Properties section, enter the following details.

    Field Information to Enter
    Host Name Enter the SAP Ariba host name. To obtain the host name, see Configure SAP Ariba.
    Partition (Site Name) Enter the SAP Ariba partition.
  3. In the Security section, enter the following details.

    Field Information to Enter
    Security Policy Select Basic Authentication.
    Username Enter the username created on SAP Ariba during the endpoint configuration. See Configure SAP Ariba.
    Password Enter the password created on SAP Ariba during the endpoint configuration.
  4. Click Save. If prompted, click Save for a second time.

  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A confirmation message is displayed if your test is successful.

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

Configure the Lookup Table

Edit the lookup table, and 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_Name column, enter the property name as EmailTo.

  3. In the Property_Value column, enter an email ID of your choice.

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

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

Activate and Run the Recipe

After you’ve configured the connections and 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.

  2. Run the recipe.
    To run the recipe, you must perform the following tasks in the SAP ERP instance.

    1. Check the Oracle Integration connection status.

      1. In the tcode field, enter the following code: /nsmgw, and then click Enter.

      2. Click Goto, then select Logged on Clients. A list of logged-on clients appears.

      3. In the list, check if the configured server address appears.

    2. Test the connection.

      1. In the tcode field, enter the following code: /nsm59, and then click Enter.

      2. From the list of RFC Connections, expand TCP/IP Connections, and find your program ID.

      3. Select the program ID, and click Connection Test.

    3. Push a vendor record to SAP ERP.

      1. In the tcode field, enter the following code: /nBD14, and then click Enter.

      2. Select a vendor account number.

        • In the Account Number field, click the Search icon Search icon. The Account Number window appears.

        • In the window, click Start Search Start Search icon, and select the required vendor record from the list of records displayed.

      3. Select the Message Type as CREMAS.

      4. Select the Target System.

      5. After you’ve configured the parameters, click Execute Execute icon to push the vendor record. An information dialog appears.

      6. In the dialog, click OK icon to continue. Click OK icon again, if prompted, to continue execution.

    4. Check the status of the execution.

      1. In the tcode field, enter the following tcode: /nwe02, and click Enter.

      2. In the IDoc List window, click Execute Execute icon to view the status.

      Note: Status 3 represents a successful execution, and Status 29 represents a failed execution.

  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.
      Whenever a vendor-create event is triggered in the SAP ERP instance, the recipe creates a corresponding supplier record in SAP Ariba.

  4. Log in to your SAP Ariba instance and check for the new supplier record created.

    1. On the SAP Ariba home page, click Home, then Common Actions, and then Core Administration.

    2. On the Administration tab, click Supplier Manager.

    3. In the Supplier Manager window, click Suppliers.

    4. Enter the contact information in the Contact field, and click Search.

    5. In the list of records displayed, find the required supplier record, and click its name to view it.

Related Documentation