Brian's Blog: May 2006 Archives

« April 2006 | Main | June 2006 »

May 31, 2006

PHPMTIM

PHPMTIM is one of the first Banner baseline processes I had to put WOU mods on. It is the mass time job submission process which loads data out of phrmtim into PHAHOUR. This is how we handle stuent employees. We've been running an older Banner version of this program for several years and I've tried several times to put WOU mods on later versions. I think I've finally succeeded on the 7.1 version. The code has all WOU changes documented now. Most of the mods relate to rpt_hours and rpt_percent. The baseline program did not calculate phrhour_hrs correctly and did not use the perecent from phrmtim. It essentially divided percent by 2 for multiple labor distribution and put each at 50%. There was also rounding issues on phrelbd_hrs on these multiple labor distributions so that the total hrs were off by .01 or .02 from phrearn_hrs causing the form to bomb.

Posted by wendlerb at 2:17 PM | Comments (0)

May 24, 2006

Web Doc fun

Updating available Banner reports on the web link

Posted by wendlerb at 10:10 AM | Comments (0)

May 19, 2006

Shrediy fun - cron job

I created a com file on shrediy to set up the cron job and ran into all kinds of fun with the input paramets. Normally this is usually pretty seemless but in this case there are some input loops when running from command line that don't cause a problem when running from proC execuatable. I had to add a blank line to the input file after transcript type and address type in the input file that gets created during the com file execution. Otherwise the program goes into an endless loop. The address type also appears to get validated when running from command line as opposed to running in proC executable mode.

Had some fun also trying to figure out how to get to the proper directories on radar from spruce using sftp. cd edi2:/shrediy seems to work

Posted by wendlerb at 2:54 PM | Comments (0)

May 17, 2006

JDeveloper

I've been running through the tutorials on JDeveloper. tutorials

I had to set up quite a few things in order to do this. I downloaded the Oracle 10G database version for windows and set it up on my local machine. Next, I had to set up the newer forms developmen stuff to get my registry set up correctly. The tnsnames entry is a little tricky and I didn't want to use network one. You manage the database through a web page which is interesting. Finally there is an application server piece which is also running locally on my machine. All this takes a lot of resources.

JDeveloper is supposed to allow seemless deployment of java and XML packages to the application server as well as let you work on lower level stuff like stored procedures, etc. It is supposed to speed up development time in the long run. It uses a lot of standard templates for coding but appears to have a steep learning curve for getting used to the GUI interface for doing things. I found PL/SQL Developer much easier to pick up.

Posted by wendlerb at 9:51 AM | Comments (0)

May 10, 2006

Web advisor hold release

The package dehold is behind this page on banweb. There a re some local tables set up to allow anyone in a department to delete a hold on an individual in that department. The tables are zfacdepnd ztvdept. Advising called and wanted some new advisors to work in the same way so I put them into the table

Posted by wendlerb at 3:09 PM | Comments (0)

May 3, 2006

Upgrade - Prelim SIS

SIS

Packages: 7.2 version?
ACADHIST
BWGKOADR Y
BWGKOGAD Y
BWLKOIDS Y
BWSKFCLS Y
BWTKTXNS
SAKMTCH Y
BWCKGENS
SFKFEES Y
BWCKREGS
BWLKADVR
BWLKFCWL
BWLKFFGD
BWLKFTRN
BWLKILIB
BWSKAPER
BWSKOACC
DEHOLD
DML_SPRIDEN
GB_IDENTIFICATION
GOKMAIL
SAKDCSN
SAKVAPL
SFKEDIT
SHKROLS
SOKLIBS
TTKFUNC

Views:
SFVSTMS
GLVEXTR
SMVRQCM
SPRIDEN
many more

Forms:
SPAIDEN
TSASPAY
TSAAREV
WOUCHEK
GOQRPLS
SAADCRV
SAAQUIK
SFAREGS
SFAREGQ
SRAQUIK
GUASYST
SZZDCRV
SOILCUR

Posted by wendlerb at 11:05 AM | Comments (0)

Upgrade - Prelim FIS/HR

FIS

Packages:
BWGKOADR
BWGKOGAD
GB_BIO
GB_IDENTIFICATION
DML_SPRIDEN

Table triggers:
Spriden
Swbpidm

Forms:
PPAIDEN
FTMVEND

Posted by wendlerb at 10:39 AM | Comments (0)

May 1, 2006

Woutst/Wodv refresh

ETS refreshed these two databases from production Friday morning April 28. This was done to help with departments coming on to Capp. I knew I'd have to reset the web transcript stuff. Unfortunately the Banner team forgot about the EDI stuff set up in woutst and wiped it out during the refresh. I got a setup sheet from our consultant and reentered the stuff by the end of the day so I think we're back to where we were.