« May 2013 | Main | July 2013 »

June 27, 2013

Java 7 issue with Banner INB

There seems to be a problem with java 7 and the login form for Banner INB. The tab key does not function correctly. When you type in your username and hit the tab key, it hightlights the username instead of tabbing to the password field. This problem doesn't affect single sign on since users don't need to put in a username and password.

Posted by soukupm at 2:21 PM | Comments (0)

Real time classes mod

I made a change to the real time classes procedure registration.admin.add_duplicates. It was setting the waitlist value to null for all duplicate classes even though a course may have available seats for waitlisting. This procedure now retains the waitlist flag.

Posted by soukupm at 2:15 PM | Comments (0)

June 21, 2013

SWBRDTC modification

I made a change to the program SWBRDTC because the parameters did not work in job submission. It appears that column aliases in sqlplus (on Linux) are case sensitive. I changed all of the aliases in this program to upper case. The banner team updated the parameter descriptions to reflect this change.

Posted by soukupm at 2:05 PM | Comments (0)

Health and Wellness program problem

This week, the Health and Wellness purchase program didn't allow students and staff to purchase a pass for summer term. It only allowed fall term, which should not be an option (its too early in the year to allow fall term purchases). I traced the problem to a table SZRHWCP, which contains the preferences for the wellness program. It had 2012 dates for the purchasing dates. I updated those dates and the program is functioning again and allows summer term purchases.

Posted by soukupm at 1:57 PM | Comments (0)

June 13, 2013

SZROFAX problems

We've been having problems with the program SZROFAX for financial aid. The upload into the OSAC website has been aborting. I contacted the tech support from OSAC and they suggested the problem was some records that had a null SSN. I changed the program SZROFAX so that it did not send these records but we still had problems uploading. I tried uploading the file that was created directly on the server but it still had errors. The OSAC site says that the file needs to be text format so I thought of saving the file in MSDOS format and that seemed to fix the error.

Posted by soukupm at 2:35 PM | Comments (0)

Medicat problem

I ran into a problem this week with the medicat upload program (SZPMDCT). The job parameters were missing from gjbprun so the upload wasn't working. I added the parameters back in and copied them to our backup table gjbprun_cron.

Posted by soukupm at 2:27 PM | Comments (0)

June 7, 2013

LDAP server change for Banner INB and Wolf Web

I changed the LDAP server for Banner INB and Wolf Web this week due to problems with the server. I saved the new ldap entries to \Staff\Banner_Information\Single Sign on - LDAP

Posted by soukupm at 2:18 PM | Comments (0)

Tuition Choice problems

The Banner team found a problem this week with the tuition choice program. It has been loading incorrect data into the banner tables sgbstdn and sarchrt. I tracked the problem to a trigger on the tuition choice table tuition_plans (business.t_update_sgbstdn). The trigger was hardcoded for 2012 so it was loading the rate code BAS12 and cohort code TP12 for the new admits that made a tuition choice. I fixed the trigger so that it uses the students admit term to determine which rate code and cohort code the student should be in.
To clean things up, I had to do several non-standard updates to the banner tables sgbstdn and sarchrt for all students that used the tuition choice app. All of the BAS12 rates codes were changed to BAS13 and TP12 cohorts changed to TP13.

Posted by soukupm at 2:04 PM | Comments (0)