Automating ERP Purchase Order Creation Using Oracle Integration Cloud

Oracle Integration Cloud (OIC) is a business process management software that helps companies manage and integrate various aspects of their operations, including financials, supply chain, reporting, manufacturing, and human resource activities. In this article, we will explore how to automate the creation of purchase orders using OIC.

To achieve this use-case, we will be using Oracle ERP adapter in Oracle Integration Cloud. The first step is to create a REST connection as a trigger point in the Integration Canvas.

Step-by-Step Procedure

1. Create an App Driven Orchestration with the name 'PurchaseOrderService'.

2. Drop the REST connection as a trigger point on the Integration Canvas.

3. Subscribe to Oracle ERP business events using the OIC ERP adapter.

4. Call the Create Purchase Order and Get Purchase Order services using the OIC ERP adapter.

Configuring the Endpoints

To create a purchase order, you need to know the relative endpoint's relative resource URI. This is used to create the purchase order request. The relative resource URI is used in conjunction with the base URL of your Oracle Integration Cloud instance to form the complete URL for the request.

For example, if your base URL is `https://your-instance-id.ocp.oraclecloud.com`, and your relative endpoint's relative resource URI is `/PurchaseOrderService/CreatePurchaseOrder`, then your complete URL would be `https://your-instance-id.ocp.oraclecloud.com/PurchaseOrderService/CreatePurchaseOrder`.

Creating the Purchase Order

To create a purchase order, you can use the Create Purchase Order service provided by Oracle ERP adapter. This service allows you to create a new purchase order with the required details.

For example, you can pass the following parameters to the service:

* `PurchaseOrderId`: The ID of the new purchase order.

* `VendorId`: The ID of the vendor for whom you are creating the purchase order.

* `OrderDate`: The date on which the purchase order is being created.

* `TotalAmount`: The total amount of the purchase order.

Getting Purchase Order Details

Once a purchase order has been created, you can use the Get Purchase Order service to retrieve details about the purchase order. This service allows you to retrieve information such as the purchase order ID, vendor ID, order date, and total amount.

For example, you can pass the following parameters to the service:

* `PurchaseOrderId`: The ID of the purchase order for which you want to retrieve details.

In this article, we have seen how to automate ERP Purchase Order creation using Oracle Integration Cloud. We have used Oracle ERP adapter to connect to ERP and exposed a single REST API to create a purchase order and get purchase order details. This is just one example of how OIC can be used to automate business processes.

Subscribe to Our Channel

If you want to learn more about Oracle Integration Cloud and other use-cases, please subscribe to our YouTube channel for the latest videos.

Postman app events bus requester