NOTICE DATE:  December 20, 2013

NOTICE TYPE:  M-A121813-05 Extracts

SHORT DESCRIPTION:  Update - Missed report postings on MIS –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	12/20/2013
Default Profile ESIID Report	COPG-197	Posted 12/19/2013	Expected to post today	Expected to post today	Expected to post today
ESIID Service History & Usage Extract	ZP12-245	Posted on time	Posted on time	Expected to post today	Expected to post today
Load Estimation Counts Report - Certified	COPG-767	Posted 12/19/2013	Expected to post today	Expected to post today	Expected to post today
Load Estimation Counts Report – Public	COPG-316	Posted 12/19/2013	Expected to post today	Expected to post today	Expected to post today
Public Reference Data Extract (PRDE)	ZP12-465	Posted 12/20/2013	Expected to post today	Expected to post today	Expected to post today
Recorder Extract	ZP11-489	Posted on time	Posted on time	Expected to post today	Expected to post today
RID Extract	ZP11-532	Posted on time	Posted on time	Expected to post today	Expected to post today
Settlement Inputs Data Extract	NP12-753	Posted 12/20/2013	Expected to post today	Expected to post today	Expected to post today
Supplemental AMS Interval Data	COMS-456	Posted on time	Posted on time	Expected to post today	May post late
Supplemental IDR Required Interval Data Extract	COMS-457	Posted on time	Posted on time	Expected to post today	Expected to post today
TDSP ESI ID Extract	ZP15-612	Posted 12/20/2013	Expected to post today	Expected to post today	Expected to post today

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 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.  The replication system has completed processing of the data set in question and ERCOT expects the backlog to decrease and publication of extracts to resume at normal levels.  Further details on the progress of processing the backlog will be provided later today. 

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].

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.

dg