Skip Headers
Oracle® Fusion Middleware Developer's Guide for Oracle WebCenter
11g Release 1 (11.1.1.5.0)

Part Number E10148-16
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

56 Integrating Other Oracle Applications

This chapter describes how you can integrate other Oracle applications with your WebCenter Portal application.

This chapter contains the following sections:

56.1 Integrating Oracle and Other Applications in WebCenter

Oracle WebCenter is an integrated suite of technology designed to deliver a unified, context-aware user experience. WebCenter integrates structured and unstructured content, business intelligence, business processes, communication, and collaboration services, and removes the boundaries between enterprise applications. By integrating other applications available within the enterprise with WebCenter, you can create context-centric, composite applications that leverage the capabilities of these applications, extending WebCenter and changing the way people work.

WebCenter uses industry-standard technologies to integrate (primarily as WSRP and JPDK portlets) other application components. Figure 56-1 shows the technologies involved in WebCenter integration with other Oracle applications.

Figure 56-1 WebCenter Integration

Description of Figure 56-1 follows
Description of "Figure 56-1 WebCenter Integration"

Although not all applications support the same integration mechanisms, the integration process is generally quite simple, consisting of exposing the application object to be integrated as a portlet, registering the portlet with WebCenter, adding the portlet to a page, and then running and testing the results.

In Figure 56-1 we show the applications that can be integrated as Siebel, E-Business Suite, JD Edwards, PeopleSoft, and Oracle Business Intelligence. These Oracle applications are fully supported and documented within this chapter. However, you can integrate virtually any application that can expose objects as WSRP or JPDK portlets. The process for integrating them is the same as for the Oracle applications documented here: expose the object as a portlet, register the portlet in WebCenter, and add the portlet to a page. Refer to the documentation for one of the supported Oracle applications for a description of how to consume an exposed portlet in WebCenter.

56.2 Integrating Siebel Applications

This section describes how to integrate a Siebel Web service in a WebCenter Portal application. It also describes how to integrate Siebel objects using the Siebel Web Engine (SWE). Siebel and WebCenter can work together to include Siebel's CRM capabilities as portlets within your WebCenter application. You can integrate Siebel applications as Web services, or using the Siebel Web Engine (SWE) as described in the following subsections:

56.2.1 Integrating Siebel Applications as Web Services

This section describes how to integrate Siebel applications as Web services in a WebCenter Portal application.

This section contains the following subsections:

56.2.1.1 Preparing the Siebel Application

This section describes how to create an inbound Web service, set up operations for the inbound service, and generate a WSDL that you will later use to create a data control to your WebCenter application.

This section contains the following subsections:

56.2.1.1.1 Creating an Inbound Web Service

To create an inbound Web service:

  1. Log into the Siebel application.

  2. Navigate to the Administration - Web Services page.

  3. Click Inbound Web Services.

    The Inbound Web Services page shows the out-of-the-box Web services and any other Web services that are currently exposed.

  4. Click Menu and select New Record from the drop-down list.

  5. Enter the values for Namespace, Name, Status and Comment as appropriate for the Web service you want to set up. For example:

    Field Name Value
    Namespace http://siebel.com.fmw
    Name Siebel Customer Account
    Status Active
    Comment For Fusion Middleware

  6. Scroll to the Service Ports pane and select New Record from the Menu drop-down list.

  7. Enter CustAccount as the Name and click Type.

  8. In the Inbound Web Service Port Type pick applet, open the New tab.

  9. Select Business Service as the Implementation Type.

  10. From the Service Name list, select Siebel Account.

  11. In the Inbound Web Service Port Type pick applet, click OK to create the inbound Web service.

  12. From the Service Ports dialog's Transport drop-down list, select HTTP.

  13. In the Address field, set the URL to your Siebel instance. For example:

    http://example.com/eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute&UserName=SADMIN&Password=SADMIN
    
  14. From the Menu drop-down list, select Save Record.

56.2.1.1.2 Creating Operations for the Inbound Web Service

To add operations to the inbound Web service and then create a WSDL file, perform the following steps:

  1. Scroll to the Operations section and select New from the Menu drop-down list.

  2. In the Operation Name field, enter AccountInsert.

  3. Click Method Display Name to open the Business Service Method dialog.

  4. Select Insert as the Method, and click OK.

  5. From the Authentication Type drop-down list, select an appropriate authentication type:

    Authentication Type Session
    Type
    Description
    None None A single request is sent with an anonymous user login, and the session is closed after the response is sent out.

    In order for the anonymous session to be identified by the SWSE Plug-in, UsernameToken and PasswordText must be excluded in the SOAP headers.

    Username and password None A single request is sent with the username and password used to log in, and the session is closed after the response is sent out.
    Username and password Stateless The initial request to log in establishes a session that is to remain open and available for subsequent requests. Username/password are used to log in and a session token is returned in a SOAP header included in the outbound response. The session remains open.
    Session token (stateless) Stateless Request to reconnect to an established session, using the information contained in the session token. If the session has been closed, automatic re-login occurs. The Siebel servers include the session token in the SOAP header of the response. The session remains open.
    Session token (stateless) None When a SOAP header carries a session token and has the session type set to None, then the Session Manager on the SWSE closes (logs out) of this session, and invalidates the session token. The session token is not used after the session is invalidated.

  6. Click New to create a new operation.

  7. In the Operation Name field, enter a name for the new operation (for example, AccountQueryByExample).

  8. Click Method Display Name for the new operation.

  9. In the Business Service Method dialog, select the query method (for example, Query By Example) and click OK.

  10. Continue by adding any additional operations you may need as described in steps 6 to 9 above.

  11. In the Service Ports pane, select Save Record from the Menu drop-down list.

  12. In the Inbound Web Services pane, select Save Record from the Menu drop-down list.

  13. Select Clear Cache from the Menu drop-down list.

  14. Click the Generate WSDL.

  15. On the File Download dialog, click Open.

  16. Select File --> Save As...

  17. Locate the directory where you want to save the WSDL file, enter a name for the file and click Save.

56.2.1.2 Consuming a Siebel Web Service in a WebCenter Portal Application

This section describes how to consume Siebel applications that have been set up as Web services in a WebCenter Portal application, including how to set up a WSDL-based data control and, how to use JDeveloper's JSF Navigation Modeler to diagrammatically create your application's pages and the navigation between them.

This section contains the following subsections:

56.2.1.2.1 Creating a Data Control Based on a Siebel Web Service

This section describes how to create a WSDL-based data control based on a Web service created from a Siebel application.

To create a WSDL-based data control:

  1. Open your WebCenter Portal application or create a new WebCenter Portal application in JDeveloper.

  2. In the Applications Navigator, right-click the Model node and select New from the context menu.

  3. In the New Gallery, select All Technologies from the Filter By drop-down list.

  4. Select Business Tier | Web Services as the category, select the Web Service Data Control item, and click OK.

  5. In the Create Web Service Data Control wizard, click Next to leave the Welcome page.

  6. In Step 1, enter the Web service name in the Name field.

  7. Click Browse for the URL field, locate the directory where you downloaded the WSDL file, select the file and click Open.

    In the wizard, note the URL generated in the Service field.

  8. Click Next.

    Step 2 shows all the operations available from the selected Web service.

  9. Using the Add button, shuttle the operations you want to the Selected pane., and then click Next.

    When you expand the Model node in the Applications Navigator, you should see nodes for the entries that you have created.

  10. Click the Save All icon to save your changes.

