Installing and Configuring Financial Periods

Primavera Data Warehouse can use two additional financial periods. Use the following procedure to add the additional financial periods to your Primavera Data Warehouse:

Note: You must have previously run the STARETL process.

  1. Log in to the Primavera Data Warehouse database instance as the schema owner (for example, the STARUSER account).
  2. Run a query to set the values for fin_period_2 and fin_period_3. For example:

    update w_day_d set fin_period_2 = CHR(64 + cal_month)||'-'||cal_year;

    update w_day_d set fin_period_3 = CHR(64 + cal_month)||'-'||cal_year;

    Enter these queries as one line.

  3. Commit these changes.
  4. Run the STARETL process.


Legal Notices | Your Privacy Rights
Copyright © 2016, 2020

Last Published Wednesday, October 20, 2021