1. Import Purchase Orders from Oracle ERP Cloud to Microsoft SQL Server
  2. Activate and Run the Recipe

4 Activate and Run the Recipe

After you've configured the connections and other resources, you can activate and run the recipe.

  1. In the project workspace, click Activate. In the Activate project panel, with the default project deployment selected, choose an appropriate tracing option, then click Activate.

    A message confirms that the integration has been activated. Refresh the page to view the updated status of the integration.

  2. Run the recipe.
    Create a purchase order in Oracle ERP Cloud.
    1. Log in to your Oracle ERP Cloud instance with the Sales User role.
    2. Click Procurement, then Purchase Orders, and then Tasks.
    3. Under Orders, click Create Order.
    4. In the Create Order window, specify the details of the purchase order and click Create.
    5. Further, add line items to the purchase order and click Submit.
    You've now successfully triggered the recipe.
  3. Monitor the running of the integration flow in Oracle Integration.
    1. In the project workspace, click Observe. You'll see the integration flow being triggered and running successfully.
    2. To manage errors in your project, see Manage Errors in a Project.
  4. Log in to the Microsoft SQL Server Management Studio and verify if the purchase order details and associated customer data are populated in the database tables.

    In SQL Server Object Explorer, right-click any of the tables you created earlier and select View Data.

Related Documentation