56.2.1.2.2 Creating a Page Flow Diagram

This section describes how to create the page flow diagram to which you can your add source and query pages.

To create a page flow diagram:

  1. In the Applications Navigator, right-click the ViewController node and select New from the context menu.

  2. In the New Gallery, expand the Web Tier node and select JSF.

  3. In the Items pane, select JSF Page Flow & Configuration (faces-config.xml) and click OK.

  4. In the Create JSF Configuration File dialog, click OK to accept default values.

    An empty page flow diagram opens with a Component Palette and Data Control Palette to the right of the diagram editor. You use this to create components for the JSF Navigation Model.

  5. Click the Save All icon to save your changes.

56.2.1.2.3 Adding Pages and Navigation to the Page Flow Diagram

This section describes how to add pages and navigation to the page flow diagram.

To add pages to the page flow diagram:

  1. In the JSF Navigation Diagram Component Palette, create a source page by selecting JSF Page, clicking the diagram and naming the page appropriately (for example, QueryByID). Typically, you will have at least a source and query page.

  2. To create the query page, click and drag another JSF Page from the Component Palette and drop it next to the previous one, renaming it appropriately (for example, ShowResult).

  3. Select JSF Navigation Case in the JSF Navigation Diagram Component Palette. Click the icon for the source JSF page, and then click the icon for the destination JSF page for the navigation case.

  4. Modify the default label (success) by clicking it and entering an appropriate name (for example, toResult).

  5. Open the Overview tab and click Navigation Rules.

    The rule you just created in the diagram should be listed in the table.

    JDeveloper gives you three views of the faces-config.xml file: The same information that is presented in the diagram is also accessible through a declarative dialog and directly from the source. If you open the source view (by clicking the Source tab) the <from-view-id> tag identifies the source page, and the <to-view-id> tag identifies the destination page.

  6. From the diagram view, select JSF Navigation Case in the Component Palette. Click the icon for the source JSF page, and then click the icon for the destination JSF page for the navigation case.

  7. Modify the default label by clicking it and entering an appropriate name (for example, toQuery).

  8. Click the Save All icon to save the diagram.

56.2.1.2.4 Creating the Query Page

This section describes how to create and set up navigation for the query page.

To create the query page:

  1. On the Page Flow diagram, double-click the source page icon (QueryById) to launch the Create JSF JSP Wizard.

  2. Click Next to leave the Welcome page.

  3. In Step 1 of the wizard, select JSP Document (*.jspx) and click Next.

  4. In Step 2, make sure Do Not Automatically Expose UI Components in a Managed Bean is selected and click Next.

  5. In Step 3, make sure the following libraries are selected:

    ADF Faces Components 10_1_3_2_0 
    ADF Faces HTML 10_1_3_2_0
    JSF Core 1.0 
    Cusomizable Components Core 10_1_3_2_0 
    
  6. Click Finish to create the page.

    An empty JSF page opens in the Design tab of the editor.

  7. In the Customizable Components Core component palette, click ShowDetailFrame.

    The ShowDetailFrame appears in the page.

    Note:

    Oracle WebCenter provides two customizable components: PanelCustomizable and ShowDetailFrame. These two components make it very easy to organize the content of your Web application, treating different panels as if they are almost stand-alone, portlet-like objects that can be minimized, rearranged, have their own drop-down menus, and so on.
  8. With the ShowDetailFrame selected, modify the Text property in the Properties Inspector to Query By ID. Press [Enter] to update the page in the Visual Editor.

  9. Open the Data Control palette and expand the Siebel Web services node. Drag and drop the AccountQueryById(String) node onto the ShowDetailFrame on the page.

  10. In the popup menu, select Create | Parameters | ADF Parameter Form.

  11. In the Edit Form Fields, click OK.

  12. Select the AccountQueryById button generated in the page and in the Property Inspector pane, change the following properties:

    Text     Submit
    Action        toResult
    
  13. Select the input field corresponding to the input value, and in the Property Inspector, change the Label property to Account ID:

  14. Click the Save All icon to save your work.

56.2.1.2.5 Creating the Results Page

This section describes how to create and add navigation for the results page.

To create the results page:

  1. Click the faces-config.xml tab to return to the Page Flow diagram and double-click the ShowResult icon to launch the page wizard.

  2. Click Next to skip the Welcome page.

  3. In Step 1 of the wizard, select JSP Document (*.jspx) and click Next.

  4. In Step 2, make sure Do Not Automatically Expose UI Components in a Managed Bean is selected and click Next.

  5. In Step 3, make sure the following libraries are selected:

    ADF Faces Components 10_1_3_2_0 
    ADF Faces HTML 10_1_3_2_0
    JSF Core 1.0 
    
  6. Click Finish to create the page.

    An empty JSF page opens in the Design tab of the editor.

  7. In the Customizable Components Core component palette, click ShowDetailFrame.

    The ShowDetailFrame appears in the page.

  8. With the ShowDetailFrame selected, modify the Text property in the Properties Inspector to Query Results. Press [Enter] to update the page in the Visual Editor.

  9. In the Data Control palette, expand AccountQueryById | Return | SiebelMessage | ListofAccountInterface, select the Account node and drop it on the page on the ShowDetailFrame.

  10. In the popup menu, select Create | Forms | ADF Read-only Form.

  11. In the Edit Form Fields, delete all fields except for the following:

    AccountID 
    AccountStatus 
    NumberOfEmployees 
    CurrencyCode 
    Location 
    MainPhoneNumber 
    Name 
    Type
    
  12. Check the Include Submit Button checkbox and click OK.

  13. In the Action Binding Editor, click OK.

  14. Click Submit and in the Property Inspector change the title to Back to Query, and in the Action field select toQuery from the list.

  15. Click the Save All icon to save your work.

56.2.1.2.6 Testing the Application

This section describes how to test the application's JSF pages in JDeveloper. Before you can query a Siebel Account using an ID, you need to determine the IDs that are available in your Siebel instance. To perform the following steps you must have access to Siebel Call Center.

To determine the IDS and test your JSF pages:

  1. Log into Siebel Call Center, providing the appropriate user ID and password.

  2. Navigate to the Accounts List using Site Map.

  3. Click Accounts, then Accounts List.

  4. From the returned list, highlight the account you want to query.

  5. From the Help menu, select About Record.

  6. Find the ID value in the Row # field and make a note of it.

  7. Return to the page flow diagram and right-click the QueryById page icon and select Run from the context menu.

    The page is loaded in your default browser.

  8. In the ID field, enter the value you previously noted in the the Row # field and click Submit.

    The Details page displays the detail information for the corresponding account.

56.2.2 Integrating Siebel Applications Using the Siebel Web Engine

As well as integrating Siebel applications using Web Services, you can also integrate Siebel applications in a WebCenter Portal application using the Siebel Web Engine (SWE).

Siebel Web Engine (SWE) is responsible for rendering the Siebel User Interface. Siebel Web Templates provide this HTML layout information (markup information) to the Siebel Web Engine when rendering Siebel objects in the repository definition of the application. The markup that SWE returns can also be XML for rendering within XML-aware applications or WML (wireless markup language) for rendering on wireless devices. This lets you request the SWE to return a Siebel View as XML, parse the data elements, and display the result in a WebCenter Portal application.

