A brief analysis of the new Sonris system
I finally had time to look at the new Sonris system. Here is what I found.
Input from a friend:
“Its APEX which is Oracle's reporting tool. We actually just moved off of it at work because it was so bad and ancient. We have API backends in our system, but I don't see any in theirs, but give me a few minutes tomorrow when I have some time and I'll see what I can figure out.
APEX does have a pretty predictable structure that generally allows for easily deriving what the hyperlinks should be. (And uses GET based commands which means that the variables are in the URL.) That seems to be the case with this report (such as below.) So worst case, we can do that.
For example Well Serial Number 123456 is https://sonlite.dnr.state.la.us/ords/r/sonris_pub/sonris_data_porta...[ig_master]_well_serial_num=123456
That should work for base data, but it appears that the document repos have checksums which are a little more challenging to directly link to."
Note: API stands for Application Programing Interface.
While I can’t speak to the Federal requirements it appears relatively easy to write bots for this. I appears the main reason they did this is to move to a system that does not need much programing. It is getting hard to find programmers that can program in the old languages such as COBOL and FORTAN as nobody teaches this any more (Pay is now $100-150K). APEX is mainly just configure it out of the box little programing needed. The down side is there is little that can be easily be changed without APIs.
I went through a similar SAP conversion before I retired. We spent hours in meetings being told this is you how you will do your job in the future. Hundreds of people working on this. Millions spent. They put HR, Accounting and the Mill order entry system on it. All departments had to add people to do the same job. They finally abandoned adding the converting plants after the schedule slipped by two years. All those responsible for this either quit or were fired.
Other notable conversions:
Hershey’s Chocolate – Lost millions after conversion. Could not ship product from warehouse in fourth quarter.
Conrail – Freight division – After conversion lost ability to deliver boxcars to some plants. They Actually had to load the freight from a remote siding outside the system into trucks and have the trucks deliver it. Took several months to resolve.
If I get any more feedback I will post it.
Views: 564
Replies to This Discussion
-
Permalink Reply by Skip Peel - Mineral Consultant on -
Thanks, full name. I'm hoping we get more tutorials this week from Carrie.
-
Permalink Reply by CB on
-
This new system is a total joke
. Can't look well by serial number like it used to be. Someone needs to get fired. Old system was fine. They spent millions to get this piece of crap.
-
Permalink Reply by Skip Peel - Mineral Consultant on
-
The new system is a federal requirement. I'm sure the state and the SONRIS staff would have preferred to stick with the previous database architecture but they didn't have a choice. So neither do we. Try this.
SONRIS > Data Portal > Well Information Search > Well Serial Number > Execute
Do not enter anything in any of the other search boxes.
-
Permalink Reply by Skip Peel - Mineral Consultant on
-
CB, let me know if you need any help.
-
Permalink Reply by CB on
-
I am familiar with the new system. A lot more work and time to get the same info I could get in a few seconds. Very complicated to get simple information.
-
Permalink Reply by Terry L. Antee on
-
Skip would you confirm the new system is a federal requirement???
-
Permalink Reply by Skip Peel - Mineral Consultant on
-
Yes, that is what the SONRIS staff have said.
-
Permalink Reply by Dale Walton on
-
It is beyond a joke. Maybe they are trying to have a website as bad as the Texas RRC. I have found that I don’t even look for new locations any more.
-
Permalink Reply by Skip Peel - Mineral Consultant on
-
Dale, by "new locations" are you referring to alternate well applications? The public hearing schedule?
-
Permalink Reply by Dale Walton on
-
No the new permitted locations. Searching now requires a lot data input.
-
Permalink Reply by Skip Peel - Mineral Consultant on
-
Try this link. It is functional now but may not be long term.
https://sonlite.dnr.state.la.us/ords/cart_prod/cart_con_allpmtwels1
Support GoHaynesvilleShale.com
Top Content
Groups
-
WESTERN HAYNESVILLE
12 members
-
Sabine Parish, LA
456 members
-
SMACKOVER LITHIUM GROUP …
10 members
-
Natchitoches Parish
405 members
-
Evangeline Parish
17 members
-
Bienville Parish, LA
248 members
-
SMACKOVER LITHIUM GROUP …
8 members
-
North LA Cotton Valley C…
67 members
-
Webster Parish
301 members
-
Cass County, TX
121 members
Blog Posts
Tuscaloosa Trend Sits On Top Of Poorest Neighbourhood For Decades - Yet No Royalties Ever Paid To The Community -- Why??
In researching the decades-old Tuscaloosa Trend and the immense wealth it has generated for many, I find it deeply troubling that this resource-rich formation runs directly beneath one of the poorest communities in North Baton Rouge—near…
ContinuePosted by Char on May 29, 2025 at 14:42 — 4 Comments
Not a member? Get our email.
© 2026 Created by Keith Mauck (Site Publisher).
Powered by
