Installing Financial Periods

Previous TopicNext TopicContents

P6 Reporting Database can use two additional financial periods. Use the following procedure to add the additional Financial Periods to your P6 Reporting Database:

Note: You must have previously run the staretl process.

  1. Connect to your Star database instance with 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 all one line.

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

Related Topics

Installing and Configuring Financial Periods

Configuring the OBI RPD File for Financial Periods



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014