1. Using the Oracle E-Business Suite Adapter with Oracle Integration 3
  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. In the navigation pane, click Design, then Integrations.
  2. On the Integrations page, hover your cursor over the EBS OIT Demo integration, then click Activate Activate icon.

  3. 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, a link to the Tracking page to track instances is shown on the top. Once the integration is activated, click Actions Actions icon and then select Run. 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.