« February 2007 | Main | April 2007 »
March 22, 2007
Invoice Selection - Fzrinvs
I was tracking down an AP check issue annd realized we were running a mod of farinvs that hadn't been pushed forward since banner 3.1 Baseline is now banner 7.1 for the job submission program. Most of our mods on this weren't well documented. So I took the baseline and added wou mods plus documentation. Note that I had to remove the method column to fit in the approval and hold ind. This won't mean much unless we start doing ACH in finance.
Posted by wendlerb at 11:48 AM | Comments (0)
March 21, 2007
Web Grading
The registrar let us know that the W grade was showing up in the drop down list of available grades to give a student on the web grading package. This is package bwlkffgd. We had set this up last year and got it to work. I looked at the cursor SHRGRDE2C and noticed it changed quite a bit on the 7.3 package which came in since we last looked at it. The effective date logic of the cursor was incorrect so I fixed it and it looks to be working ok now.
Posted by wendlerb at 10:48 AM | Comments (0)
March 19, 2007
Form fun
Spending a lot of time getting a mod on two tab forms to work. Turning out to be a lot harder than anticipated.
Well, it took awhile but I think I finally got the hang of these tab forms. It sure is a little trickier than the plain forms. Basically, you have to look for some kind of tab trigger under the main trigger section in order to add code for dealing with whatever new block in an existing tab or creating a new tab. The order of the blocks now affects things on the form as well. Creating a new tab is easy enough but unless you get to this tab trigger you can't click to it or get a query of existing data
Posted by wendlerb at 11:43 AM | Comments (0)
March 16, 2007
Smrrule (cont)
SCT was giving out functional capp person a load of crap insisting that his problem was because our database optimizer was set to CHOOSE. So I had the dbas set woudev to RULE and start the capp background processes. Josh found the same thing happening so now maybe SCT will start to look for the real reason. Note that woudev was also refreshed.
Posted by wendlerb at 1:41 PM | Comments (0)
March 8, 2007
Smrrule
Capp compliances have been one of the more buggy of Banner applications that I've seen. Patches come out for it all the time and I'm a little worried about it getting too far ahead of other patches we haven't installed.
Anyway, yet another problem with smrrule/smrcmpl. When you hit the copy button on smasadf it doesn't bring in records correctly. Some SCT tech is telling us it's because our optimizer is not set to Rule with Oracle 9. Since we're on Banner general 7.3, we can't set the enviroment to Rule. I wanted SCT to specify where the problem was in the code but got nowhere. So, I've added the Rule hint to a bunch of cursors in smrrule. We'll see if that changes anything. I wouldn't think so.
Posted by wendlerb at 3:24 PM | Comments (0)
March 6, 2007
Banner credit card
We noticed we started having several 200603 term charges on baseline credit card payments even though the defaults are set to 200602. Normally the student gets to the credit card through the finaid release/term summary conbo. The link is actually to a term select procedure which defaults the 200602 value. If you call the payment package directly, you go to a term select paage first which uses whatever terms are enabled for registration in a drop down menu. I figured out that students were using the search feature on student web to look up credit card and then clicking on the link to the credit card payment procedure directly. This brings up the select term choices. I changed the default in bwskcpmt to not do this.
Posted by wendlerb at 8:39 AM | Comments (0)