September 4, 2008
Troy Dimms
There are 3 Troy 4100 series check printers on campus. W_MONEYMACHINE is the AP checkprinter. W_SISCHECK is the cashier's printer for SIS checks. W_CHA_CHING is in feepayment and is a hot backup for either sis or ap printers. Remember that the Banner queue is tied to the ip address determined by the network card in the printer. Each printer has 2 dimms. One is troy firmware and one is ours. Moneymachine and cha_ching both have our check images in dimm 0. Sischeck has them in dimm 1. You can't change this. It is determined by what Troy initialized their own dimm to
In order to move files back and forth, you need to pull the network card, hook up to the printer with a bidirectional cable on lpt1, and add the printer to your machine on lpt1. The files that go in there are in the business office group.
SIS all on dimm 0:
DARIN.all
LOGO.all
PAGE0.all
SEAL.all
FIS all on dimm 0:
DARIN_AP.all
LOGO_AP.all
PAGE_AP.all
SEAL_AP.all
Initialization file:
INIT0.all
Print test:
TEST1.all
In order to execute one of these files you have to run from dos in the appropriate directory the command....... copy filename.all lpt1: They either copy a macro to the dimm or in the case of test1,make a test printout of the macro. You will see the printer flash processing job if you are talking to it correctly
The software used to generate these files is tform.exe from the versacheck disk. You create a numbered macro and then go to flash/dimms under print and download to a file
SISCHECK is all on dimm1 and the sis files above won't copy over. They're ponted to dimm 0. You can either try editing them to dimm1 with a binary editor or using tform. In tform you would open filename.grp. Go to file/print/RAM-FLASH-DISK. Select the lpt1 printer in the Driver/Port. Choose the fsa xxxx Device 0 or fsa xxxx Device 1 depending on which dimm you want the macro to go to. Select download and download to file.
Posted by wendlerb at 9:17 AM | Comments (0)
July 3, 2008
FWPCHKP
Once in awhile checks with multiples print the detail several times. It also doesn't page correctly which is wierd. There's a counter that formats a new page in the while loop that never kicks off. This is driving select statement
EXEC SQL DECLARE cursor_030 CURSOR FOR
select distinct fatckin_vend_inv,
TO_CHAR(fatckin_invh_date, 'DD-MON-YYYY'),
fatckin_net_amt,
FARINVC_VEND_INV_CODE,
TO_CHAR(farvinv_vend_inv_date, 'DD-MON-YYYY'),
farinvc_invh_code,
sum(farinvc_appr_qty * (farinvc_appr_unit_price) + farinvc_addl_chrg_amt - farinvc_disc_amt)
from fatckin,
farvinv,
farinvc x
where fatckin_check_num = :rpt_chk_no_an
and fatckin_invh_code = farinvc_invh_code
and farinvc_invh_code = farvinv_invh_code(+)
and farinvc_vend_inv_code = farvinv_vend_inv_code(+)
and fatckin_vend_inv > rpad(:prev_rpt_vend_inv,25,' ')
and fatckin_vend_inv is NOT NULL
group by fatckin_vend_inv,
fatckin_invh_date,
fatckin_net_amt,
farinvc_vend_inv_code,
farvinv_vend_inv_date ,
farinvc_invh_code
order by farinvc_vend_inv_code;
I just added a nvl to the first value because the loop depends on it having a value.
We'll see if it makes a difference
Posted by wendlerb at 9:40 AM | Comments (0)
June 13, 2008
Treasury
Ok, first its *p425x880Y and they want it moved left so I move 1 char left
Then it's *p395x880Y and they want it moved 1 char right
I guess I'll try splitting the difference
Posted by wendlerb at 1:48 PM | Comments (0)
May 9, 2008
ACH
Job submission programs
OUS:
fzbmail
fapdird
fwremax
WOU:
fzrinvs
fzrpach
Form
OUS
fwapach
The vendor/seqno address type has to match across ftmvend,gxadird, and goaemal
Posted by wendlerb at 1:08 PM | Comments (0)
March 24, 2008
wouchek initialization error
Found a note on the SCT self service site that described the error we get the first time you log into wouchek in a session. You get the form cannot be found error and then it continues on to the form and you don't see the error again the rest of the session. The note said when you make a custom form and start with a copy of a form like spaiden, it looks for soqmenu.fmx when it initializes the form. You needed to copy soqmenu and rename it to so the custom form can find it. So I copied it and renamed it to woqmenu. I compiled it to upg and it worked. So, we are placing in production.
Posted by wendlerb at 9:45 AM | Comments (0)
March 13, 2008
wouchek
We've been having a problem with student checks where the doc num and check num are getting out of sync. The original check form selects an oracle sequence for each one at the same time in the code. There's a known oracle bug where the sequence number will skip whatever is left in the sequence cache once in awhile and this appears to be what is happening. The recommendation is to set the cache to 0 and make it get it from the disk every time. I had hoped the 10G upgrade would solve this but instead it got worse.
So, I changed the form and szpbchk to get the number from the check sequence and set the cache to 0. Then I just used the same value reurned for both doc num and check num. Since they are always supposed to be the same, I should be fine. Not sure yet what the 0 cache will do under a load.
Posted by wendlerb at 11:51 AM | Comments (0)
May 14, 2007
New check format
OUS has requested a change in formats of WOU checks as per a reuirement from US Bank. All trailing and leading asteriks need to be removed from amounts and USD or Dollars has to be added to long printout. WOU is currently only school using FWPCHKP. The other schools use a third party vendor. Now, they are moving back to job submission. However, their check stock prints the check on the bottom and not the top like ours so we agreed to continue to support our own mod. I have made the changes by mosifying the cents variable and changing add_comma procedure along with the lpad procedure.
Update: 6/07/07
Checks approved by treasury and US Bank. Mods moved to production
Posted by wendlerb at 9:28 AM | Comments (0)
April 9, 2007
Banner problems this am - student checks
Banner was freezing up during logins starting around 8:30 am this morning and ETS had to restart the oracle listener several times for banner. Looks to be related to the listener on Aero which gets hit everytime someone tries to get into the student warehouse. Looking into Aero logs.
In the meantime the business office ran batch student checks before we figured out what was going on. So I had 22 student checks in la la land. The process completed but made a 0 block lis file. I looked further and found these records stuck in the collector table TGRZCHP. I had to temporarily modify the check program to comment out the sessionid stuff on the collector select. Then I ran the program to create the list file and then went into the tgrzchp table and removed the records manually. Reset the code back and things appear back on track.
Posted by wendlerb at 2:27 PM | Comments (0)
December 12, 2006
Fwpchkp
We've had an issue with AP checks and multiple invoices for a long time. Every once in awhile the listing of multiples repeats itself on the check printout. Never happens consistently. The check amount and totals are fine. We put the mod in to handle multiples so they'd print out so it's definately our problem. I don't know why I would have tried just using a distinct statement in the select. I have a feeling I did and it caused some other problem but I will soon know. We tried it out in wotr and it seemed ok so I'm putting into production.
Posted by wendlerb at 10:25 AM | Comments (0)
November 16, 2006
Checks not fed
Last month when the system glitch caused the feed to run multiple times, when ended up with checks that had their accounting fed but not the check. A couple of people have already cashed the checks. Jeremey ran into this situation once before so already had a scipt to handle it. It creates a stand alone fgp.lis file. See README.FIS_CHECKLOAD
Posted by wendlerb at 9:51 AM | Comments (0)
September 19, 2006
Check doc num mismatch
We had a series of checks print on SIS where the doc num did not match th check num. Have no idea how this happened but the two sequences were off from each other so I reset them to match the next check number. Tey seem to be fine since. I fixed about 9 bad records in banner by updating tables tgrzchk and tbraccd.
taismgr.tgrzchkd
taismgr.tgrzchkc
Posted by wendlerb at 2:54 PM | Comments (0)
January 5, 2006
Computer upgrades
Sally got a new computer. Need to make sure computing services realizes that her compuer has specific setup for check printing. Folder on network must have got corrupted somehow causing a big headache. Driver for printer is specific to Troy but named the same as a regular hp driver. It is not the same however.
Posted by wendlerb at 2:10 PM | Comments (0)
November 28, 2005
AP momeymachine
AP check printer dimm lost all it's files this afternoon so the check run didn't come out right. I noticed the missing files on the file directory so I took the printer over to my desk and tried to reload the files. I got a disk operation error on the front of the printer. I reinitialized the dimm and tried again. This time the files copied and stayed on there after powering down the machine and turning it back on. We finished the check run but I'm not sure what knocked the dimm out of whack in the first place.
Posted by wendlerb at 3:52 PM | Comments (0)
October 13, 2005
This and that
Started getting strange things going on with the student check system yesterday late afternoon. Checks were being duplicated or taking 2 pages to print, etc. Looks to be that the were coming from WOUCHEK running on a particular machine. Had them reboot. Also have request to set up audit mode on batch check process.
Posted by wendlerb at 8:04 AM | Comments (0)
June 21, 2005
Payroll checks
Check printing in payroll has undergone significant changes since we went to Banner INB forms. It’s worth noting, however, that the old client-server setup still exists and has saved our butts on a few occasions. We will lose this when we upgrade to banner 7.1 unfortunately. Payroll uses a pair of Troy 524 Micr printers. Unlike the Troys we use for SIS and AP checks, there is no special dimm in this printer. Although the check printing process is now run from job submission, the client it runs on still has to have the printer set up on the machine as a shared printer with the software font dimms added to the driver as well as the fonts to the windows folder. The name of the printer has to match the Banner queue. The driver for this Troy has the same HP name as the driver for the corresponding HP printer but it is a different driver. Payroll has manuals for how to print a check. The only thing that might foul you up is if popups from OUS aren’t enabled or the domain of the client changes. Also note that the payroll check process will allow you to reprint a check. A lot of times if something goes south, you can just do a reprint on the check.
Posted by wendlerb at 1:40 PM | Comments (0)
June 7, 2005
AP Checks
The AP check printer is also a Troy MICR 4100 Secure Ex. It also has dimms containing files for the logo, seal, signature, and page format. These are files 16,17,18,19 on the dimm. The code in the program for these files looks something like CHR(27)||'&f16y3X'. The files themselves are in a directory under the business office folder. Use the bi-directional parallel cable, go to that directory in a dos prompt, and copy the files to the printer using the command copy filename.all lpt1. The tricky part is that these files are set for directory 0 on the printer. This is ok for moneymachine and cha-ching but sischeck has all its stuff in directory 1. The Banner queue for the AP check printer is w_moneymachine. The Banner job submission to print checks is FWPCHKP, another WOU mod of baseline. Most other OUS schools don’t use this but run a program similar to our payroll check printing for their AP and SIS checks. In our case, it actually saved us a lot of headaches when we went to INB because Oracle Reports didn’t work correctly. FWPCHKP prints checks off several tables such as fatckin. The next step in the process is running a job submission to post the accounting. This is noteworthy because once the records are posted to accounting, the records in the tables used by the check printing(FWPCHKP) process are purged. When trying to debug an issue that came up during the check print, you can’t regenerate it once its accounting is posted.
Posted by wendlerb at 11:54 AM | Comments (0)
June 6, 2005
Check Printing SIS
The SIS check printers are Troy MICR 4100 Secure Ex. These are essentially an HP 4100 with a Troy dimm added to handle the micr font. The Banner queues for the two printers are w_sischeck and w_cha-ching. The signature, seal, page format, and logo on the checks are all pcl/macro files on a flash dimm(G7 Productivity Systems) in each printer. You can get a listing of files from the printer menu. The files were created using TransForm, a software package by Mips dataline America,Inc. The files are passed to the printer via a bi-directional parallel cable (ie. copy page.all lpt1) from command line. You can look at test1.all as an example of sending commands to the printer to see if a file is printing correctly (copy test1.all lpt1).
When you cut a check in Banner SIS using the WOUCHEK form, you are populating a collector table. The job submission program, SWBRCHK, is set up to run in sleep/wake mode every 20 – 30 sec. This sleep/wake job passes 5 parameters to the job TGRZTCH. This job checks the collector table and prints out a check for the records in the table. TGRZTCH is a mod of baseline and contains the Troy micr font PCL setting as well as the calls to the 4 files on the printer dimm. If you change the name of a file on the printer, you have to change it in the program too.
Posted by wendlerb at 9:51 AM | Comments (0)