« May 2006 | Main | July 2006 »
June 28, 2006
Fee assessment bug
AR ran into a problem when rerunning fee assessment in a prior term to current. My record was one that got hit by it of all things. Several people who were on staff rates or special rates were getting the staff rate in the previous term reversed and charged the basic rate by this 2nd run of fee assessment. It turns out to be a problem with the form SFAREGS. When you change a fee rate from the option menu it not only creates a new record in SGASTDN with the new term but also updates the previous term fee rate on the old record. This is not the case if you put a record into SGASTDN directly but only if you do it from SFAREGS. So if you change someone to basic to run summer fee assessment, you're going to turn the spring SGASTDN record to basic as well. Do another spring assessment and wham...the basic rate gets applied.
This appears fixed in SFAREGS ver 7.3x
Posted by wendlerb at 1:58 PM | Comments (0)
June 27, 2006
Banner printers
Setting up a new Banner printer involves several steps.
First, you have to email ETS and ask them to create a new printer queue. They will require the ip address of the printer, the model, type (PCL,PS), location, and contact. The queue name always begins with W_xxxxxxx.
Next, you have to enable the printer to print from the cedar and spruce ip addresses. You have to login to the printer itself and add 140.211.10.26 and 140.211.10.27 to allowed addresses
Next you have to add the print queue to GTVPRINT in Banner in both instances.
Posted by wendlerb at 10:43 AM | Comments (0)
June 23, 2006
Pipe process
Thought maybe I ought to document this process since I have to deal with it every once in a while.
Sfrpini is job submission program that kicks it off. It passes the orasid to another process, sfrpips.
Sfrpips has a submit statement at the end of the com file with a lot of database specific hardcode in it. The program builds 3 runtime com jobs based on pipe names in the table SFBPIPE.
These run time com files typically look like this:
$ smrcmpl := $gen$exe:smrcmpl.exe
$! Running SFRPIPE.EXE with user SATURN/
$ set nover
$ @its$util:[oratools]orauser.com 'WOUDEV'
$ sfrpipe := $gen$exe:sfrpipe.exe
$ sfrpipe SATURN/DEV$WOU PIPEWDEV1
$exit
You can see log file of these *pipe* jons in the spool directory. You can see that two other jobs are called in this com file.
If the process executes correctly, you can see the 3 pipes with the command: sho que spruce_posting$batch/all
Posted by wendlerb at 9:07 AM | Comments (0)
June 22, 2006
SZRPINI
This pipe job submission program combines two programs in it's com file:sfrpini and sfrpips. The com files of these have unique statements matchung the database it runs in. So, you can't just copy production com files to one of the dev databases and have it work. I also found out that sfrpini needed to be compiled in woudev to get it to work in woudev. There is also a tablr (SFBPIPE) that has pipe names in it which need to be changed to the database you're in.
Posted by wendlerb at 9:52 AM | Comments (0)
June 15, 2006
Loan feed
Tbrmemo has added 3 new fields. Tbraccd remains the same
SWBRDLL and SWBRPFD have changes to them and are located in woud:[wou_sis_mods.c] These will need to be moved into production when we go live.
Posted by wendlerb at 11:34 AM | Comments (0)
June 14, 2006
Woudev
Wou mods placed on packages
compiler hint added to all views with spriden
Forms compiled in upg path
Menu fixed
SZZDCRV - the baseline has changed so much I can't even put wou mods on new version
GUAGMNU - returning to baseline
SPAIDEN - tested with ssn, generated, name change, and corporation.
Posted by wendlerb at 2:50 PM | Comments (0)
June 12, 2006
WOUDEV/WOTR
This is at 7.3 now. It looks like id stuff hasn't changed since 7.2 version which would be good news. Form server not quite ready so can't really test yet this morning. Hoping we might be able to take some stuff back to baseline. Checking the views now.
Posted by wendlerb at 11:14 AM | Comments (0)
June 9, 2006
Staff Dev
I spent some time yesterday playing around with downloading an instance of the Oracle 10G database on a Windows Server 2003 box. The GUI interface to it is kind of nice. You do it through a normal web browser. I think I may actually leave it there but I have to figure out a tnsnames entry for it and not sure if I can connect using the mash domain.
Posted by wendlerb at 9:09 AM | Comments (0)
June 5, 2006
EDI Cron
SZASFTP - 10:15 am SFTP transfer of sedirec.dat from EDI server to com directory on wouprd.
SHREDIR - 10:30 am Banner job submission to populate ack on request
SHREDIY - 4:00 pm Banner job submission generates EDI transcript files from request.
Look - 4:15 pm Banner job submission transfers shrediy files to ftp location on spruce.
SZPSFTP - 4:25 pm SFTP transfer of sedixxx.dat files from spruce to EDI server
Posted by wendlerb at 9:44 AM | Comments (1)