For instructions on how to use SWE within a WebCenter Portal application, follow the tutorial Using the Siebel Web Engine (SWE) to View Data in a WebCenter Application.

To complete the tutorial, you will need the following:

  • Have access to or have installed Oracle JDeveloper Studio Edition

  • Have access to or have installed Oracle's Siebel eBusiness Applications.

  • Have access to a supported version of Windows Internet Explorer (IE) (see the System Requirements and Supported Platforms Guide for Siebel that is available on OTN).

Also refer to the Siebel Bookshelf Guides: Siebel Portal Framework Guide (specifically, the section on delivering content to external Web applications), and Configuring Siebel Business Applications Guide for details on SWE and Web Templates.

56.3 Integrating E-Business Suite Applications

This section describes how to integrate E-Business Suite applications in WebCenter applications.

This section contains the following subsections:

56.3.1 Introduction to Integrating EBS Applications

This section describes the integration points and requirements integrating Oracle E-Business Suite portlets in WebCenter applications.

This section includes the following subsections:

56.3.1.1 Understanding EBS Integration

Out-of-the-box, Oracle E-Business Suite OA Framework-based portlets, such as Applications Navigator, Favorites, and Worklist are WSRP and JSR 168-compliant. That means that you can access these Oracle E-Business Suite portlets from WSRP-compliant portal servers such as WebCenter Portal applications or WebCenter Spaces, by simply adding the portlet onto an application page. Follow the instructions in Section 56.3.2.3, "Creating a JSF Page to Consume the Remote Producer" to add them to a WebCenter Portal application page, or Section 56.3.3.3, "Adding the EBS Portlet to a WebCenter Spaces Page" to add them to a WebCenter Spaces page.

You can also create new E-Business Suite portlets that are WSRP and JSR 168-compliant that can similarly be added to a WebCenter application. Creating and consuming WSRP and JSR 168 compliant portals in WebCenter is described in Section 56.3.2, "Integrating EBS Applications in a WebCenter Portal Application" and Section 56.3.3, "Integrating EBS Applications in WebCenter Spaces."

56.3.1.2 Requirements for Integrating EBS Applications

The following requirements apply for integrating Oracle E-Business Suite portals into WebCenter applications:

  • Regions to be exposed as portlets must be created using Oracle E-Business Suite OA Framework Release 12 as previous versions are not WSRP/JSR 168-compliant.

  • Oracle E-Business Suite should be configured to use Oracle Internet Directory (OID) and one of following single sign-on solutions:

    • Oracle Single Sign-On (OSSO)

    • Oracle Access Manager (OAM)

    If you are using OSSO, follow the steps in My Oracle Support document 376811.1 to integrate E-Business Suite Release 12 with OID and OSSO.

    If you are using OAM, follow the steps in My Oracle Support document 975182.1 to integrate E-Business Suite Release 12 with OAM.

  • You must have granted the WebCenter application access to the E-Business Suite Portlet Producer and added and configured the appropriate users.

Note:

To complete some steps, you may need system administrator permissions.

56.3.2 Integrating EBS Applications in a WebCenter Portal Application

This section includes the following subsections:

56.3.2.1 Preparing the EBS Application for Remote Access

Prepare the standalone regions to be portletized as described in the section on "Basic Implementation" under "Portlets" in Chapter 4: "Implementing Specific UI Features" in the Oracle Application Framework Developer's Guide, available from My Oracle Support at:

https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1107973.1

The Oracle E-Business Suite OA Framework lets you expose any standalone regions (except pageLayout regions) as portlets.

You can also use an Oracle E-Business Suite tool called Portlet Generator to convert existing standalone Oracle Application Framework regions into portlets. For more information, see the section on "Portlet Generator" in Chapter 4: "Developer Tools" in the Oracle Application Framework Developer's Guide.

After creating the portlets, grant access to your new UI Function by adding it to a menu and associating the menu with a responsibility. For more information, see the section on "Page Security" under "Portlets" in Chapter 4: "Implementing Specific UI Features" in the Oracle Application Framework Developer's Guide.

Before adding the portlets in WebCenter, be sure to bounce the Apache listener as the menu and function definitions are cached. Note that you'll need system administrator permissions to do this.

56.3.2.2 Registering the EBS WSRP Producer in the WebCenter Portal Application

Follow the instructions below to create or open an existing WebCenter Portal application, and register the EBS WSRP producer.

  1. Create a new WebCenter Portal application or open an existing one in which you would like to consume the remote (WSRP) EBS portlet.

  2. Under Application Resources, right-click Connection and select WSRP Producer.

    Page 1 (Specify Producer Name) of the Register WSRP Portlet Producer wizard displays.

  3. Enter a name for the WSRP producer and click Next.

    The Specify Connection Details page displays.

  4. Enter the WSDL for the EBS producer in the WSDL URL field as shown below:

    WSDL URL: http://[Release_12_host]:[port]/OA_HTML/portlets/WSRPBaseService?WSDL
    

    For example:

    http://myEBSServer.example.com:8001/OA_HTML/portlets/WSRPBaseService?WSDL
    
  5. Click Next and then Finish.

    The WSRP producer should now appear under Connections.

  6. Continue by creating a JSF page to consume the WSRP producer as described in Section 56.3.2.3, "Creating a JSF Page to Consume the Remote Producer."

56.3.2.3 Creating a JSF Page to Consume the Remote Producer

Use the following procedure to add or use an existing JSF page to consume the EBS remote producer in your WebCenter Portal application.

To create a JSF page:

  1. In the application's Navigation panel, right-click on the application name and select New.

    The New Gallery dialog displays.

  2. In the Categories field's tree structure, locate and expand the Web Tier.

    A list with the descriptions of the available options display in the Items field.

  3. From this list, select JSF Page and click OK.

    The Create JSF Page dialog displays.

  4. Create the JSF page, making sure that the Create an XML Document (*.jspx) field is selected. For more information about setting up the JSF page, click the Help button to access the online help.

  5. Click OK.

    The newly created JSF page displays.

  6. Under connections, expand the newly created WSRP producer and drag the portlet for the EBS page onto the JSF page.

  7. In the Portlet Property Inspector, set the RenderPortletInIFrame property to True.

  8. Add any other components that you need onto the page, and save the application.

  9. Continue by running the page and testing that modifications made in the WebCenter application appear in the EBS application as described in Section 56.3.2.4, "Testing the WebCenter Portal Application."

56.3.2.4 Testing the WebCenter Portal Application

Use this procedure to test the WebCenter application by modifying content on the JSF page in the WebCenter Portal application and checking that the modification shows up in the EBS application.

  1. Run the .jspx page that you created.

  2. In the running page, modify some information that you can verify the changes for in the EBS application.

  3. Save your changes and confirm that the changes also appear in the EBS application.

56.3.3 Integrating EBS Applications in WebCenter Spaces

This section contains the following subsections:

56.3.3.1 Preparing the EBS Portlet for Remote Access

Prepare the standalone regions to be portletized as described the section on "Basic Implementation" under "Portlets" in Chapter 4: "Implementing Specific UI Features" in the Oracle Application Framework Developer's Guide, available from My Oracle Support at:

https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1107973.1

The Oracle E-Business Suite OA Framework lets you expose any standalone regions (except pageLayout regions) as portlets.

