Understanding Processing Timetable Types

Processing timetable types define types of schedules that can be referenced by different processes and objects in Oracle Utilities applications such as Oracle Utilities Meter Data Management and Oracle Utilities Market Settlements Management. For example, if a process requires requesting data from an external system on a daily basis, a daily processing timetable type could be used to define the details of this schedule.

Processing timetable types are used by standalone data request measuring components to control the schedule by which requests for data are processed (for example, in a settlement process in which zonal load is requested on a daily basis). They are also used in the attribute data snapshot creation process.

The base package includes two processing timetable type business objects used with specific scheduling patterns:

  • Daily Processing Timetable: Used for daily schedules
  • Defined Dates Processing Schedule: Used for schedules that should execute on specific dates.

Parameters used to define processing timetable types include:

  • Execution Frequency Class: Designates the type of processing timetable, Daily or Defined Dates (based on the business object)
  • Scheduling Information: Details about how the schedule is executed, including:
    • Period Cut-Off Time: The time of day that represents the end of a period. In many instances this will be 12:00 AM. However, for something like a "Gas Day" this might be set to 09:00 AM.
    • Earliest Execution Time: Used to prevent records from being processed until after this time each day. This time relates to the processing time.
    • Lag / Lead: A flag that indicates whether periods in the past (Lag) or future (Lead) should be processed (applies to Daily schedules only)
    • Lag Days / Lead Days: The number of days in the past (Lag) or future (Lead) that should be processed (applies to Daily schedules only)
    • Restrict Processing by Work Calendar: Used to restrict processing to only the work days configured in the Work Calendar and will exclude any holidays added to the calendar (applies to Daily schedules only)
  • Workflow Information: Details about how the processing timetable aligns with process workflows, including warning time and target due time
  • Processing Dates: A list of specific dates on which the process should be executed (used with Defined Dates Processing Schedule only)