Task 5: How to Create EBS and SBL External References

To create EBS and SBL external references:

  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 Application 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 Schema.
  11. Click Browse.

    The Stored Procedures dialog is displayed.

  12. Select POPULATE_APP_INSTANCE, as shown in Figure 44-18.

    Figure 44-18 Stored Procedure Dialog

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

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

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

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

    The Finish page is displayed.

  15. Click Finish.

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

    Figure 44-20 EBS Reference in SOA Composite Editor

    Description of Figure 44-20 follows
    Description of "Figure 44-20 EBS Reference in SOA Composite Editor"
  16. From the File menu, select Save All.
  17. Repeat Step 2 through Step 16 to create another external reference named SBL.

    After completing this task, the SOA Composite Editor appears, as shown in Figure 44-21.

    Figure 44-21 SBL Reference in SOA Composite Editor

    Description of Figure 44-21 follows
    Description of "Figure 44-21 SBL Reference in SOA Composite Editor"