You can also use an Oracle E-Business Suite tool called Portlet Generator to convert existing standalone Oracle Application Framework regions into portlets. For more information, see the section on "Portlet Generator" in Chapter 4: "Developer Tools" in the Oracle Application Framework Developer's Guide.

After creating the portlets, grant access to your new UI Function by adding it to a menu and associating the menu with a responsibility. For more information, see the section on "Page Security" under "Portlets" in Chapter 4: "Implementing Specific UI Features" in the Oracle Application Framework Developer's Guide.

Before adding the portlets in WebCenter, be sure to bounce the Apache listener as the menu and function definitions are cached.

56.3.3.2 Registering the EBS WSRP Producer in WebCenter Spaces

You can register the EBS WSRP producer directly in WebCenter Spaces, as described in the section on "Registering Portlet Producers" in Oracle Fusion Middleware User's Guide for Oracle WebCenter Spaces. You can also register the EBS WSRP producer using Fusion Middleware Control as described in the steps below.

To register the EBS WSRP producer using Fusion Middleware Control:

  1. Prepare the EBS page that you want to consume in WebCenter spaces for remote access as described in Section 56.3.3.1, "Preparing the EBS Portlet for Remote Access."

  2. Log into Fusion Middleware Control for the WebCenter Spaces domain.

  3. Expand WebCenter Spaces in the Navigation bar and from the WebCenter menu, select Register Producer.

    The Add Portlet Producer page displays.

  4. Enter a Connection Name, set the Producer Type to WSRP Producer, and paste the WSDL endpoint URL that you copied in step 1 into the URL End Point field.

  5. Click OK and verify that the producer connection was created successfully.

  6. Continue by adding the portlet to a WebCenter Spaces page as described in Section 56.3.3.3, "Adding the EBS Portlet to a WebCenter Spaces Page."

56.3.3.3 Adding the EBS Portlet to a WebCenter Spaces Page

Use the following procedure to consume the EBS remote producer in WebCenter Spaces.

  1. Log into WebCenter Spaces.

  2. Go to the page, or create a new page, where you want to add the EBS portal.

  3. Click Add Content to open Composer.

  4. From the Resource Catalog, select Portlets.

    Note that if you've created a custom catalog, Portlets may not appear, in which case you will need to add it to the Resource Catalog. For information about managing Resource Catalogs, see the chapter "Working with Resource Catalogs" in the Oracle Fusion Middleware User's Guide for Oracle WebCenter Spaces.

  5. Click the portlet you added in Fusion Middleware Control.

  6. Click Add for the EBS portlet you want to add to your WebCenter Spaces page.

  7. Click Close to close Composer.

  8. On the WebCenter Spaces page, click the Edit (pencil) icon.

  9. Open the Display Options tab and set the Render Portlet in IFrame option to True and click OK.

  10. Continue by checking the portlet connection as described in Section 56.3.3.4, "Testing the WebCenter Spaces Portlet Connection."

56.3.3.4 Testing the WebCenter Spaces Portlet Connection

Use this procedure to test the WebCenter Spaces portlet connection by modifying content and checking that the modification shows up in the EBS application.

  1. On the WebCenter Spaces page that you added the EBS portlet to, modify some information that you can verify the changes for in the EBS application.

  2. Save your changes and confirm that the changes also appear in the EBS application.

56.4 Integrating JD Edwards Applications

This section describes how to integrate JD Edwards applications into WebCenter applications.

This section contains the following subsections:

56.4.1 Integrating JD Edwards Applications in a WebCenter Portal Application

This section includes the following subsections:

56.4.1.1 Preparing the JD Edwards Application for Remote Access

Before you can add JD Edwards standalone regions to WebCenter applications, you must first prepare them to be portletized within JD Edwards by making them available externally as portlets and locating the preconfigured WSDL in the webclient.war/wsdl directory. The WSDL URL is needed so that you can register the JD Edwards WSRP producer and consume it from a WebCenter Portal application page.

56.4.1.2 Registering the JD Edwards WSRP Producer in the WebCenter Portal Application

Follow the instructions below to create or open an existing WebCenter Portal application, and register the JD Edwards WSRP producer.

  1. Create a new WebCenter Portal application or open an existing one in which you would like to consume the remote (WSRP) JD Edwards portlet.

  2. Under Application Resources, right-click Connection and select WSRP Producer.

    Page 1 (Specify Producer Name) of the Register WSRP Portlet Producer wizard displays.

  3. Enter a name for the WSRP producer and click Next.

    The Specify Connection Details page displays.

  4. Paste the WSDL URL for the JD Edwards producer into the WSDL URL field.

  5. Click Next and then Finish.

    The WSRP producer should now appear under Connections.

  6. Continue by creating a JSF page to consume the WSRP producer as described in Section 56.4.1.3, "Creating the JSF Page to Consume the Remote Producer."

56.4.1.3 Creating the JSF Page to Consume the Remote Producer

Use the following procedure to add or use an existing JSF page to consume the JD Edwards remote producer in your WebCenter Portal application.

To create a JSF page:

  1. In the application's Navigation panel, right-click on the application name and select New.

    The New Gallery dialog displays.

  2. In the Categories field's tree structure, locate and expand the Web Tier.

    A list with the descriptions of the available options display in the Items field.

  3. From this list, select JSF Page and click OK.

    The Create JSF Page dialog displays.

  4. Create the JSF page, making sure that the Create an XML Document (*.jspx) field is selected. For more information about setting up the JSF page, click the Help button to access the online help.

  5. Click OK.

    The newly created JSF page displays.

  6. Under connections, expand the newly created WSRP producer and drag the portlet for the JD Edwards page onto the JSF page.

  7. In the Portlet Property Inspector, set the RenderPortletInIFrame property to True.

  8. Add any other components that you need onto the page, and save the application.

  9. Continue by running the page and testing that modifications made in the WebCenter application appear in the JD Edwards application as described in Section 56.4.1.4, "Testing the WebCenter Portal Application."

56.4.1.4 Testing the WebCenter Portal Application

Use this procedure to test the WebCenter Portal application by modifying content on the JSF page in the WebCenter Portal application and checking that the modification shows up in the JD Edwards application.

  1. Run the .jspx page that you created.

  2. In the running page, modify some information that you can verify the changes for in the JD Edwards application.

  3. Save your changes and confirm that the changes also appear in the JD Edwards application.

56.4.2 Integrating JD Edwards Applications in WebCenter Spaces

This section contains the following subsections:

56.4.2.1 Registering the Producer

You can register the JD Edwards WSRP producer directly in WebCenter Spaces, as described in the section on "Registering Portlet Producers" in Oracle Fusion Middleware User's Guide for Oracle WebCenter Spaces. You can also register the JD Edwards WSRP producer using Fusion Middleware Control as described in the steps below.

To register the JD Edwards WSRP producer using Fusion Middleware Control:

  1. Prepare the JD Edwards page that you want to consume in WebCenter Spaces for remote access as described in Section 56.4.1.1, "Preparing the JD Edwards Application for Remote Access."

  2. Log into Fusion Middleware Control for the WebCenter Spaces domain.

  3. Expand WebCenter Spaces in the Navigation bar and from the WebCenter menu, select Register Producer.

    The Add Portlet Producer page displays.

  4. Enter a Connection Name, set the Producer Type to WSRP Producer, and paste the WSDL endpoint URL that you copied in step 1 into the URL End Point field.

  5. Click OK and verify that the producer connection was created successfully.

  6. Continue by adding the portlet to a WebCenter Spaces page as described in Section 56.4.2.2, "Adding the JD Edwards Portlet to a WebCenter Spaces Page."

