Integrate eBusiness Suite With Order Management

Set up the Integrated SOA Gateway and business events when you integrate Oracle eBusiness Suite with Oracle Order Management.

Summary of the Set Up

1. Set up web services.

2. Set up business events.

3. Set up subscription for business event.

4. Set up security for business event.

5. Set up eBusiness Suite so it can communicate status.

Set Up Web Services

This topic describes how to set up web services in Integrated SOA Gateway (Service Oriented Architecture). For background details, see:

• Oracle E-Business Suite Integrated SOA Gateway Developer's Guide.

• Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 (Doc ID 556540.1).

Set up web services.

1. Sign into eBusiness Suite with administrative privileges.

2. Expand responsibility Integrated SOA Gateway, then click Integration Repository.

3. In the Integration Repository area, expand Order Management Suite, expand Order Management, then click Sales Order.

4. In the table that displays, click the Sales Order Services link.

5. In the Sales Order Services area, click Regenerate WSDL.

   For example:

   

6. In the Procedures and Functions area, add a check mark to the Select option for the row that includes these values.

   Name	Internal Name	Description
   Sales Order Service	PROCESS_ORDER_25	Dedicated for Order Management integration

7. Click Create Grants.

   If a global grant exists for all users, then it might not be necessary to create an individual grant.

8. Set the value.

   Attribute	Value
   Authentication Type	Username Token

9. Click Deploy.

10. Click View WSDL, then note the URL that the WSDL (Web Service Definition Language) uses.

    You use this URL when you set up the connector on the SOA server. Make sure this URL is similar to this URL:

    http://server:port/wEBServices/SOAProvider/plsql/oe_inbound_int/?wsdl

    where

    • server:port identifies the address of the server that hosts the web service.

11. Repeat steps 1 through 10 to create and deploy another service.

    Attribute	Value
    Name	Sales Order Outbound service
    Internal Name	OE_OUTBOUND_INT
    Description	Contains procedures to generate outbound integration information
    Procedures and Functions Internal Name	SYNC_ORDER_25

    This service uses an API in eBusiness Suite.

Set Up Business Events

To support the status update flow, you must set up the event and subscription so they can call the response service in Order Management. The business event already exists in eBusiness Suite, but you must set it up.

1. In eBusiness Suite, expand the Workflow Administrator Web Applications responsibility, then click Administrator Workflow.

2. Click Business Events.

3. On the Business Events tab, in the Search area, in the Display Name attribute, enter the value.

   oracle.apps.ont.genesis.outbound.update

   For example:

   

4. Click Go.

Set Up Subscription for Business Event

1. Click Create Subscription.

   

2. In the Search and Select area, enter values.

   Attribute	Value
   Search By	System Name
   Value	Enter the name of the eBusiness Suite system. For example, enter XZ6DV213.your.address.

3. Click GO.

4. Wait for the result to display, then click Select.

   For example, click Select in the row that contains these values.

   Attribute	Value
   System Name	XZ6DV213.your.address
   Display Name	LA5099
   Description	Local system created by Oracle Workflow Configuration Assistant

5. In the Update Event Subscriptions area, set the values, then click Next.

   Attribute	Value
   Source Type	Local
   Event Filter	oracle.apps.ont.genesis.outbound.update
   Phase	100
   Status	Enabled
   Rule Data	Message
   Action Type	Invoke Web Service
   On Error	Stop and Rollback

6. Notice that step 1 of the task-based user interface displays. This interface guides you through the set up.

   

7. On the Load WSDL step, enter the URL that locates the WSDL of the connector, then click Next.

   Attribute	Value
   WSDL URL	http://server:port/soa-infra/services/default/DooFulfillOrderEbsComposite/DooEbsConnectorInboundService_ep?WSDL

8. On the Select Service step, set the value, then click Next.

   Attribute	Value
   Service Name	DooEBSConnectorService_eb Note that DooEBSConnectorService is the name of the connector.

9. On the Select Service Port step, make sure the Select option is enabled for the service.

   Service Port	Port End Point
   FulfillOrderEbsProcess_pt	http://server:port/soa-infra/services/default/DooFulfillOrderEbsComposite/DooEbsConnectorInboundService_ep

10. Click Next.

11. On the Select Operation step, make sure the Select option is enabled for the operation.

    Operation	Port Type	Operation Type
    FulfillOrderEbsInboundRequest	FulfillOrderEbsProcess	ONE_WAY,0

12. Click Next.

13. On the Subscription Documentation step, set the values, then click Apply.

    Attribute	Value
    Java Rule Function	oracle.apps.ont.sif.EBSFOMEventInvoker This Java rule function is part of the eBusiness Suite patch. It allows the connector to use the status update flow.
    Owner Name	Oracle Workflow
    Owner Tag	FND

Set Up Security for Business Events

1. On the Event Subscription page, in the Subscription Parameters area, set the values.

   Attribute	Value
   WFBES_SOAP_USERNAME	Enter the user name of the service that you're calling. For example: OPERATIONS
   WFBES_SOAP_PASSWORD_MOD	Enter the module name. For example: ONT
   WFBES_SOAP_PASSWORD_KEY	Enter the key name. For example: operationsKey

2. Store the password so its secure. Sign into the database that resides on the eBusiness Suite server, then use SQL to query the Order Management database.

   sqlplus username/password@database_name @$FND_TOP/sql/afvltput.sql ONT passwordKey password

   For example:

   sqlplus apps/apps@vi7kr759 @$FND_TOP/sql/afvltput.sql ONT operationsKey password

Set Up eBusiness Suite So It Can Communicate Status

eBusiness Suite uses business events to communicate status. You must set them up.

1. Expand Order Management Super User > Setup > Orders, then click AIA Sales Order Status.

2. In the AIA Sales Order Status Synchronization dialog, add a check mark to the Sync Reqd? option for each of the statuses that this integration must communicate.

   • Awaiting Shipping

   • Shipped

   • Fulfilled

   • Awaiting Return

   • Returned