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.


Top of page

x
Procedure: How to Configure the Adapter
x

You can configure the adapter from either the Web Console or the Data Management Console.

  1. From the Web Console menu bar, click Adapters

    or

    from the Data Management Console, expand the Adapters folder.

    The Adapters folder opens.

  2. Expand the Available folder, if it is not already expanded.
  3. Expand the ERP group folder and the Oracle Applications folder.
  4. Right-click Oracle Applications and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Accept the default configuration parameter:
    Responsibility ID

    Default value (-1) indicates that all individual Responsibility ID security rules will be combined. If another value were provided, only that specific Responsibility ID would be used for data access privileges.

    x
    Select profile

    Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.

    If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (the extension is added automatically).

    Store the connection attributes in the server profile (edasprof).

  6. Select a profile from the drop-down list to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default. For an illustration, see Sample edasprof.prf .

    If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down list and enter a name in the Profile Name input box. (The extension is added automatically.)

  7. Click Configure. The configured adapter is added to the Adapters list in the navigation pane.

Next step: When the configuration is complete, the next step is to create adapter control tables by running the oesfiles procedure. For details, see How to Create the Adapter Control Tables .



Example: Sample edasprof.prf
.
.
.
-*
APP PATH OESSEC IBISAMP
-*
ENGINE SQLORA SET CONNECTION_ATTRIBUTES VIS VIS/apps,9AA42BAE9EC283A8
SET USER=ORAAPPS
ENGINE ORAAPPS SET APPS RESP_ID -1

Top of page

x
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

Top of page

x
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