Introduction

This course provides a general overview of working with the Oracle Utilities Energy Information Platform, including exercises that span a variety of business applications. Attendees learn how to navigate the web user interface and work with the Energy Information Platform features and tools. In addition, this course provides a general overview of working with Oracle Utilities Rules Language.

Prerequisties

• Familiarity with programming, SQL, COM and XML

Course Content

1. Energy Information Platform Basics

• Overview
• Basic Navigation
• User Dashboard
• Data Navigator

2. Security Configuration and Administration

• Security Concepts
• Function-Level Security
• Record-Level Security
• Database Auditing

3. Adapter

• Installing and Configuring the Adapter
• Adapter Components
• Adapter Business Rules
• Adapter Services
• Starting and Running the Adapter
• Work Queues
• Life Cycle of a Work Queue Item

4. Work Queues Configuration

• Work Queue Hints
• Work Queue Menu and User Interface
• Work Queue Reports

5. Interval Data Viewer and Interval Data Manager

• Searching and Viewing Interval Data
• Editing Interval Data

6. Reporting Framework

• Report Administration
• Running and Viewing Reports
• Crystal Reports
• Oracle Utilities Rules Language Reports
• Report Scheduler
• Customizing the Energy Information Platform User Interface

7. Oracle Utilities Rules Language: Working with Interval Data

• Interval Data Validation
• Interval Data Aggregation
• Interval Data Functions and Operations

8. Oracle Utilities Rules Language: Work Queues Configuration

• Defining a work queues configuration
• Configuring exception management business rules

9. Creating Oracle Utilities Rules Language Reports

• Creating report templates
• Running and Viewing Reports

10. Oracle Utilities Rules Language: Billing Rates and Tariffs

• Scalar (consumption) rates
• Interval Rates
• Using historical data in billing

11. Oracle Utilities Rules Language: Working with XML

• Reading from XML Files
• Creating XML Output

12. Oracle Utilities Rules Language: Creating CIS Output

• Billing Results and Output
• Interval Data Export

13. Oracle Utilities Rules Language: Working with COM Objects