56.4.2.2 Adding the JD Edwards Portlet to a WebCenter Spaces Page

Use the following procedure to consume the JD Edwards remote producer in WebCenter Spaces.

  1. Log into WebCenter Spaces.

  2. Go to the page, or create a new page, where you want to add the JD Edwards portal.

  3. Click Add Content to open Composer.

  4. From the Resource Catalog, select Portlets.

    Note that if you've created a custom catalog, Portlets may not appear, in which case you will need to add it to the Resource Catalog. For information about managing Resource Catalogs, see the chapter "Working with Resource Catalogs" in the Oracle Fusion Middleware User's Guide for Oracle WebCenter Spaces.

  5. Click the portlet you added in Fusion Middleware Control.

  6. Click Add for the JD Edwards portlet you want to add to your WebCenter Spaces page.

  7. Click Close to close Composer.

  8. On the WebCenter Spaces page, click the Edit (pencil) icon.

  9. Open the Display Options tab and set the Render Portlet in IFrame option to True and click OK.

  10. Continue by checking the portlet connection as described in Section 56.4.2.3, "Testing the WebCenter Spaces Portlet Connection."

56.4.2.3 Testing the WebCenter Spaces Portlet Connection

Use this procedure to test the WebCenter Spaces portlet connection by modifying content and checking that the modification shows up in the JD Edwards application.

  1. On the WebCenter Spaces page that you added the JD Edwards portlet to, modify some information that you can verify the changes for in the JD Edwards application.

  2. Save your changes and confirm that the changes also appear in the JD Edwards application.

56.5 Integrating PeopleSoft Applications

This section describes how to integrate PeopleSoft applications in a WebCenter application.

This section contains the following subsections:

56.5.1 Introduction to Integrating PeopleSoft Applications

This section describes the benefits and methods involved in integrating PeopleSoft applications into WebCenter applications.

This section includes the following subsections:

56.5.1.1 Understanding PeopleSoft Integration

PeopleTools 8.48 and later lets you expose PeopleSoft applications as WSRP portlets in remote applications such as WebCenter. This allows people who only need access to a small portion of PeopleSoft's functionality to access it through a WebCenter application without needing to open or learn the entire PeopleSoft application.

56.5.1.2 Requirements for Integrating PeopleSoft Applications

This section the prerequisites for integrating PeopleSoft objects in WebCenter Portal applications, and WebCenter Spaces.

  • PeopleTools 8.48 or later

  • When using WS-Security for automatic sign on to PeopleSoft, in order for the SAML assertion to be valid, the date/time on the PeopleSoft and WebCenter servers must be synchronized. If this is problematic, then the PeopleSoft web server's time may be set to be slightly ahead of WebCenter server.

  • For PeopleTools 8.5.1 and earlier, you may need to create and configure a custom OWSM policy in order to fully support WS-Security. For more information, see Section 56.5.2.4, "Setting up WS-Security for PeopleTools."

56.5.2 Integrating PeopleSoft Applications in a WebCenter Portal Application

This section describes how to create or modify a WebCenter Portal application that integrates with PeopleSoft Applications.

This section includes the following subsections:

56.5.2.1 Preparing the PeopleSoft Application for Remote Access

This section describes how to prepare the PeopleSoft application so that it can be consumed by a WebCenter Portal application or WebCenter Spaces.

To prepare the PeopleSoft application:

  1. Log into PeopleSoft as an administrator.

  2. Select PeopleTools from the main menu.

  3. From the People Tools main menu, expand Employee Self-Service, and then Portal.

  4. Select Structure and Content.

  5. Navigate to the folder containing the page that you want to consume in WebCenter and click Edit to open it.

    The Content Ref Administration page displays.

  6. On the General tab, select the WSRP Producible checkbox.

  7. Save the page.

  8. From the main menu, select WSRP Production.

    The Producer Offered Portlets page displays.

  9. Verify that the page is exposed, and then expand Web Service Endpoint URL and copy the URL (the WSDL).

  10. Open a new tab in your browser, and paste the copied URL into the Navigation Bar to access the WSDL page.

  11. Copy the URL to the clipboard.

  12. Continue by creating or modifying a WebCenter Portal application that can access the PeopleSoft remote (WSRP) producer as described in Section 56.5.2.2, "Registering the PeopleSoft WSRP Producer in the WebCenter Portal Application."

56.5.2.2 Registering the PeopleSoft WSRP Producer in the WebCenter Portal Application

Follow the instructions below to create or open an existing WebCenter Portal application, and register the PeopleSoft WSRP producer.

  1. Create a new WebCenter Portal application or open an existing one in which you would like to consume the remote (WSRP) PeopleSoft portlet.

  2. Under Application Resources, right-click Connection and select WSRP Producer.

    Page 1 (Specify Producer Name) of the Register WSRP Portlet Producer wizard displays (see Figure 56-2).

    Figure 56-2 Specify Producer Name

    Description of Figure 56-2 follows
    Description of "Figure 56-2 Specify Producer Name"

  3. Enter a name for the WSRP producer and click Next.

    The Specify Connection Details page displays (see Figure 56-3).

    Figure 56-3 Specify Connection Details

    Description of Figure 56-3 follows
    Description of "Figure 56-3 Specify Connection Details"

  4. Paste the WSDL (the URL you copied earlier) into the WSDL URL field.

  5. Click Next and then Finish.

    The WSRP producer should now appear under Connections.

  6. Continue by creating a JSF page to consume the WSRP producer as described in Section 56.5.2.3, "Creating the JSF Page to Consume the Remote (WSRP) Producer."

56.5.2.3 Creating the JSF Page to Consume the Remote (WSRP) Producer

Use the following procedure to add a JSF page to consume the PeopleSoft remote producer.

To create a JSF page:

  1. In the application's Navigation panel, right-click on the application name and select New.

    The New Gallery dialog displays.

  2. In the Categories field's tree structure, locate and expand the Web Tier.

    A list with the descriptions of the available options display in the Items field.

  3. From this list, select JSF Page and click OK.

    The Create JSF Page dialog displays.

  4. Create the JSF page, making sure that the Create an XML Document (*.jspx) field is selected. For more information about setting up the JSF page, click the Help button to access the online help.

  5. Click OK.

    The newly created JSF page displays.

  6. Under connections, expand the newly created WSRP producer and drag the portlet for the PeopleSoft page onto the JSF page.

  7. In the Portlet Property Inspector, set the RenderPortletInIFrame property to True.

  8. Add any other components that you need onto the page, and save the application.

  9. Continue by running the page and testing that modifications made in the WebCenter application appear in the PeopleSoft application as described in Section 56.5.2.5, "Testing the WebCenter Portal Application."

56.5.2.4 Setting up WS-Security for PeopleTools

PeopleTools release 8.5.1 (and earlier) does not support outgoing WS-Security headers in its messages. The out-of-the-box WebCenter/OWSM policies require that both outgoing and incoming messages be secured. To bridge this gap you may need to create custom OWSM policies. This section describes the different integration scenarios that require custom WS-Security policies, and the steps required on WebCenter side to configure them.

This section includes the following subsections:

56.5.2.4.1 Configuring WS-Security for WSS10 SAML Token with Message Integrity

