1. Using the Oracle E-Business Suite Adapter with Oracle Integration Generation 2
  2. Oracle E-Business Suite Adapter Samples
  3. An Example of Using an Open Interface REST Service as an Invoke (Target) Connection in an Integration
  4. Activate and Test the Integration

Activate and Test the Integration

Perform the following steps to activate the integration:

  1. On the Integrations page, click Activate iconfor the "'EBS OIT Demo" integration that you created earlier to activate the integration.

  2. The Confirmation dialog appears. Click Activate to confirm this action.

    Notice that a status message is displayed in the banner at the top of the Integrations page.

When this integration is activated, the endpoint to trigger the integration is displayed on top of the page, along with a link to the Tracking page to track instances.

The REST endpoint URL may be as: https://<host>:<port>/ic/api/integration/v1/flows/rest/EBS_OIT_DEMO/1.0/metadata

Test the Integration at Runtime

  1. Open a REST client.

  2. Post the following HTTP request: 

    
<?xml version="1.0" encoding="utf-8"?>
<RA_INTERFACE_LINES_ALL_Input>
 <RESTHeader>
  <Responsibility>RECEIVABLES_VISION_OPERATIONS</Responsibility>
  <RespApplication>AR</RespApplication>
  <SecurityGroup>STANDARD</SecurityGroup>
  <NLSLanguage>AMERICAN</NLSLanguage>
  <Org_Id>204</Org_Id>
 </RESTHeader>
<Select>QUANTITY,TRX_NUMBER,BATCH_SOURCE_NAME</Select>
<InputParameters>
<RA_INTERFACE_LINES_ALL_REC>
 <INTERFACE_LINE_ATTRIBUTE9>1</INTERFACE_LINE_ATTRIBUTE9>
 <INTERFACE_LINE_ATTRIBUTE11>1</INTERFACE_LINE_ATTRIBUTE11>
 <INTERFACE_LINE_ATTRIBUTE10>1</INTERFACE_LINE_ATTRIBUTE10>
 <ORG_ID>204</ORG_ID>
 <COMMENTS>Created by Service</COMMENTS>
 <QUANTITY>10</QUANTITY>
 <TRX_NUMBER>Demo-Rec1</TRX_NUMBER>
 <CONVERSION_RATE>1</CONVERSION_RATE>
 <CONVERSION_DATE>2018-08-18</CONVERSION_DATE>
 <CONVERSION_TYPE>User</CONVERSION_TYPE>
 <ORIG_SYSTEM_SHIP_ADDRESS_ID>1030</ORIG_SYSTEM_SHIP_ADDRESS_ID>
 <ORIG_SYSTEM_SHIP_CUSTOMER_ID>1004</ORIG_SYSTEM_SHIP_CUSTOMER_ID>
 <ORIG_SYSTEM_BILL_ADDRESS_ID>1030</ORIG_SYSTEM_BILL_ADDRESS_ID>
 <ORIG_SYSTEM_BILL_CUSTOMER_ID>1004</ORIG_SYSTEM_BILL_CUSTOMER_ID>
 <TERM_ID>4</TERM_ID>
 <TERM_NAME>30 Net</TERM_NAME>
 <CUST_TRX_TYPE_ID>1</CUST_TRX_TYPE_ID>
 <CUST_TRX_TYPE_NAME>Invoice</CUST_TRX_TYPE_NAME>
 <AMOUNT>1000.00</AMOUNT>
 <CURRENCY_CODE>USD</CURRENCY_CODE>
 <DESCRIPTION>Project Invoices</DESCRIPTION>
 <LINE_TYPE>LINE</LINE_TYPE>
 <SET_OF_BOOKS_ID>1</SET_OF_BOOKS_ID>
 <BATCH_SOURCE_NAME>PROJECTS INVOICES</BATCH_SOURCE_NAME>
 <INTERFACE_LINE_ATTRIBUTE7>Line</INTERFACE_LINE_ATTRIBUTE7>
 <INTERFACE_LINE_ATTRIBUTE6>1</INTERFACE_LINE_ATTRIBUTE6>
 <INTERFACE_LINE_ATTRIBUTE5>Sole, Mr. Samuel</INTERFACE_LINE_ATTRIBUTE5>
 <INTERFACE_LINE_ATTRIBUTE4>Vision Operations</INTERFACE_LINE_ATTRIBUTE4>
 <INTERFACE_LINE_ATTRIBUTE3>Services 01</INTERFACE_LINE_ATTRIBUTE3>
 <INTERFACE_LINE_ATTRIBUTE2>31</INTERFACE_LINE_ATTRIBUTE2>
 <INTERFACE_LINE_ATTRIBUTE1>ATZ Services</INTERFACE_LINE_ATTRIBUTE1>
 <INTERFACE_LINE_CONTEXT>PROJECTS INVOICES</INTERFACE_LINE_CONTEXT>
