Overview
The DERMS Adapter facilitates the integration of distributed energy resource (DER) and forecast data into Oracle Utilities Network Management System (NMS) to support key operational analyses. By automating the extraction and loading of forecast and pricing data from various sources—including files and RDBMS tables—into designated database tables, the adapter ensures timely, accurate information is available to enable advanced power flow analysis, DERMS analysis, and short-term load and generation forecasting in the Distribution Management System (DMS).
1. DER Forecasts for Core Power Flow Analysis
Ingests forecast updates for various power source types (such as wind, solar/photovoltaic, diesel, and so on) to support core power flow analysis.
Loads these forecasts into the PF_DER_FORECAST, PF_DER_DEMAND_RESPONSE_FORECAST, and PF_WEATHER_ZONE_FORECAST tables.
2. DER Bids for Grid DERMS Analysis
Processes DER Bids for use in the Grid DERMS analysis. These bids contain forecast and pricing information for 3rd party generators.
Populates the DERMS_BIDS table to support the Grid DERMS analysis (for example, Network Capacity Allocation).
3. External Load and Generation Forecasts
Integrates short-term, highly accurate load and generation forecasts from external systems—typically produced by AI or machine learning models—for advanced PowerFlow calculations.
Loads this data into the PF_GEN_LOAD_FORECAST table.
4. Dynamic Operating Envelope (DOE) Schedules
Imports maximum import and export limits for individual DERs from CSV files. The adapter stages the data in DERMS_DOE_SCHEDULES_ST and merges it into DERMS_DOE_SCHEDULES for DOE analysis.
5. Edge Virtual Power Plant Schedule Snapshots
Processes authoritative schedule snapshots for pre-provisioned edge Virtual Power Plants (eVPPs). File input supports CSV and JSON. Each snapshot replaces the complete schedule for one FILE-owned eVPP. An accepted snapshot returns UPDATED when its normalized schedule differs from the stored schedule or UNCHANGED when it is an exact multiset match. Invalid snapshots return REJECTED. An UPDATED snapshot increments the schedule version and returns the eVPP to Pending approval.