1. Administrator's Guide
  2. Working with Detailed Profitability
  3. Importing Detailed Profitability Staging Tables
  4. Creating Import Database Tables for Detailed Profitability

Creating Import Database Tables for Detailed Profitability

Staging database scripts are available for Microsoft SQL Server and Oracle Database

. Use the create_dp_staging.sql script to create the tables in Detailed Profitability.

To create staging tables:

  1. Create a new Oracle or Microsoft SQL Server database schema, outside of the product schema.
  2. Locate create_dp_staging.sql in the default location for your database type:

    • %EPM_ORACLE_HOME%/products/Profitability/database/Common/MSSQLServer

    • %EPM_ORACLE_HOME%/products/Profitability/database/Common/Oracle

  3. Run the create_dp_staging.sql script.