This chapter describes the Oracle Utilities Data Model utility scripts.
This chapter includes the following sections:
The Calendar population scripts consist of two one-time installation packages.
The Calendar population scripts include the following packages:
calendar_population_header.sql
calendar_population_body.sql
Running these packages does the following:
Prepares necessary changes for the OUDM_SYS schema.
Creates the Calendar_Population package that contains the following procedures:
RUN(in_setup_start_date, in_setup_no_years) is the main procedure to populate everything about calendar.
RBIW_Populate_Time_Hier_Clndr(in_setup_start_date, in_setup_no_years) sets up the data in base table for the Calendar hierarchy as specified in setup or install section.
RBIW_Time_hier_Star sets up the Time hierarchy reporting layer tables.
To populate calendar data:
Log in to OUDM_SYS user.
Execute the following SQL statement:
exec Calendar_Population.run(date,num_years);
where, date is the start date with which you want to populate calendar data. It is of type CHAR and should be input in the format 'YYYY-MM-DD' (for example,'2005-05-18'). num_years is the number of years to populate calendar data, which should be INTEGER.