</RA_INTERFACE_LINES_ALL_REC>
<RA_INTERFACE_LINES_ALL_REC>
 <INTERFACE_LINE_ATTRIBUTE9>1</INTERFACE_LINE_ATTRIBUTE9>
 <INTERFACE_LINE_ATTRIBUTE11>1</INTERFACE_LINE_ATTRIBUTE11>
 <INTERFACE_LINE_ATTRIBUTE10>1</INTERFACE_LINE_ATTRIBUTE10>
 <ORG_ID>204</ORG_ID>
 <COMMENTS>Created by Service</COMMENTS>
 <QUANTITY>20</QUANTITY>
 <TRX_NUMBER>Demo-Rec2</TRX_NUMBER>
 <CONVERSION_RATE>1</CONVERSION_RATE>
 <CONVERSION_DATE>2018-08-18</CONVERSION_DATE>
 <CONVERSION_TYPE>User</CONVERSION_TYPE>
 <ORIG_SYSTEM_SHIP_ADDRESS_ID>1030</ORIG_SYSTEM_SHIP_ADDRESS_ID>
 <ORIG_SYSTEM_SHIP_CUSTOMER_ID>1004</ORIG_SYSTEM_SHIP_CUSTOMER_ID>
 <ORIG_SYSTEM_BILL_ADDRESS_ID>1030</ORIG_SYSTEM_BILL_ADDRESS_ID>
 <ORIG_SYSTEM_BILL_CUSTOMER_ID>1004</ORIG_SYSTEM_BILL_CUSTOMER_ID>
 <TERM_ID>4</TERM_ID>
 <TERM_NAME>30 Net</TERM_NAME>
 <CUST_TRX_TYPE_ID>1</CUST_TRX_TYPE_ID>
 <CUST_TRX_TYPE_NAME>Invoice</CUST_TRX_TYPE_NAME>
 <AMOUNT>1000.00</AMOUNT>
 <CURRENCY_CODE>USD</CURRENCY_CODE>
 <DESCRIPTION>Project Invoices</DESCRIPTION>
 <LINE_TYPE>LINE</LINE_TYPE>
 <SET_OF_BOOKS_ID>1</SET_OF_BOOKS_ID>
 <BATCH_SOURCE_NAME>PROJECTS INVOICES</BATCH_SOURCE_NAME>
 <INTERFACE_LINE_ATTRIBUTE7>Line</INTERFACE_LINE_ATTRIBUTE7>
 <INTERFACE_LINE_ATTRIBUTE6>1</INTERFACE_LINE_ATTRIBUTE6>
 <INTERFACE_LINE_ATTRIBUTE5>Sole, Mr. Samuel</INTERFACE_LINE_ATTRIBUTE5>
 <INTERFACE_LINE_ATTRIBUTE4>Vision Operations</INTERFACE_LINE_ATTRIBUTE4>
 <INTERFACE_LINE_ATTRIBUTE3>Services 01</INTERFACE_LINE_ATTRIBUTE3>
 <INTERFACE_LINE_ATTRIBUTE2>33</INTERFACE_LINE_ATTRIBUTE2>
 <INTERFACE_LINE_ATTRIBUTE1>ATZ Services</INTERFACE_LINE_ATTRIBUTE1>
 <INTERFACE_LINE_CONTEXT>PROJECTS INVOICES</INTERFACE_LINE_CONTEXT>
</RA_INTERFACE_LINES_ALL_REC>
</InputParameters>
</RA_INTERFACE_LINES_ALL_Input>

  3. Click the Tracking page link mentioned earlier to display the Tracking Instances page.

  4. Click the business identifier (such as Org_Id: 204) to display the orchestration flow diagram of the integration instance.

  5. From the menu, select View Activity Stream to view log messages about Success Count from the Interface step and the log message about concurrent program Submit ID from the 'CPSubmitReponse" step.

    Log messages can be like:

    1. LogActivity -<Date Time>- Success Count <no. of records in payload that was successfully inserted to RA_INTERFACE_LINES_ALL> - Interface

    2. LogActivity -<Date Time>- CP Submit ID <Request ID returned by CP Submit> - CPSubmitResponse

  6. Use the Submit ID to track the status of the associated concurrent program in Oracle E-Business Suite. Once the execution of the concurrent program is completed, you can view the report for the result of this concurrent program.