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.