Recently in SWAMP Maintenance Category

As mentioned in an earlier blog, I've been working more with SWAMP, a custom Oracle-based application used here at the Physical Plant.

Mike has shown me some of the steps he takes when he receives routine requests to to correct data-entry on the part of end-users. Usually, these tasks involve simply querying, then editing, data from within the various Oracle tables. As Mike was involved in the actual development of SWAMP, his experience tells him which tables to edit. As I gain more experience with the application, my knowledge of the tables will become more intuitive.

I've also completed a new report within SWAMP to list open work orders. Querying the table and displaying the data was very simple, but the formatting of the data into two columns per page and the ordering of the data alphabetically involved more work. Mike ended up giving me some great guidance, as he has written several reports within SWAMP. We rewrote the procedure, and were able to get the data to display properly.

I've been working on a new report for the SWAMP application that will list open work orders within the Physical Plant. Mike developed the basic query to get the appropriate records within the FMM30.REQ table, and I've been working on formatting of the report. We want the report to display three columns across the page, listing only the work order number and title in each of the three sets. This formatting has been a good challenge for me to figure out how to determine when to break the rows and pages.

This week I had the opportunity to work with Mike to resolve a couple of problems within the SWAMP application. Within the Pre-requisition (“Prereq”) form, we increased the length of the quantity field from 4 to 6. We had to modify the header of that part of the form, as well as the actual form text input, with code in two different packages. Modification of the code was very simple, but it took us a couple of minutes to work through the package to get to the actual procedures that we needed to change. SWAMP is a very complex Oracle application.