Oracle ERP Cloud Adapter Capabilities

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

Note:

If you have a co-located Oracle HCM Cloud with Oracle ERP Cloud, you may see Oracle HCM Cloud APIs in the Oracle ERP Cloud Adapter. It is recommended that you use the Oracle HCM Cloud Adapter for any HCM integrations. However, if you do use the Oracle ERP Cloud Adapter with these APIs, ensure that you have reviewed the supported SOAP services in Oracle HCM Cloud.

See Oracle HCM Cloud Adapter Capabilities.

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, event subscription, or business (REST) API 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 SCM and Procurement Business Events.

    • Business (REST) API: Represents an Oracle Fusion Applications REST API resource.

      You can select parent business resources and their corresponding child business resources. Support is provided in the invoke (outbound) direction.

  • Dynamically invokes a REST endpoint/URL at runtime without requiring you to configure any extra invoke connection or REST outbound details.

    See Invoke an Endpoint Dynamically.

  • 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.

    • The 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.

  • Enables you to upload files to Oracle WebCenter Content (Universal Content Manager) in encrypted or unencrypted format. Oracle WebCenter Content provides a unified repository to store unstructured content, enabling organizations to deliver the content to business users in the proper format.

    See Upload a File to Oracle WebCenter Content.

    Note:

    Downloading files from Oracle WebCenter Content is not supported.

Note:

Note the following behavior:

  • During bidirectional account and contact synchronization, echoes are generated. Oracle Integration-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 SCM and Procurement Business Events

The following SCM and Procurement 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

Data Pool Subscription

Signals that a data pool subscription is created.

R11

SOAP Service: DataPoolSyndicationService

Operation: findSubscription

Product Master Data Management

Data Pool Subscription Confirmation Sent

Signals that a data pool subscription confirmation is sent.

R11

SOAP Service: DataPoolSyndicationService

Operation: findConfirmation

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

Supported Financials Business Events

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

Cloud Product Supported Business Event Description First Release Available
Advanced Collections Strategy Closed Signals when the collection strategy associated to a customer is closed. 18C
Advanced Collections Strategy External Task Opened Signals when the collection strategy assigned to a customer has a task that should be performed by an external system and when that task is opened. 18C
Financials Common Module ERP Integration Inbound Signals when the import bulk data is completed using the ERP Integration web service. 17D
Financials Common Module ERP Integration Outbound Signals when the export bulk data is completed using the ERP Integration web service. 17D
General Ledger Accounting Period Closed Signals when a general ledger accounting period is closed. 18C
General Ledger Accounting Period Opened Signals when a general ledger accounting period is opened. 18C
General Ledger Accounting Period Reopened Signals when a general ledger accounting period is reopened. 18C
General Ledger Journal Batch Approved Signals when a journal batch is approved. 18C
General Ledger Journal Batch Posting Completed Signals when a journal batch is posted. 18C
Payables Payables Invoice Approved Signals when an invoice is approved. 18C
Payables Payables Invoice Cancelled Signals when an invoice is canceled 18C
Payables Payables Invoice Created Signals when an invoice is created. 18C
Payables Invoice Hold Applied Signals when an invoice hold is placed. 18B
Payables Invoice Hold Released Signals when an invoice hold is released. 18B
Payables Payables Invoice Validated Signals when an invoice is validated online. 18C
Payables Payables Payment Created Signals when a single payment is created. 18C
Payables Payables Payment Voided Signals when a payment is voided. 19A
Payments Payment File Created Signals when a payment file is created. 18C
Receivables Credit Case Folder Closure Signals when a case folder whose request type is Credit Check Failure is closed. 18B
Receivables Receivables Autoinvoice Completed Signals when an autoinvoice is completed. 19A
Receivables Receivables Credit Memo Applied Signals when a standard credit memo is created and an on account credit memo is successfully applied. 19A
Receivables Receivables Credit Memo Completed Signals when a credit memo is successfully completed. 19A
Receivables Receivables Credit Memo Incompleted Signals when a credit memo is incomplete. 19A
Receivables Receivables Invoice Completed Signals when an invoice is completed. 18C
Receivables Receivables Invoice Incompleted Signals when an invoice is incomplete. 19A
Receivables Receivables Invoice Paid Signals when a payment is applied to an invoice. 18C
Receivables Receivables Lockbox Batch Completed Signals when a lockbox batch process is completed. 19A
Receivables Standard Receipt Applied Signals when a standard receipt is applied to a transaction for the goods received or services rendered. 19A
Receivables Standard Receipt Created Signals when a standard receipt is created to record payment from a customer for goods received or services rendered. 18C
Receivables Standard Receipt Deleted Signals when a standard receipt is successfully deleted. 19A
Receivables Standard Receipt Reversed Signals when a standard receipt is reversed. 18C
Receivables Standard Receipt Unapplied Signals when a standard receipt is successfully unapplied. 19A