Configuring the Adapter for Oracle E-Business Suite

How to:

x

The process of configuring the adapter includes configuring the adapter from either the Web Console or the Data Management Console, creating Oracle E-Business Suite control tables, and configuring the Remote Services Profile to call the adapter.

Procedure: How to Configure an Adapter

  1. From the Web Console sidebar, click Connect to Data.

    or

    From the Data Management Console, expand the Adapters folder.

    In the DMC, the Adapters folder opens. In the Web Console, the Adapters page opens showing your configured adapters.

  2. In the Web Console, click the New Datasource button on the menu bar and find the adapter on the drop-down list or, in the DMC, expand the Available folder if it is not already expanded.
    On the Web Console, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.
  3. In the DMC, expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Right-click the adapter name and/or version and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Enter values for the parameters required by the adapter, as described in the chapter for the specific adapter you want to configure.
  6. Click Configure. The configured adapter is added to the Adapters list in the DMC resources tree or the Configured list in the Web Console.
    In the Web Console, the adapter remains on the Available Adapters list with a check mark to indicate that at least one connection has been configured. You can configure additional connections from either the Configured or Available list by right-clicking the adapter and clicking Add Connection.

Procedure: How to Create the Adapter Control Tables

You can create the adapter control tables from either the Web Console or the Data Management Console.

  1. From the Web Console, select Applications

    or

    from the Data Management Console, right-click the server and select Connect.

  2. In the navigation pane, expand the Application Directories folder, right-click any application, and select New.
  3. In the edit pane, type EX OESFILES and click the run icon. An example of the output follows:
    0 NUMBER OF RECORDS IN TABLE=     2546  LINES=   2546
    ORAUSER.FOC: Oracle eBusiness Suite User Info
    ...Loaded
    0 NUMBER OF RECORDS IN TABLE=    42094  LINES=  42094
    ORASYSF.FOC: Oracle eBusiness Suite Table Info
    ...Loaded
    0 NUMBER OF RECORDS IN TABLE=    10290  LINES=  10290
    ORAUSRAP.FOC: Oracle eBusiness Suite App Info
    ...Loaded

Procedure: How to Configure the Remote Services Profile

  1. Edit or create the Remote Service profile for the client node to be used for Oracle E-Business Suite data access. To do so, open the WebFOCUS Administration Console, navigate to the Reporting Servers Node, and select Profile from the options at the bottom of the page.
  2. Add the _site_profile call to the adapter procedure, OESLOGIN.
    <VER1>
     
    # Site Profile: Adapter Oracle E-Business Suite
    # Description:  Enables remote user authentication against
    #               the Oracle E-Business Suite and passes necessary
    #               parameters to set the system context for the user
    # Set default responsibility ID and application ID
    #   Calling application must set and validate the resp ID
    #   and appl ID before passing them to the procedure. If
    #   these are not validated they will still be passed, but
    #   invalid data may be returned for the user. If no values
    #   are set, these defaults will be used in setting the system
    #   context. In which case, certain database views will be 
    #   unusable.
    # Bind MR User to WF User
    <ifdef> IBIMR_user
    IBIC_user=&IBIMR_user
    <endif>
    <ifdef> IBIMR_pass
    IBIC_pass=&IBIMR_pass
    <endif>
    # Responsibility ID (IBIWF_respid)
    <ifndef> IBIWF_respid
    IBIWF_respid=0
    <endif>
    # Application ID (IBIWF_applid)
    <ifndef> IBIWF_applid
    IBIWF_applid=0
    <endif>
     
    # Execute parameterized call to OESLOGIN
    _site_profile=&_site_profile\EX OESLOGIN OES_RESP_ID=&IBIWF_respid,
    _site_profile=&_site_profile\n   OES_APPL_ID=&IBIWF_applid, PASSTHRU=ON
    _site_profile=&_site_profile\n-RUN
     
    # Enable these &variables to be passed to the server
    <SET> IBIWF_respid(PASS)
    <SET> IBIWF_applid(PASS)

WebFOCUS

Feedback