Custom Time Period - EcoSys - Administration & Configuration - Hexagon

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’