Task 5: How to Create an EBS External Reference

To create an EBS external reference:

  1. In the Components window, select SOA.
  2. Select Database Adapter and drag it to the External References swimlane.

    The Adapter Configuration wizard Welcome page is displayed.

  3. Click Next.

    The Service Name page is displayed.

  4. In the Service Name field, enter EBS.
  5. Click Next.

    The Service Connection page is displayed.

  6. In the Connection field, select DBConnection1.
  7. In the JNDI Name field, enter eis/DB/DBConnection1.
  8. Click Next.

    The Operation Type page is displayed.

  9. Select Call a Stored Procedure or Function and click Next.

    The Specify Stored Procedure page is displayed.

  10. Select Scott from the Schema.
  11. Click Browse.

    The Stored Procedures dialog is displayed.

  12. Select POPULATE_APP_INSTANCE_IM, as shown in Figure 44-49.

    Figure 44-49 Stored Procedure Dialog

    Description of Figure 44-49 follows
    Description of "Figure 44-49 Stored Procedure Dialog"
  13. Click OK.

    The Specify Stored Procedure page appears, as shown in Figure 44-50.

    Figure 44-50 Specify Stored Procedure Page of Adapter Configuration Wizard

    Description of Figure 44-50 follows
    Description of "Figure 44-50 Specify Stored Procedure Page of Adapter Configuration Wizard"
  14. Click Next.

    The Advanced Options page is displayed.

  15. Click Next.The Finish page is displayed.
  16. Click Finish.

    Figure 44-51 shows the EBS reference in the SOA Composite Editor.

    Figure 44-51 EBS Reference in SOA Composite Editor

    Description of Figure 44-51 follows
    Description of "Figure 44-51 EBS Reference in SOA Composite Editor"
  17. From the File menu, select Save All.