NOTICE DATE:  December 19, 2013
NOTICE TYPE:  M-A121813-04 Extracts
SHORT DESCRIPTION:  Update - Missed report postings on MIS – out of compliance notification and Market Data Transparency Web Services availability
INTENDED AUDIENCE:  ERCOT Market Participants
DAY AFFECTED:  December 17, 2013 to current
LONG DESCRIPTION:  The following extracts are experiencing issues that may prevent them from posting timely due to technical issues with ERCOT’s Data Warehouse.  ERCOT will publish any missed postings due to this issue as soon as possible.
Report Name

EMIL ID

12/17/2013

12/18/2013

12/19/2013

Default Profile ESIID Report

COPG-197

Out of Protocol

Out of Protocol

Expected to post late

ESIID Service History & Usage Extract

ZP12-245

Posted on time

Posted on time

Expected to post late

Load Estimation Counts Report - Certified

COPG-767

Out of Protocol

Out of Protocol

Expected to post late

Load Estimation Counts Report – Public

COPG-316

Out of Protocol

Out of Protocol

Expected to post late

Public Reference Data Extract (PRDE)

ZP12-465

Out of Protocol

Out of Protocol

Expected to post late

Recorder Extract

ZP11-489

Posted on time

Posted on time

Expected to post late

Resource Control Report

NP3-988-ER

Posted on time

Posted on time

Posted on time

RID Extract

ZP11-532

Posted on time

Posted on time

Expected to post late

Settlement Inputs Data Extract

NP12-753

Out of Protocol

Out of Protocol

Expected to post late

Supplemental AMS Interval Data

COMS-456

Posted on time

Posted on time

Expected to post late

Supplemental IDR Required Interval Data Extract

COMS-457

Posted on time

Posted on time

Expected to post late

TDSP ESI ID Extract

ZP15-612

Out of Protocol

Out of Protocol

Expected to post late


The same issues affect data that is provided via Market Data Transparency Web Services. Data created or posted into ERCOT’s system after December 16, 2013 will not be included in the data request output files until the technical issues are resolved.
ERCOT staff continues to work through the software issue with the replication of data from its financial settlement system into its data warehouse in which replication of a small set of market data has caused a significant decrease in performance resulting in delayed publication of extracts and potentially impacting Market Data Transparency Web Services.  ERCOT continues to work with its vendor to investigate the reason for the delayed processing of the data in question by its replication system.  Once the replication system completes processing of the data set, ERCOT expects the backlog to decrease and publication of extracts to resume at normal levels.  Further details will be provided as they become available.
Delays in publication of the above data extracts impact Market Participants reconciling retail market transactions as well as loading of reference tables and settlement input data into shadow settlement systems needed to validate Settlement Statements in a timely manner. Note that the Commercial Operating Day Extract (CODE) and Market Operating Day Extract (MODE) containing approved settlement input data used in publication of settlement statements are anticipated to post timely. ERCOT requests Market Participants experiencing issues related to the delayed posting of the data extracts above including difficulties in meeting settlement dispute deadlines for Real Time Market Initial Settlement Statements to contact their ERCOT Account Manager or ERCOT Client Services.
CONTACT:  If you have any questions, please contact your ERCOT Account Manager. You may also call the general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT Client Services via email at [log in to unmask]<mailto:[log in to unmask]>.
If you are receiving email from an ERCOT distribution list that you no longer wish to receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.


sa