Hotfixes
Version 1 - Reviewed: April 29, 2016
Hotfix: Cancel FTRV breaks Tariff Timeline and Publish Tariff
TariffShark's time slicing capability identifies the currently effective TRVs at any point in time. When a Tariff Record is cancelled and the cancellation is marked "Effective" (or "Retired"), TRVs belonging to the cancelled Tariff Record must be omitted from time slicing results. In other words, there must be no effective TRV after the point in time when a Tariff Record is effectively cancelled.
An issue has been identified whereby the mere presence of a Cancel FTRV causes a Tariff Record's TRVs to disappear from time slicing. TariffShark is not waiting for the Cancel FTRV to be marked as "Effective" (or "Retired").
Resolution
The fix for this issue must be patched into the TariffShark database. Therefore, it must be applied by a database administrator (DBA) or other person with direct access to SQL Server and the TariffShark database.
- Visit the Downloads page for your TariffShark Hammerhead release.
- From the Downloads page, download the hotfix file provided under the heading "TariffShark Hammerhead Database".
- The hotfix is a zip archive that contains a single SQL script file. Extract the SQL script file from the zip archive and save it to your desktop.
-
Using SQL Server Management Studio (or equivalent database management interface), run the SQL script against the TariffShark database. If the script runs successfully, the output will include the following messages:
Script patches dbo.SearchTariffTimeline stored procedure (Issue 4189) dbo.SearchTariffTimeline PATCHED.
If you do not see both of these messages, contact TariffShark Support
More Information
Support
Contact
Business Hours
About
TariffShark is a full life-cycle e-tariff management software solution that generates FERC-defined XML in an on-premise or hosted environment.
Effective April 1, 2010, The Federal Energy Regulatory Commission (FERC) revised its regulations to require that all tariffs and tariff revisions and rate change applications for the public utilities, natural gas pipelines, oil pipelines and power administrations be filed electronically according to a set of standards developed in conjunction with the North American Energy Standards Board (NAESB).
The Commission requires that all tariffs, tariff revisions and rate change applications be filed electronically in the manner prescribed by Order No. 714. The affected required filers are:
- Public utilities and Power Marketing Administrations under Parts 35 and 300;
- Natural gas pipelines under Parts 154 and 284;
- Intrastate gas pipelines under Part 284; and
- Oil pipelines under Part 341.
Contact Us
Suite 220
Schaumburg, IL 60173
Sales: (847) 252-7286
Support: (847) 252-1611
Fax: (847) 252-7282
Email: [email protected] Schedule a Demo
Monthly Newsletter
Subscribe to our newsletter and stay up to date with the latest news and deals!
Stay Connected
2024 © Links Technology Solutions, Inc. All Rights Reserved.
