« August 2007 | Main | October 2007 »
September 26, 2007
Student web student general info (bwskgstu)
We are thinking of turning on bwskgstu.P_StuInfo in wouprd. Right now it is on in woutst. Banner team has requested that advisor email address be added along with secondary advisors and types. Delving into the package it looks like the mod need to go into bwckstu.p_getadvrinfo and
bwckstu.p_stuinfo packages. I added a few cursors and some items to the display. Waiting for approval.
Posted by wendlerb at 10:30 AM | Comments (0)
September 25, 2007
Sept 21 Feed
The Friday night feed aborted during application of payments (TGRAPPL).
The lis file had the following error:
The Balance may not exceed the original Amount.
processing PIDM and transaction 378314 126
This turned out to be a CBORD transaction which was a parking credit, detail A820. It turns out the balance input into Banner was 72 instead of -72.
6 records out of 325 (trans date 21-SEP-07, detail A820) tried to apply before the abort. These are pidms 378186,374710,364792,373113,373453,361307. We could not unapply it through the form. I went on manually and removed the incorrect record from the table tbrappl and saved the original in a lis file.
We manually ran application of payments on 2 records which worked. The feed ind on all these 325 records is still set to Y with no feed doc or date.
Last night none of these 325 records fed although tgrappl didn't abort. The rest of the stuff fed ok.
We stuck these 325 records in a seperate cashier session (818) and finalized and will see if it feeds tonight.
It fed on session 818
Posted by wendlerb at 11:43 AM | Comments (0)
September 18, 2007
Master To-Do List
Get max employee parking primary and secondary numbers - set seq in wouprd
Final Feed
Final AR Feed
Follow shutting down access to banner web blog
Wait on refreshes and new wouprd build
Get new max for fdoc number from feed and set in FOBSEQN
Get links changed to new INB link.
Make sure fabinvh_match_required is set up with a default of 'U'
Follow ID creation blog entry
Bring over employee tax stuff
Make sure forms are correct (GUASYST gets removed.)
Build correct menus using GUTGMNU
Open Banner Web
Follow Banner web blog
Open access to web for all
Change wops link in wou_util to wouprd
Remoce szpvpad from cron
Follow employee parking blog
Posted by wendlerb at 9:16 AM | Comments (0)
September 17, 2007
Shutting down access to Banner web
Giving access in order to get into Banner web by the dbas gives it to everybody. In order to limit it while I fix the menus I can do the following.
Login to what was student
go to web tailor and custimize twbkwbis.P_ValLogin
Only allow local role as Web tailor Administrator
Unclick Non Secured Access Allowed
Posted by wendlerb at 11:49 AM | Comments (0)
September 14, 2007
Forms 7.4
What a week
Anyway, I put wou mods on forms I grabed out of the 74 directory on spruce. Several forms actually made the mods we put in on the 7.3 forms so they can go back to baseline. Several others don't need the spriden hint and can go back to baseline. I didn't see any AR forms on spruce. GUASYST no longer needs a link and will be back at baseline. SZZDCRV is still from 7.2 and the new base version has changed quite a bit so I don't know if this will still work or not.
Posted by wendlerb at 2:58 PM | Comments (0)
September 11, 2007
CAS Issues
Courses that could not be articulated (ie basketweaving 101) were not sowing up at the bottom of the program guide. This turned out to be a bug in swrcaso with a cursor selecting courses out of load_unarticulated_messages(). Test_inst defaulted to null if nothing gets set up in gtvsdax. So I set up gtvsdax for CAS_INFO and it worked. OUS modified swrcaso to fix this so it shouldn't be an issue if we forget the sdax entry.
The second issue was none of the questions related to attributes was working. I double checked setup under the answers against what OSU is using and we were identical. However, when answering no to the foreign language question, nothing showed up and not even a log file got generated. It turns out a table was defined with not null in the columns. OSU altered it to allow nulls but we didn't have it done in woutst. Once that was done, it worked ok.
Posted by wendlerb at 3:15 PM | Comments (0)
September 6, 2007
Failed SOIDEN searches
The business office noticed that some people could not be found when doing a SOIDEN search on their name. You also could not move around correctly in Spaiden with them. Some forms looked like there might be an extra space in the first name for these people. Indeed there was and it caused these banner form issues. I looked further and found they were coming from the admissions credit card piece. So I did a rtrim on the first name of all spriden records with a user id of WOU_SIS_UTIL and removed the extra space. In the package I added an update on the spriden record created to rtrim the first name.
Posted by wendlerb at 2:54 PM | Comments (0)
September 5, 2007
CAS changes
CAS has had several changes to the program request process. Several capp tables are copied under the schema cassmgr. The web program uses the Banner capp process on these tables instead of Banner.
Smrcaso is the com file that gets called on submit. It fires smrcmpl and then the modified swzcrlt instead of smrcrlt. I use swzcrlt because we've made several changes to the output file and I didn't want to affect a regular compliance.
Posted by wendlerb at 10:02 AM | Comments (0)