Preparing the Oracle E-Business Suite Environment

In this section:

Before adding an Oracle E-Business Suite, you must prepare the environment. The preparation steps are:


Top of page

x
Configuring the Adapter for Oracle

The Adapter for Oracle is used to support connectivity to the Oracle E-Business Suite.

To add a connection to the Oracle database, follow the instructions in Configuring the Adapter for Oracle. When defining a connection to the Oracle E-Business Suite database, you must use the delivered database APPS user ID and the connection name must be VIS.

The APPS user ID is the database ID, not an application user ID. Privileges assigned to the APPS user ID enable the enforcement of data security rules when accessing data. Functions performed by this ID include authentication, setting the application user system context, data selection, and accessing views with row-level data restrictions.

Note: For this purpose, Information Builders recommends that the Reporting Server be run in PTH security mode.


Top of page

x
Creating Oracle Metadata

The Adapter for Oracle E-Business Suite uses synonyms that you create using the Adapter for Oracle. For details about creating these synonyms, see Managing Oracle Metadata.


Top of page

x
Customizing the General Ledger Security Package

How to:

In order to execute views that contain calls to the Oracle E-Business Suite General Ledger Security Package (APPS.GL_SECURITY_PKG), the package must be customized to enable third party access. This package is called from within many General Ledger Business Views and performs the following functions:



x
Procedure: How to Update the General Ledger Security Package

To update the General Ledger Package:

  1. Use the Oracle Enterprise Management Console (or equivalent) to locate the package body GL_SECURITY_PKG found in the APPS schema.
  2. Select Edit, View to modify this package body.
  3. Locate the following syntax in the init procedure:
    IF      (( instrb(program_name,'dis',-1,1) =  0 )      AND
      ( nvl(l_module,'XXX')          <> 'Discoverer4' )    AND
      ( nvl(l_gl_bis_disco_flag,'N')    <> 'Y' )           THEN
        return;
    END IF;
  4. Edit the syntax to include a new test on the program name, as follows:
    IF      (( instrb(program_name,'dis',-1,1) =  0 )      OR
       ( instrb(program_name,'tsc',-1,1) =  0 ))           AND
       ( nvl(l_module,'XXX')         <> 'Discoverer4' )    AND
       ( nvl(l_gl_bis_disco_flag,'N')   <> 'Y' )           THEN
         return;
    END IF;

    This new syntax adds the tscom3.exe agent to the list of acceptable programs for the init procedure.


iWay Software