Oracle ERP Cloud Adapter Capabilities

The Oracle ERP Cloud Adapter enables you to create an integration with Oracle Enterprise Resource Planning (ERP) applications.

Note:

Ensure that you have reviewed the Oracle HCM Cloud Adapter Capabilities for supported SOAP services in Oracle HCM Cloud.
The Oracle ERP Cloud Adapter enables you to easily integrate on-premises or SaaS applications with Oracle ERP Cloud without having to know about the specific details involved in the integration. The Oracle ERP Cloud Adapter provides the following benefits:
  • Integrates easily with the Oracle ERP Cloud application’s WSDL file to produce a simplified, integration-centric WSDL.

  • Generates automatic mapping to the exposed business object or event subscription that you select during adapter configuration:
    • Business object: Represents a self-contained business document that can be acted upon by the integration. An integration can send requests to create a new record for that business object. They can send a request either to update or delete an existing record for a business object. Integrations can also send requests to retrieve information about one or more records representing that business object.

    • Event subscription: Represents an event document to which you subscribe. The event subscription is raised by the Oracle ERP Cloud application. The product inventory module (PIM) exposes public APIs and events in release 11 and release 12 for Oracle ERP Cloud. See Supported Business Events.

  • Automatically handles security policy details required to connect to the Oracle ERP Cloud application.

  • Provides standard error handling capabilities.

  • Exposes Supply Chain Management (SCM) Cloud events and web services.

  • Enables you to upload a file to a secure FTP location. The file is identified and provided to Oracle ERP Cloud so that the data can be uploaded in the Oracle ERP Cloud business tables. In the invoke (outbound to Oracle ERP Cloud) direction, files can be uploaded in the following formats:
    • BASE64 format: Files uploaded in this format are embedded in the SOAP message.

    • MTOM format: This is the default upload format. Files uploaded in this format are sent as an attachment in the SOAP message. If there are errors during MTOM upload, the file is uploaded in BASE64 format.

    As a part of the file upload configuration process in the invoke direction (outbound to Oracle ERP Cloud), you specify the integration name, identifier, and version details to receive a callback. The callback provides detailed status about the outbound request. The inbound integration flow handles the callbacks from Oracle ERP Cloud. When the callback response is received, the log files can be downloaded in BASE64 format or the default MTOM format. If there is any error during MTOM download, the file is downloaded in BASE64 format.

    During runtime, the Oracle ERP Cloud file upload occurs:

    • The file is picked up.

    • In the invoke (outbound to Oracle ERP Cloud) direction, Oracle ERP Cloud receives the file as an attachment object.

    • The file is first uploaded in MTOM format to UCM. After uploading the document to UCM, a request is sent to Oracle ERP Cloud to process the file.

    • If the document upload to MTOM fails, the file is uploaded in BASE64 format by providing the files as BASE64 content directly to Oracle ERP Cloud.

    • Oracle ERP Cloud Adapter invokes the importBulkData API and provides the information configured during the design time.

      Note:

      Create the UCM URL by appending the host and port of the service catalog with the following URI: /idcws/GenericSoapPort.

    During runtime, the callback is received.

    • ERP sends the callback on the callback endpoint.

    • The callback contains the following information:

      • Overall status.

      • Document ID of the file that contains all the log data.

      • List of all jobs, their child jobs, and their statuses.

    • The file is first downloaded in MTOM format. If the download fails, the file is downloaded in BASE64 format.

    • The file is stored in the attachment store. The reference of the file is provided as an output in the XML document.

Note:

  • During bidirectional account and contact synchronization, echoes are generated. Oracle Integration Cloud Service-based integrations use echo suppression to prevent unwanted update or create events (the echoes) from returning to the source application.

  • You cannot write database SQL queries with the Oracle ERP Cloud Adapter. Instead, you must write a Business Intelligence Publisher (BIP) report in Oracle Fusion Applications and invoke it from the Oracle ERP Cloud Adapter. See this blog.

