If you will be using Oracle Web Services Manager to automate Profitability and Cost Management tasks, you must install the Repository Creation Utility (RCU) before configuring the EPM System products. The RCU creates the required schemas to work with Oracle Web Services Manager (OWSM). Oracle Web Services Manager is automatically installed, but not configured, with EPM Workspace.
To install and configure the Repository Creation Utility:
Download the Repository Creation Utility from the “Oracle Enterprise Performance Management System” Media Pack on Oracle EDelivery.
Copy rcuHome.zip to the location in which you want to install the Repository Creation Utility, and extract the contents.
From rcuHome/bin, run the Repository Creation Utility to create the database schema to manage the automated processing, using the appropriate file for your operating system:
For Windows, run rcu.bat
For UNIX, run ./rcu
Note:
Ignore any messages about using a non-AL32UTF8 database.
The new database schema is required for “Metadata Services” and does not reflect the Profitability and Cost Management model database. For detailed information, see the Oracle Fusion Middleware Repository Creation Utility User's Guide 11g.
On the Database Connection Details page, specify a user with DBA or SYSDBA privileges, such as sys.
On the Select Components page, perform these tasks:
Expand AS Common Schemas and select Metadata Services, if it is not already selected.
Make a note of the Schema Owner names for all the components because you need them to configure Oracle Web Services Manager.
On the Schema Passwords page, Oracle recommends that you select Use same passwords for all schemas. Make a note of this password.
On the Summary page, review the selections, and then click Create.
For additional information on the Repository Creation Utility, see the Oracle® Fusion Middleware Repository Creation Utility User’s Guide 11g Release 1 (11.1.1).