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

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