« December 2007 | Main | February 2008 »
January 29, 2008
PWPCHKP
Payroll made a mistake trying to cut a manual check, didn't cancel and back out correctly, and tried to run it again. The process aborted and they were unable to create any checks. Pwpchkp aborted with the message: NO CHECK DATA FOUND IN TABLE PWRCNPB. CANNOT PRODUCE CHECKS. Checking the select statement there was a seq 0 and 2 in the table pwrchck for the individual but no seq 2 in the table pwrcnpb like there should have been. Seq 1 was the canceled check. Pwrchck has all kinds of foreign constraints on it so it is very difficult to delete a record on the table. Instead we set the print ind to Y to fool the system in thinking the record already printed. Payroll set up a new check for the person and then pwpchkp completed normally.
Posted by wendlerb at 3:34 PM | Comments (0)
January 25, 2008
1098T Records 2007
There were about 166 1098Ts for 2007 that had erroneous date in box 6 because of adjustments to financial aid prior to 2006. The business office did not have rules set up to handle adjustments that far back. So they pulled these forms out of the 7900 that got printed and asked me to fix them in Banner avoiding having to do the entire process over. I nulled out the ttbtaxn_amount_5 field on the records for 2007 and then had to deal with the tbraccd records. On tbraccd I nulled the tbraccd_tax_amount for these records where tbraccd_tax_rept_year was 2007 and tbraccd_tax_rept_box was AS. There were also two records with erroneous data in box 5 for grant adjustments. I followed a similar plan for those. The name of the form to view these records is TSATAXN
Posted by wendlerb at 9:48 AM | Comments (0)
January 24, 2008
CAS issue
When running a programming guide on CAS3, we got a printout of a log file instead of a compliance. Noticed this started after I stopped doing a regular compliance call in sfrpipe along with the Z stuff. Don't know if this caused an issue yet or not. I will try again to remove after CAS4 goes live. I stopped the pipes and restarted with the change and then got a swzcrlt file in ban_wouprd but the file was empty. You can look at swrcaso's com execution in the pipe2 log in the spool directory. So I'm not sure if my change caused the file to show up or if it was just restarting the pipes. Anyway, an empty file still causes the problem just aas if there was no file. Registrars had turned everything off on the printing rules for type Z so I turned them back on and got output. I didn't see the problem of Art giving a business compliance.
Posted by wendlerb at 9:44 AM | Comments (0)
January 16, 2008
Fgbtrnd/fgbtrnh archive process
We are considering using FOPARCP to archive the transaction tables. Currently the tables have records back to fiscal year 95. You have to be careful running this because it is the same process to purge records as well. Investigating two parameters which do a check reconciliation and grant edit. Not sure if we want to do that. Default value is Y. This was prompted by problems with fis warehouse feed and the transact.sql load. SOU runs through it in about 1/3 the processing speed it takes WOU. Taking too long and causing failure of the load across all 5th sites when we have a day with a lot of records to process.
Posted by wendlerb at 11:10 AM | Comments (0)
January 11, 2008
Third party ID - GOKTPTY
Well our decision to remove a bunch of gorpaud records really came back to bite us. We were getting errors trying to do a an admit decision, errors trying to do a curriculm change, errors in GOATPAD trying to make a new pin. All related to a table trigger on gobtpac that creates a third party gorpaud record. We kept getting a unique constraint error. Turns out goktpty procedure that checks the external user id does it in a loop counting the times it sees the external user id in gorpaud and appending a number on the end of the string. When we removed the records it no longer looped the correct number of times and returned a value for external user that already exists on gobtpac. Thus the unique constraint error. I modified goktpty to do a union looking at records in gobtpac as well as gorpaud. This seems to work.
Posted by wendlerb at 1:44 PM | Comments (0)
January 8, 2008
Web login - Third party ID
We ran into a problem with a student getting an error messege: Third party ID already exists when they tried to log into wolf web. Tracked it down to goktpty package that checks the gorpaud_external_user value to see if it matches any other pidm besides the user trying to login. If it does, it throws the error. Looks like we brought in about 1700 records in from the merge that match that criteria.
Posted by wendlerb at 2:53 PM | Comments (0)
January 4, 2008
fee assessment
The new version of sfkfees stopped working the same way as the current. When a student drops a class and then another class, they get two penalty records on tbraccd. The new version was reversing the first penalty charge. I made a change to the following in p_processfeeassessment
IF (sobterm_rec.sobterm_assess_swap_ind = 'Y' AND DROPS) THEN
-- WOU mod (sobterm_rec.sobterm_assess_swap_ind = 'Y' AND REVERSE_ZEROTONINE) THEN
p_process_hours_swap(pidm_in,
term_in,
phrs,
pstart,
pend );
END IF;
/* ****************************************************** */
/* 104667, if SWAPPING is OFF, and yet PENALTY REVERSAL is*/
/* still expected in an RBT, then do the following. */
/* ****************************************************** */
/* Wou Mod
IF ( NOT(PENALTY_REV_DONE)
AND NVL(sobterm_rec.sobterm_refund_ind,'N') = 'Y'
AND REVERSE_ZEROTONINE) THEN
p_rev_nonswap_RBT(pidm_in,
term_in );
END IF;
end Wou Mod */
Posted by wendlerb at 11:54 AM | Comments (0)
January 3, 2008
Direct Loan load - SWBRDLL
Because we've had issues with this cron running multiple times due to a glitch on spruce, I decided to add he same logic that tgrfeed uses to prevent it from executing when another instance of swbrdll is already running. That means that if swbrdll aborts somewhere in the middle of the process, a programmer will have to do the following before it correctly runs again:
DELETE FROM GJBPRUN
WHERE GJBPRUN_JOB = 'SWBRDLL'
AND GJBPRUN_ONE_UP_NO = -1;
This should prevent multiple loads in the future.
Posted by wendlerb at 8:39 AM | Comments (0)
January 2, 2008
ASOC
This new attribute on transfers was added to AAOT and ASOT. I had to modify the functions f_chk_shrtram and f_chk_sordegr to return a 3 digit code instead of a two digit code. The table trigger insert_sgrsatt_from_sgbstdn reads this code and needed to be modified as well. It inserts the attribute. The table triggers insert_sgrsatt_from_shrtram and insert_sgrsatt_from_sordegr were modified as well
Posted by wendlerb at 9:05 AM | Comments (0)