Custom Time Period - EcoSys - Administration & Configuration - Hexagon

EcoSys System Administration

Language
English
Product
EcoSys
Search by Category
Administration & Configuration
EcoSys Version
9.0

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’