This section describes how to configure WS-Security for the WSS10 SAML Token with Message Integrity (oracle/wss10_saml_token_with_message_integrity_client_policy) policy.

To configure WS-Security:

  1. Configure the WebCenter/OWSM keystore as shown in the chapter "Configuring WS-Security" in the Oracle Fusion Middleware Administrator's Guide for Oracle WebCenter.

  2. Generate a certificate containing the public key of the WebCenter domain and send it to the PeopleTools administrator so it can be imported in the PeopleTools configuration.

  3. When you register the producer, choose wss10_saml_token_with_message_integrity_client_policy.

  4. Continue by adding the WSRP portlet to a WebCenter page.

56.5.2.4.2 Configuring WS-Security for WSS10 SAML Token with Message Protection

The default WSS10 SAML Token with Message Protection (oracle/wss10_saml_token_with_message_protection_client_policy) policy that ships with OWSM requires that response also be signed and encrypted. However, PeopleTools release 8.5.1 and earlier cannot send WS-Security headers in response (only the initial cookie/get portlet handle call contains security headers; subsequent calls do not) and we therefore need to create and attach a custom policy based on the oracle/wss10_saml_token_with_message_protection_client_policy policy.

To create a custom policy:

  1. Log into Fusion Middleware Control and navigate to the WebCenter domain (wc_domain by default).

  2. From the WebLogic Domain menu, select Web Services > Policies.

  3. Select the wss10_saml_token_with_message_protection_client_policy and click Create Like.

  4. Give the policy a new name (for example, oracle/wss10_saml_token_with_message_protection_plaintext_response_client_policy).

  5. Open the Response tab, uncheck the Include Entire Body checkboxes under Message Signing Setting and Message Encrypt Setting , and save the policy.

  6. Use WLST to register the producer using the newly created policy as shown in the following example:

    registerWSRPProducer('webcenter', 'wc-pt851-saml_msg-protection', 'http://example.com/pspc/pswsdl/ps/EMPLOYEE', timeout=100, tokenType='oracle/wss10_saml_token_with_message_protection_plaintext_response_client_policy', 
    enforcePolicyURI='false', issuer='www.oracle.com', sigKeyAlias='webcenter',sigKeyPswd='welcome1', encKeyAlias='webcenter', encKeyPswd='welcome1', recptAlias='peopleTools_public')
    

    Note:

    You must use WLST to register the producer. Fusion Middleware Control can only accept fixed policy names and therefore you must register the producer with this policy using WLST by passing in enforcePolicyURI='false'.
56.5.2.4.3 Configuring WS-Security for WSS10 Username Token with Password

The default WSS10 Username Token with Password (oracle/wss10_username_token_with_message_protection_client_policy) policy that ships with OWSM requires that response also be signed and encrypted. However, PeopleTools release 8.5.1 and earlier cannot send WS-Security headers in response (only the initial cookie/get portlet handle call contains security headers; subsequent calls do not) and we therefore need to create and attach a custom policy based on the oracle/wss10_username_token_with_message_protection_client_policy policy.

To create a custom policy:

  1. Log into Fusion Middleware Control and navigate to the WebCenter domain (wc_domain by default).

  2. From the WebLogic Domain menu, select Web Services > Policies.

  3. Select the wss10_username_token_with_message_protection_client_policy and click Create Like.

  4. Give the policy a new name (for example, oracle/wss10_username_token_with_message_protection_plaintext_response_client_policy).

  5. Open the Response tab, uncheck the Include Entire Body checkboxes under Message Signing Setting and Message Encrypt Setting , and save the policy.

  6. Use WLST to register the producer using the newly created policy as shown in the following example:

    registerWSRPProducer('webcenter', 'wc-pt851-saml_msg-protection', 'http://example.com/pspc/pswsdl/ps/EMPLOYEE', timeout=100, tokenType='oracle/wss10_username_token_with_message_protection_plaintext_response_client_policy', 
    enforcePolicyURI='false', issuer='www.oracle.com', sigKeyAlias='webcenter',sigKeyPswd='welcome1', encKeyAlias='webcenter', encKeyPswd='welcome1', recptAlias='peopleTools_public')
    

    Note:

    You must use WLST to register the producer. Fusion Middleware Control can only accept fixed policy names and therefore you must register the producer with this policy using WLST by passing in enforcePolicyURI='false'.

56.5.2.5 Testing the WebCenter Portal Application

Use this procedure to test the WebCenter application by modifying content on the JSF page in the WebCenter Portal application and checking that the modification shows up in the PeopleSoft application.

  1. Run the .jspx page that you created.

  2. In the running page, modify some information that you can verify the changes for in the PeopleSoft application.

  3. Save your changes and confirm that the changes also appear in the PeopleSoft application.

56.5.3 Integrating PeopleSoft Applications in WebCenter Spaces

This section describes how to integrate a PeopleSoft application in WebCenter Spaces.

This section contains the following subsections:

56.5.3.1 Registering the Producer

You can register the PeopleSoft WSRP producer directly in WebCenter Spaces, as described in the section on "Registering Portlet Producers" in Oracle Fusion Middleware User's Guide for Oracle WebCenter Spaces. You can also register the PeopleSoft WSRP producer using Fusion Middleware Control as described in the steps below.

To register the PeopleSoft WSRP producer using Fusion Middleware Control:

  1. Prepare the PeopleSoft page that you want to consume in WebCenter spaces for remote access as described in Section 56.5.2.1, "Preparing the PeopleSoft Application for Remote Access."

  2. Log into Fusion Middleware Control for the WebCenter Spaces domain.

  3. Expand WebCenter Spaces in the Navigation bar and from the WebCenter menu, select Register Producer.

    The Add Portlet Producer page displays.

  4. Enter a Connection Name, set the Producer Type to WSRP Producer, and paste the WSDL endpoint URL that you copied in step 1 into the URL End Point field.

  5. Click OK and verify that the producer connection was created successfully.

  6. Continue by adding the portlet to a WebCenter spaces page as described in Section 56.5.3.2, "Adding the PeopleSoft Portlet to a WebCenter Spaces Page."

56.5.3.2 Adding the PeopleSoft Portlet to a WebCenter Spaces Page

Follow the steps below to add the PeopleSoft portlet to a WebCenter Spaces page.

  1. Log into WebCenter spaces.

  2. Go to the page, or create a new page, where you want to add the PeopleSoft portal.

  3. Click Add Content to open Composer.

  4. From the Resource Catalog, select Portlets.

    Note that if you've created a custom catalog, Portlets may not appear, in which case you will need to add it to the Resource Catalog. For information about managing Resource Catalogs, see the chapter "Working with Resource Catalogs" in the Oracle Fusion Middleware User's Guide for Oracle WebCenter Spaces.

  5. Click the portlet you added in Fusion Middleware Control.

  6. Click Add for the PeopleSoft page you want to add to your WebCenter Spaces page.

  7. Click Close to close Composer.

  8. On the WebCenter spaces page, click the Edit (pencil) icon.

  9. Open the Display Options tab and set the Render Portlet in IFrame option to True and click OK.

  10. Continue by checking the portlet connection as described in Section 56.5.3.3, "Testing the WebCenter Spaces Portlet Connection."

56.5.3.3 Testing the WebCenter Spaces Portlet Connection

