NOTICE DATE:  December 20, 2013

NOTICE TYPE:  M-A121813-06 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 table below provides updates on extracts with issues preventing 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

12/21/2013

12/22/2013

Default Profile ESIID Report

COPG-197

Posted 12/19/2013

Posted 12/20/2013

Posted 12/20/2013

Posted On Time

May post late

May post late

ESIID Service History & Usage Extract

ZP12-245

Posted on time

Posted on time

Posted 12/20/2013

Posted On Time

May post late

May post late

Load Estimation Counts Report - Certified

COPG-767

Posted 12/19/2013

Posted 12/20/2013

Posted 12/20/2013

Posted On Time

May post late

May post late

Load Estimation Counts Report – Public

COPG-316

Posted 12/19/2013

Posted 12/20/2013

Posted 12/20/2013

Posted On Time

May post late

May post late

Public Reference Data Extract (PRDE)

ZP12-465

Posted 12/20/2013

Posted 12/20/2013

Posted 12/20/2013

May post late

May post late

May post late

Recorder Extract

ZP11-489

Posted on time

Posted on time

Posted 12/20/2013

Posted On Time

May post late

May post late

RID Extract

ZP11-532

Posted on time

Posted on time

Posted 12/20/2013

Posted On Time

May post late

May post late

Settlement Inputs Data Extract

NP12-753

Posted 12/20/2013

Posted 12/20/2013

Posted 12/20/2013

May post late

May post late

May post late

Supplemental AMS Interval Data

COMS-456

Posted on time

Posted on time

Posted 12/20/2013

Expected to post today

May post late

May post late

Supplemental IDR Required Interval Data Extract

COMS-457

Posted on time

Posted on time

Posted 12/20/2013

Posted On Time

May post late

May post late

TDSP ESI ID Extract

ZP15-612

Posted 12/20/2013

Posted 12/20/2013

Posted 12/20/2013

May post late

May post late

May 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 17, 2013 will not be included in the data request output files until the technical issues are resolved.

ERCOT continues work on the software issue with the replication of data from its financial settlement system into its data warehouse in which replication of some market data sets causes 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 sets in question by its replication system.  The replication system has completed processing of the data set that caused significant delays in processing earlier this week.  ERCOT expects the backlog to decrease and to progress towards publication of extracts at normal levels in the next few days but data sets similar to the ones that caused the delays may reverse this trend until the root cause of the software issue is identified.   ERCOT will provide another update on the processing of data extracts as well as its effort to find a resolution on Monday December 23, 2013. 

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