Supported Business Events

The following business events are supported. You can subscribe to these events during adapter configuration in the Adapter Endpoint Configuration Wizard.

Cloud Product Supported Business Events Description First Release Available Callback Service
Inventory Management

Advance Shipment Notice

Signals that an advance shipment notice can be sent to an external customer for the shipment.

R12

SOAP Service: ShipmentService

Operation: getAdvancedShipmentNoticeData

Inventory Management

ASN Cancellation

Notifies that an ASN/ASBN line has been cancelled in Oracle Fusion Receiving Cloud.

R13 18B

SOAP Service: InboundShipmentService

Operation: findShipment

Inventory Management

ASN Creation

Notifies that an ASN/ASBN line has been created in Oracle Fusion Receiving Cloud.

R11

SOAP Service: InboundShipmentService

Operation: findShipment

Inventory Management

Backorder Line

Signals that a shipment line has been back ordered.

R13 17B

SOAP Service: ShipmentLineService

Operation: GetBackorderLineData

Inventory Management

Create Correction Transaction

Notifies that a correction transaction is created in Oracle Fusion Receiving Cloud.

R11

SOAP Service: ReceivingTransactionService

Operation: findTransaction

Inventory Management

Create Deliver Transaction

Notifies that a deliver transaction is created in Oracle Fusion Receiving Cloud.

R11

SOAP Service: ReceivingTransactionService

Operation: findTransaction

Inventory Management

Create Receiving Receipt

Notifies that a receipt is created in Oracle Fusion Receiving Cloud.

R11

SOAP Service: ReceiptService

Operation: findReceipt

Inventory Management

Create Return Transaction

Notifies that a return (to supplier, customer, organization) transaction is created in Oracle Fusion Receiving Cloud.

R11

SOAP Service: ReceivingTransactionService

Operation: findTransaction

Inventory Management

Manifest Request

Signals that shipment information can be sent to the carrier manifesting system to determine rate, freight cost, and labels for the shipment.

R11

SOAP Service: Shipment Service

Operation: getManifestRequestData

Inventory Management

Receipt Advice Event Notification

Notifies that a receipt advice is generated in Oracle Fusion Receiving Cloud and available for external systems to process.

R13 17B

SOAP Service: ReceiptAdviceService

Operation: getReceiptAdviceDetails

Inventory Management

Shipment Advice

Signals that the shipment is shipped and is ready for informing the source system with the shipped information.

R13 17B

SOAP Service: ShipmentService

Operation: getShipmentAdviceData

Inventory Management

Shipment Request Generate

Signals that shipment line selection criteria is published for external systems to process the lines.

R11

SOAP Service: ShipmentLineService

Operation: GenerateShipmentRequest

Inventory Management

Standard Cost Exported Event

Signals that a standard cost is exported for a scenario.

R13 17C

NA

Inventory Management

Standard Cost Published

Signals that the standard cost is published for a scenario.

R13 17C

NA
Inventory Management

Trade Screening Request

Signals to request trade screening for a shipment line.

R13 17B

SOAP Service: ShipmentLineService

Operation: getShipmentLineData

Inventory Management

Transfer Price Published

Signals that the transfer price is published for a sales order fulfillment line.

R13 17C

NA

Maintenance

Customer Asset Created

Signals that a customer asset is created.

R13 17C

SOAP Service: AssetService

Operation: getAsset

Maintenance

Customer Asset Relationship Created

Signals that a customer asset relationship is created.

R13 17C

SOAP Service: AssetRelationshipService

Operation: getAssetRelationship

Maintenance

Customer Asset Relationship Deleted

Signals that an asset relationship is deleted.

R13 17C

SOAP Service: AssetRelationshipService

Operation: getAssetRelationship

Maintenance

Customer Asset Updated

Signals that a customer asset is updated.

R13 17C

SOAP Service: AssetService

Operation: getAsset

Maintenance

Maintenance Asset Created

Signals that a maintenance asset is created.