Use this procedure to test the WebCenter Spaces portlet connection by modifying content and checking that the modification shows up in the PeopleSoft application.

  1. On the WebCenter Spaces page that you added the PeopleSoft portlet to, modify some information that you can verify the changes for in the PeopleSoft application.

  2. Save your changes and confirm that the changes also appear in the PeopleSoft application.

56.6 Integrating Oracle Business Intelligence Presentation Services

This section explains how to use JDeveloper to create and configure a WebCenter application that integrates with the Oracle Business Intelligence Presentation Services catalog. At runtime, users can add business intelligence objects to their WebCenter Portal application or webCenter Spaces pages.

This section includes the following subsections:

56.6.1 Introduction to Integrating Oracle Business Intelligence Presentation Services

This section explains how you use JDeveloper to create a WebCenter Portal application, or configure WebCenter Spaces to integrate with the Oracle Business Intelligence Presentation Services catalog. For more information about adding Oracle Business Intelligence objects to WebCenter applications, see "Embedding Business Intelligence Objects in ADF Applications" in the Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition.

This section includes the following subsections:

56.6.1.1 Understanding Oracle Business Intelligence Presentation Services Integration

You can use JDeveloper to create WebCenter Portal applications that integrate with Oracle Business Intelligence Presentation Services. At runtime, these applications include the Presentation Services catalog in the WebCenter Resource catalog. Users can then browse for and add business intelligence analyses, dashboard pages, dashboards, or scorecard components (strategy maps, strategy trees, KPI watchlists, cause and effect maps, and custom views) to their WebCenter Portal application pages. Any filters, prompts, and actions links included in the Business Intelligence objects will work within the WebCenter Portal application or WebCenter Spaces pages.

At runtime, WebCenter users can expand and browse the Presentation Services catalog's folders to view an analysis' views. The following view types display in the Presentation Services catalog: table, pivot table, chart, funnel chart, gauge, narrative, ticker and title. The following view types do not display in the Presentation Services catalog: view selector, column selector, logical SQL, and no-results view.

