This appendix covers the following topics:
The following applications must be installed in the system, before you work with Oracle Incentive Compensation Analytics:
E-Business Suite Application Release R12.1 or later releases
Oracle Data Integrator (ODI) version 10.1.3.5
Oracle Business Intelligence Enterprise Edition (OBIEE) version 10.1.3.4.
The ODI artifacts and OBIEE metadata repository are bundled with the 7631642:R12.CN.B patch. These components are installed and deployed in E-Business Top, in the $CN_TOP/patch/115/odi and $CN_TOP/patch/115/obiee directories respectively.
On the target instance/schema, create a database link ORACLE_APPS with the connection details of the source instance/schema.
CREATE DATABASE LINK ORACLE_APPS CONNECT TO APPS IDENTIFIED BY &AppsPassword USING ‘(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = &HostName) (PORT = &PortNo)) (CONNECT_DATA = (SID = &DBName)))’;
ODI Topology
ODI Designer
Re-Host ODI Invocation in E-Business Suite
Create the logical schema “ORACLE_APPS” for source schema
Create the logical schema “ORACLE_CN” for target schema
Create the context “CN_CONTEXT”
Define the Source Schema and Target Schema data servers.
Create the Data Server “ORACLE_CN_OLTP” for source schema.
If the source and target schemas are defined in the same instance then enter “ORACLE_APPS” in Instance/dblink (Data Server).
If the source and target schemas are defined on separate instances, then name Instance/dblink (Data Server) as db/SID/TWO_TASK.
Associate CN_CONTEXT with ORACLE_APPS, under the Context tab.
Create the data server “ORACLE_CN_OLAP” for target schema. Name the Instance/dblink as TWO_TASK name.
Associate CN_CONTEXT with ORACLE_CN, under the context tab.
Bundle and copy all the ODI artifacts files to a location accessible by ODI. To import Oracle Incentive Compensation ODI artifacts:
Locate the Import Util file, cnodi_import_util.zip, in the $CN_TOP/odi/US/util/ folder; copy it to the ODI installation/staging area and unzip into a temporary folder.
Locate the ODI installation folder bin folder.
Modify odiparams.sh on Linux) or odiparams.bat on Windows) according to the ODI setup, including jdbc connections and repository info.
For example,
set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver set ODI_SECU_URL=jdbc:oracle:thin:@localhost:1521:XE set ODI_SECU_USER=snpm1 set ODI_SECU_ENCODED_PASS=ccfHMPvDjDxVJ.ODIXD2kUkRte set ODI_SECU_WORK_REP=WORKREP1 set ODI_USER=SUPERVISOR set ODI_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH
Modify properties in odi_import.properties under the util folder.
5. Run the following command in ODI installation bin folder, specifying the Buildfile location and the name of the output log file:
On Windows:
D:\Oracle_ODI\oracledi\bin>startcmd OdiAnt "- BUILDFILE=D:\OIC\ODI\packaging\UTIL\build.xml" "- LOGFILE=D:\OIC\ODI\packaging\UTIL\output.log"
On Linux:
sh startcmd.sh OdiAnt "- BUILDFILE=/slot/ems3512/oracle/OICANA/util/build.xml" "- LOGFILE=/slot/ems3512/oracle/OICANA/util/output.log"
Deploy odi-sdk-invocation.jar on EBS Apache installation Ensure that the CLASSPATH has reference to jdk/bin and jdbc/lib/ojdbc14.jar.
Include odi-sdk-invocation.jar into the environment variable $AF_CLASSPATH
Re-host the ODI Scenario parameter file.
For E-Business Suite Application concurrent manager to initiate the ELT process:
Unzip the cnodiparams.zip file located in the $CN_TOP/patch/115/odi/US/util/ folder into the APPLCSF area. Update the cn_odiparams.properties file with the ODI connection parameters.
Start he ODI agent.
1. Re-Host the Oracle Incentive Compensation Analytics metadata files.
Unzip the $CN_TOP/patch/115/obiee/cnrpd.zip file under the <Oracle BI Home>/server/Repository directory.
Unzip the $CN_TOP/patch/115/obiee/cnwebcat.zip file under the <Oracle BI Data Home>/web/catalog directory.
Shutdown the OBIEE services
Modify the OBIEE Repository server configuration file.
For single-sign on from EBS Application to the BI Reports, modify the OBIEE Web Catalog configuration file for external authentication.
Note: Refer My Oracle Support note 552735.1.
Set up the connection pool.
Start the OBIEE service.
Add users to the EBS application and assign responsibilities to these users.
The Compensation Manager should have access to the following dashboard pages and reports:
Compensation Cost dashboard
Compensation Cost by Plan Elements report
Compensation Cost of Sales by Quarter report
Compensation Summary by Quarter report
Performance Summary dashboard
Attainment Summary by Quarter report
Performance Distribution report
The Plan Administrator should have access to all the dashboard pages that the Compensation Manager has access to, and the following Scenarios reports:
Compensation Cost of Sales
Compensation Cost Summary
Incentive Investment Matrix
Attainment versus Quota
The Sales Manager should have access to the following dashboard and reports:
Performance Summary dashboard
Salesrep Ranking report
Attainment Summary by Quarter report
Compensation Summary by Quarter report