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

Creating Import Database Tables for Standard Profitability

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

Use the create_staging.sql script to create the tables in Standard Profitability.

To create staging tables:

  1. Create a new Oracle or Microsoft SQL Server database schema, outside of the product schema.
  2. Navigate to the location for the appropriate SQL script in the default location for the database type:

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

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

  3. Run the create_staging.sql script.