Users can also browse the dashboard folder for the pages associated with the dashboard; however, users cannot browse within the dashboard pages to see their components (for example, any analyses embedded in the dashboard). Users cannot include entire Scorecards (only a Scorecard's components) in their WebCenter Portal application pages.

56.6.1.2 Requirements for Integrating Oracle Business Intelligence Presentation Services

To create a WebCenter Portal application that integrates with Oracle Business Intelligence Presentation Services, you must have installed Oracle JDeveloper 11g Release 1 (11.1.1.4) and the required Oracle BI EE and WebCenter extensions. To properly create the WebCenter application, you must configure the library settings, update the web.xml and default-catalog.xml files, and have properly configured security.

For WebCenter Portal applications and WebCenter Spaces, you must also set up a connection to the BI application as well as configuring security. For more information about configuring security and setting up a connection, see "How to Configure SSL and Create an Oracle BI EE Presentation Services Connection" in the Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition.

56.6.2 Integrating Oracle Business Intelligence Presentation Services in WebCenter Portal Applications

This section describes how to install the required BI extensions, and create or modify a WebCenter Portal application that integrates with Oracle Business Intelligence Presentation Services.

This section includes the following subsections:

56.6.2.1 Installing the Required Business Intelligence Extensions

Use this procedure to install the required Business Intelligence extensions:

  1. From the JDeveloper Help menu, select Check for Updates.

  2. Follow the steps in the wizard to locate, download, and install the Oracle BI EE extensions.

56.6.2.2 Creating a WebCenter Application that Integrates with Oracle BI Presentation Services

Use the following procedures to create or modify an Oracle WebCenter application that can access the Oracle Business Intelligence Presentation Services catalog at runtime.

This section includes the following subsections:

56.6.2.2.1 Creating the WebCenter Portal Application and JSF Page

Use the following procedure to create a WebCenter application and add a JSF page.

To create a WebCenter Portal application and JSF page:

  1. In Oracle JDeveloper, create a new WebCenter Portal application or open an existing one.

  2. In the Navigation panel, right-click on the application name and select New.

    The New Gallery dialog displays.

  3. In the Categories field's tree structure, locate and expand the Web Tier.

    A list with the descriptions of the available options display in the Items field.

  4. From this list, select JSF Page and click OK.

    The Create JSF Page dialog displays.

  5. Create the JSF page, making sure that the Create an XML Document (*.jspx) field is selected. For more information about setting up the JSF page, click the Help button to access the online help.

  6. Click OK.

    The newly created JSPX page displays.

  7. In the Component Palette pane, select Oracle Composer.

    The field updates to display the corresponding components, layouts, and operations.

  8. From the Common Components category, select Change Mode Link and drag and drop it onto your page.

  9. From the Common Components category, select Page Customizable.

  10. Save the application.

56.6.2.2.2 Configuring the Application to Display the Oracle BI EE Presentation Catalog

Use this procedure to add the Presentation Catalog to the WebCenter Portal application's folder list. At runtime, the catalog displays in the WebCenter Resource Catalog where the users can browse to business intelligence objects and add them to their WebCenter Portal application page.

To display the Presentation Catalog in the WebCenter application's folder list:

  1. In the WebCenter application that you created with Oracle JDeveloper, click the Application menu and select Project Properties.

    The Project Properties dialog displays.

  2. In the available properties pane, select Technology Scope and from the Available field, select BI ADF Components, and click the Add (>) icon to add it to the project's technology scope. Note that you can also add the BI technology libraries when you create a new application.

  3. In the available properties pane, select Libraries and Classpath, and click the Add (+) icon.

    The Add Library dialog displays.

  4. Add the following libraries to the project, and click OK.

    • BI ADF

    • BI ADF Taskflow

    • BI SOAP Connection Runtime

    • BI View Object Runtime

  5. Save the application.

  6. Locate and open the following default resource catalog file that was created when you saved the WebCenter Portal application:

    <your_application_home>\mds\oracle\adf\rc\metadata\default-catalog.xml

  7. Add the following <customFolder> entry under the <catalogDefinition> - ><contents> folder:

    <customFolder id="oracleBIContent"
        name="Oracle BI"
        description="Oracle BI Presentation Services Content"
        factoryClass="oracle.bi.presentation.rescat.
          BICatalogInitialContextFactory"/>
    
  8. In the application's Project pane, locate and open the web.xml file.

  9. Update the file to include the BIRegionServlet definition:

    <servlet>
        <servlet-name>biregionservlet</servlet-name>
        <servlet-class>oracle.bi.presentation.servlet.
          BIRegionServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>
     
    <servlet-mapping>
        <servlet-name>biregionservlet</servlet-name>
        <url-pattern>/BIProxy/*</url-pattern>
    </servlet-mapping>
    

    Make sure that the filter mapping of BIRegionFilter displays before the filter-mapping definition. For example:

    <filter-mapping>
        <filter-name>BIRegionFilter</filter-name>
        <servlet-name>Faces Servlet</servlet-name>
        <dispatcher>FORWARD</dispatcher>
        <dispatcher>REQUEST</dispatcher>
    </filter-mapping>
     
    <filter-mapping>
        <filter-name>adfBindings</filter-name>
        <servlet-name>Faces Servlet</servlet-name>
        <dispatcher>FORWARD</dispatcher>
        <dispatcher>REQUEST</dispatcher>
    </filter-mapping>
    
56.6.2.2.3 Enabling the BI ADF Task Flow Permission

Use the following procedure to enable the BI ADF task flow permissions in your application's security settings.

To enable the BI ADF task flow permissions:

  1. Locate and open the jazn-data.xml file in the following location:

    <your_application_root>\src\META-INF\jazn-data.xml

  2. Add the following element to this file:

    <permission>
        <class>oracle.adf.controller.security.TaskFlowPermission</class>
        <name>/WEB-INF/oracle/bi/presentation/taskflow/
           task-flow-definition.xml#task-flow-definition</name>
        <actions>customize,personalize,view</actions>
    </permission>
    

56.6.2.3 Testing the WebCenter Portal Application

This section describes how to test the WebCenter Portal application by performing the following procedures:

  • Adding Oracle BI Presentation Services catalog content and modifying a report or dashboard's prompt values

  • Confirming and modifying a business intelligence object's initialization parameters.

This section includes the following subsections:

56.6.2.3.1 Adding Oracle BI Objects to the Resource Catalog

Before you can add Oracle BI content to a WebCenter Portal application page, you must add objects stored in the Oracle BI Presentation Catalog to the WebCenter Resource Catalog.

  1. Run the application in a browser.

  2. Log into the WebCenter Portal application as an administrator.

  3. Click Administration.

    The WebCenter Portal Administration Console displays.

  4. Open the Resources tab.

  5. Click Resources Catalogs.

  6. In the Name field, enter the name of the catalog you are creating. Complete the other fields on this dialog, as necessary.

  7. Click the Edit menu and then choose Edit.

  8. From the Add menu, choose Add From Library....

  9. Double-click Connections.

    The BI Presentation Services folder displays in the right frame. Open this folder to display the Oracle BI objects.

  10. Browse to and select the objects that you want to add.

  11. Click Add to add the selected objects to the catalog.

56.6.2.3.2 Adding Business Intelligence Content at Runtime

Use this procedure to test the WebCenter application by adding business intelligence content to the WebCenter application.

  1. Run the .jspx page that you created.

  2. In the running page, click the Edit link to enter the edit mode.

  3. Click Add Content.

    The WebCenter Resource Catalog displays.

  4. Browse to and open the Oracle BI folder.

  5. Click the host machine to which you want to connect.

    The contents of the catalog display.

  6. Browse to and click the Add link for the object that you want to add to the .jspx page.

  7. Confirm that the application correctly added the object.

56.6.2.3.3 Modifying a Business Intelligence Object's Prompt Values

Use this procedure to test the WebCenter application by changing an analysis or dashboard's filter or prompt values.

  1. Run the .jspx page that you created.

  2. In the running page, click the Edit link to enter the edit mode.

  3. Add an analysis or dashboard that contains a filter or prompt.

    For more information about adding business intelligence content to the .jspx page, see Section 56.6.2.3.2, "Adding Business Intelligence Content at Runtime."

  4. Click Configure.

    The Editing Page dialog displays.

  5. Modify the values and click Save.

  6. Confirm that the application correctly applied the modified prompt values.

56.6.2.3.4 Modifying a Business Intelligence Task Flow's Initialization Parameters

Use the following procedure to test the business intelligence task flow's initialization parameters.

  1. Run the .jspx page that you created.

  2. In the running page, click the Edit link to enter the edit mode.

  3. Add a business intelligence object.

    For more information about adding business intelligence content to the .jspx page, see Section 56.6.2.3.2, "Adding Business Intelligence Content at Runtime."

  4. Locate the business intelligence object and click Edit.

    The Component Properties dialog displays.

  5. Open the Parameters tab, modify the object's parameters, and click OK.

  6. Confirm that the application correctly applied the modified prompt values.

56.6.2.4 Post-Deployment Connection Configuration

After an application has been deployed, you can use Fusion Middleware Control to add a new Oracle BI EE Presentation Services connection to the application, or to modify the application's existing Oracle BI EE Presentation Services connection.

For more information about modifying these connections, see "Adding or Modifying a Presentation Services Connection After Deployment" in the Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition.

56.6.2.5 Securing Oracle BI EE Objects Included in a WebCenter Application

Impersonate User lets you secure a WebCenter Portal application that integrates with Oracle BI EE Presentation Services. For more information about Impersonate User and how to implement it to secure your application, see "How to Create and Use Impersonate User" in the Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition.

56.6.3 Integrating Oracle Business Intelligence Objects in WebCenter Spaces

Use the following procedures to test the WebCenter Spaces integration with the BI objects. Note that before you can begin integrating BI objects in WebCenter Spaces, you must first configure a connection from spaces to the BI server. For information about creating and modifying these connections, see "Adding or Modifying a Presentation Services Connection After Deployment" in the Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition.

56.6.3.1 Adding Oracle BI Objects to the WebCenter Spaces Resource Catalog

Before you can add Oracle BI content to a Spaces page, you must add objects stored in the Oracle BI Presentation Catalog to the WebCenter Spaces Resource Catalog.

  1. Log into WebCenter Spaces as an administrator.

  2. In WebCenter Spaces, click Administration.

    The WebCenter Spaces Administration pages displays.

  3. Open the Resources tab.

  4. Click Resources Catalogs.

  5. In the Name field, enter the name of the catalog you are creating. Complete the other fields on this dialog, as necessary.

  6. From the Edit menu, choose Edit.

  7. Select the Add menu and then choose Add From Library.....

  8. Double-click Connections.

    The BI Presentation Services folder displays.

  9. Open this folder to display the Oracle BI objects and browse to and select the objects that you want to add.

  10. Click Add to add the selected objects to the catalog.

56.6.3.2 Adding Oracle BI Content at Runtime

Use this procedure to create a WebCenter Spaces page and add Oracle BI objects to it. Before you perform this procedure, you must have added Oracle BI objects to the WebCenter Spaces resource catalog.

  1. Log into WebCenter Spaces and create a new Space or access an existing Space.

  2. Create a new page.

  3. In the page, click Add Content.

  4. Browse to the folder containing the Oracle BI objects.

  5. Select an analysis or dashboard and click Add.

    The object that you selected is added to the page.

  6. Click Close to exit the Add Content dialog.

56.6.3.3 Modifying a Business Intelligence Object's Prompt Values

Use this procedure to test the WebCenter Spaces page by changing an analysis or dashboard's filter or prompt values.

  1. Open the page that you created.

  2. In the running page, click Page Actions and then click the Edit link to enter edit mode.

  3. Add an analysis or dashboard that contains a filter or prompt. For more information about adding Oracle BI objects to the page, see Section 56.6.3.2, "Adding Oracle BI Content at Runtime."

  4. Save the WebCenter Spaces page.

  5. In the WebCenter Spaces page, modify the prompt values and click OK.

  6. Confirm that the application correctly applied the prompt values.

56.6.3.4 Modifying a Business Intelligence Task Flow's Initialization Parameters

Use the following procedure to test the business intelligence task flow's initialization parameters.

  1. Open the page that you created.

  2. In the running page, click Page Actions and then click the Edit link to enter the edit mode.

  3. Add an analysis or dashboard that is part of a task flow. For more information about adding business intelligence content to the .jspx page, see Section 56.6.3.2, "Adding Oracle BI Content at Runtime."

  4. Save the WebCenter Spaces page.

  5. On the WebCenter Spaces page, open the Parameters tab and modify the object's parameters and click OK.

  6. Confirm that the application correctly applied the modified parameter values.