Custom Time Period - EcoSys - Administration - Hexagon PPM

EcoSys System Administration

PPMProduct
EcoSys
PPMCategory_custom
Administration & Configuration
Version_EcoSys
8.6

To insert a new custom time period, do the following:

  1. Log into the database as the database admin.

  2. Execute the stored procedure InsertCustomTimePeriod.

  3. Restart the application server.

To drop an existing custom time period, do the following

  1. Log into the database as the database admin.

  2. Execute the stored procedure DropCustomTimePeriod, passing in the existing custom time period column name as the sole parameter.

  3. Restart the application server.

Syntax for execution

Oracle Execution (as FMADMIN):

exec InsertCustomTimePeriod;

exec DropCustomTimePeriod (‘existing custom time period’);

 SQL Server Execution:

exec FMUSER. InsertCustomTimePeriod

exec FMUSER. DropCustomTimePeriod ‘existing custom time period’