R13 17D

SOAP Service: AssetService

Operation: getAsset

Maintenance

Maintenance Asset Updated

Signals that a maintenance asset is updated.

R13 17D

SOAP Service: AssetService

Operation: getAsset

Manufacturing

Print Product Label

Signals that a print product label is triggered

R13 18B

NA

Manufacturing

Work Order Create

Signals that a work order is created.

R13 17B

SOAP Service: WorkOrderEnrichService

Operation: getWorkOrderEnrich

Manufacturing

Work Order Update

Signals that a work order is updated.

R13 17B

SOAP Service: WorkOrderEnrichService

Operation: getWorkOrderEnrich

Order Management

Order Status Updated

Informs a subscriber that an order status or status of a fulfillment line that is part of an order was updated.

R12

SOAP Service: EventEnrichmentService

Operation: getEnrichmentDetails

Order Management

Sales Order Notification

Informs a subscriber about a significant development on a sales order. This event occurs when the order status changes, the line status changes, the value of an attribute changes, a fulfillment line splits, or an exception occurs, such as a jeopardy or hold.

R13 17B

SOAP Service: DocumentService

Operation: getSalesOrderNotificationDetails

Order Management

Sales Order Trade Compliance Screening

Communicates screening requests to a system that manages trade compliance.

R13 17B

SOAP Service: OrderFulfillmentRequestService

Operation: getOrderFulfillmentRequestDetails

Order Management

Sales Order Transportation Planning

Communicates fulfillment requests to a transportation planning system.

R13 17B

SOAP Service: OrderFulfillmentRequestService

Operation: getOrderFulfillmentRequestDetails

Purchasing

Purchase Order Event

Published when a purchase order is created, changed, finally closed, or reopened.

R13 17B

SOAP Service: PurchaseOrderService

Operation: getPurchaseOrder

Product Lifecycle Management

Change Order Approval Event

Signals that a change order is in approval.

R13 18B

SOAP Service: ChangeOrderService

Operation: getChangeOrder

Product Lifecycle Management

Change Order Completed Event

Signals that a change order is completed.

R13 18B

SOAP Service: ChangeOrderService

Operation: getChangeOrder

Product Lifecycle Management

Change Order Interim Approval Event

Signals that a change order is in interim approval.

R13 18B

SOAP Service: ChangeOrderService

Operation: getChangeOrder

Product Lifecycle Management

Change Order Open Event

Signals that a change order is open.

R13 18B

SOAP Service: ChangeOrderService

Operation: getChangeOrder

Product Lifecycle Management

Item Structure Component Create

Signals that an item structure component is created.

R12

SOAP Service: StructureService

Operation: findStructure

Product Lifecycle Management

Item Structure Component Update

Signals that an item structure component is updated.

R12

SOAP Service: StructureService

Operation: findStructure

Product Lifecycle Management

Item Structure Create

Signals that an item structure is created.

R12

SOAP Service: StructureService

Operation: findStructure

Product Lifecycle Management

Item Structure Update

Signals that an item structure is updated.

R12

SOAP Service: StructureService

Operation: findStructure

Product Master Data Management

Change Order Scheduled

Signals that a change order is scheduled.

R13 17B

SOAP Service: ProductDesignChangeOrderService

Operation: getChangeOrder

Product Master Data Management

Item Bulk Load

Signals that items are imported.

R11

NA

Product Master Data Management

Item Catalog Category Assignment Change

Signals a change in the item catalog category assignment.

R11

SOAP Service: ItemService

Operation: findItem

Product Master Data Management

Item Create

Signals that an item is created.

R11

SOAP Service: ItemService

Operation: findItem

Product Master Data Management

Item Publication Event

Signals that items are published.

R13 17C

NA

Product Master Data Management

Item Update Event

Signals that an item is updated.

R13 17B

SOAP Service: ItemService

Operation: findItem

Product Master Data Management

Product Upload Status Change

Signals a status change in a product upload.

R11

NA