An Example of Using an Open Interface REST Service as an Invoke (Target) Connection in an Integration

Sample Business Scenario

An open interface "AR Autoinvoice" (RAXMTR) is used to explain how to insert invoice data in Oracle E-Business Suite through the invocation of REST services.

In this example, the REST Adapter is used as a trigger (source) connection and the Oracle E-Business Suite Adapter is used as invoke (target) connections to invoke the REST services contained in the RAXMTR open interface.

At runtime when the integration is triggered, the Oracle E-Business Suite Adapter receives a request with input payload from the trigger (source) connection, invokes the RA_INTERFACE_LINES_ALL REST service to insert data, and invokes the SUBMIT_CP_RAXMTR REST service to submit the corresponding concurrent program. Once the integration is executed and completed successfully, invoice line data is inserted into the RA_INTERFACE_LINES_ALL open interface table in Oracle Receivables. Additionally, you will find the log messages as output responses indicating the number of records are inserted into the table and the concurrent request ID. You can then use the request ID to view and verify the report of the RAXMTR concurrent program.


Before creating the integration in Oracle Integration, you need to ensure the following tasks are in place:

  • The "AR Autoinvoice" (RAXMTR) open interface is deployed as a REST service with alias autoinvoice. All included service operations or interface tables are selected and deployed as REST service operations.

    Description of integration_repository_raxmtr.gif follows
    Description of the illustration integration_repository_raxmtr.gif

    Record the following REST service endpoint from the WADL:


    Replace <alias> with autoinvoice in this example. You will use this service endpoint later when you create a REST connection in Oracle Integration.

  • Security grants are created for the operations user.

Based on the integration scenario, the sample tasks for using an Oracle E-Business Suite Open Interface REST service in an integration are included in the Topics section:


  1. Establish the Connections for Oracle E-Business Suite and REST Services

  2. Create an Integration with App Driven Orchestration

  3. Add the REST Adapter (Trigger) and the Oracle E-Business Suite Adapter (Invoke) to the Integration

  4. Create Mappings

  5. Assign Business Identifier for Tracking

  6. Activate and Test the Integration

  7. Sample XSD for the Oracle E-Business Suite Adapter as an Invoke Example for an Open Interface REST Service