In this section: |
Before adding an Oracle E-Business Suite, you must prepare the environment. The preparation steps are:
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.
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.
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:
To update the General Ledger Package:
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;
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 |