{"id":723,"date":"2024-09-15T11:34:19","date_gmt":"2024-09-15T06:04:19","guid":{"rendered":"https:\/\/saurabhjain.dev\/?page_id=723"},"modified":"2024-09-15T11:34:19","modified_gmt":"2024-09-15T06:04:19","slug":"uti-generator-lib","status":"publish","type":"page","link":"https:\/\/saurabhjain.dev\/?page_id=723","title":{"rendered":"UTI Generator Lib"},"content":{"rendered":"\n

Introduction<\/strong>
Wholesale Energy markets in Europe are regulated by ACER (European Union Agency for the Cooperation of Energy Regulators). The agency has published Transaction Reporting User Manual (TRUM) to facilitate reporting. The TRUM is intended to provide market participants with guidance to make informed decisions about their transaction reporting obligations.
Please refer to the following link for details: https:\/\/www.acer.europa.eu\/remit-documents\/remit-reporting-guidance<\/a>
Annex IV provides guidance on generation of UTI (Unique Transaction Identifier). Under this Annex, the Agency has developed and published an ACER algorithm which would enable market participants to generate an UTI from the economic terms of the bilateral trade.
This library (https:\/\/gitlab.com\/saurabhjain1537\/acer-uti-generator<\/a>) is Java implementation of the ACER UTI Algo version 2.2<\/p>\n\n\n\n

Deployment<\/strong>
Client applications need to include uti-generator jar and dependency jars in class path. Then invoke following method to get UTI based on Trade attributes.<\/p>\n\n\n\n

reporting.utils.uti.UtiGenerator.generateUTI(TradeDetails)<\/code><\/pre>\n\n\n\n
Please refer to the project ReadMe for Installation and Usage example.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
Class Design<\/strong><\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
ACER Algorithm vs ACER Generator Excel<\/strong>
ACER TRUM Annex IV v2.2 provides excel based implementation of the algorithm as well. However, there is a difference in handling of Price<\/strong> and Quantity<\/strong> columns between Algorithm and Excel implementation.<\/p>\n\n\n\n
Price<\/strong>
It is mentioned in the ACER guide that Price should be denoted in Currency Per QuantityUnit. Please see this snapshot:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
The ACER provided excel implementation doesn’t follow this and divides price by quantity.
In the following example, input Price is 53.5 GBP Per MWh\/h.
Quantity Units MWh\/h is same as MW.
Expected Price in the concatenated string is 53.5 GBP Per MW.
The excel divides the Price by 1000 (which is the Quantity) and uses the Price 0.05350 GBP Per MW.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
Quantity<\/strong>
Quantity should be converted to a standard unit. Please see this snapshot:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
The ACER provided excel implementation always calculates Quantity as 1.0
In the following example, input Quantity is 24.0 MTherm\/d.
Equivalent to 24000000.0 Therm\/d
Expect Quantity in the concatenated string is 24000000.0 Therm\/d.
The excel divides the Quantity by Quantity and uses 1.0 Therm\/d.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
As per general understanding, Price and Volume values are same in all of the following rows.
Standard format should be S.No. # 3 as per the ACER guide.
Price = 12000 EUR per MW
Quantity = 0.02 MW<\/p>\n\n\n\n
S.No<\/em><\/strong><\/th>Price<\/strong><\/th>Price Unit<\/strong><\/th>Volume<\/strong><\/th>Volume Unit<\/strong><\/th>Monthly Amount<\/strong><\/th>Amount Unit<\/strong><\/th>Monthly Volume<\/strong><\/th>Unit<\/strong><\/th><\/tr><\/thead>
1<\/td>12<\/td>EUR per Kwh<\/td>480<\/td>Kwh\/d<\/td>172800<\/td>EUR<\/td>14400<\/td>Kwh<\/td><\/tr>
2<\/td>12<\/td>EUR per Kwh<\/td>20<\/td>Kwh\/h<\/td>172800<\/td>EUR<\/td>14400<\/td>Kwh<\/td><\/tr>
3<\/td>12000<\/td>EUR per Mwh<\/td>0.02<\/td>Mwh\/h<\/td>172800<\/td>EUR<\/td>14.4<\/td>Mwh<\/td><\/tr>
4<\/td>12000<\/td>EUR per Mwh<\/td>0.48<\/td>Mwh\/d<\/td>172800<\/td>EUR<\/td>14.4<\/td>Mwh<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Configuration<\/strong>
A properties file uti-generator.properties<\/em> can be included in the client application classpath to configure a following properties: <\/p>\n\n\n\n
    \n
  1. DBFilepath<\/strong>\n