Author Archives: wendlerb

About wendlerb

I didn't drown.

DBEU Phase II

Posted on May 1, 2014 by wendlerb

Here is what is on the DBEU FAQ for Phase II: Phase Two will be executed as part of the installation of the Banner XE applications such as Catalog, Schedule,  Faculty Grade Entry etc. This phase of the Database Extension Utility will ”enable” … Continue reading →

Posted in Uncategorized | Leave a comment

IITFEED Fun

Posted on March 14, 2014 by wendlerb

The last 2 weeks I’ve had two deal with two instances where the daily ii jv feed didn’t balance.  Usually I get a call from controllers asking me to investigate.  Like almost always… both instances were due to an error … Continue reading →

Posted in IIJV FEED | Leave a comment

II JV Feed Notes (IITFEED)

Posted on March 14, 2014 by wendlerb

II JV Feed   Overview: The inter institutional jv feed is the most complex one we run.  JVs get input into owag via 2 methods: a form FWAIITD which institutions bring up in owag and spreadsheets from all the institutions … Continue reading →

Posted in IIJV FEED | Leave a comment

Posted on March 14, 2014 by wendlerb

Treasury Feeds   Overview: The treasury feeds run 4 overall shell scripts: fwptrek,fwptred, fwrckrr, and chkload.  Fwptrek downloads a check file from US Bank and eventually loads it into the table fwbckrc.  Fwrckcc is also run in this script which … Continue reading →

Posted in Treasury | Leave a comment

Posted on March 14, 2014 by wendlerb

PCARD Flow SUMMARY PCARD has an am process and a pm process which runs on the owag oracle scheduler.  These processes can be run via job submission manually on owag also.   The shell scripts are in the owag subversion … Continue reading →

Posted in PCard | Leave a comment

AP Direct Deposit Notes

Posted on March 14, 2014 by wendlerb

AP Direct Deposit Run   FARINVS – report –          Report that lists invoices headed for direct deposit and checks FWAPACH – form –          Lists count of prenotes and pending ach transactions –          Record on fatckno is created with dummy starting … Continue reading →

Posted in ACH | Leave a comment

A/P Check Run Summary Notes

Posted on March 14, 2014 by wendlerb

AP Check run   FARINVS – report –          Report that lists invoices headed for direct deposit and checks FAABATC – form –          Creates record on fatckno with beginning check number –          Record on fatckno is first checked before whole AP … Continue reading →

Posted in A/P Checks | Leave a comment

ii JV VA842810

Posted on March 5, 2014 by wendlerb

Got a call from controllers that the day’s balance from the iijv feed was out of whack.  They thought it was do to doc VA842810.  First thing I did was to look at what loaded into the table on owag, … Continue reading →

Posted in IIJV FEED | Leave a comment

SOU Bookstore Feed FZRBKST

Posted on December 20, 2013 by wendlerb

Every once in a while SOU’s bookstore feed fails and I’ve decided to share the process of how I figure out what happened with some of the folks at SOU.  First thing is to find the job submission log in … Continue reading →

Posted in Bookstore | Leave a comment

FWROUSF

Posted on November 14, 2013 by wendlerb

Got an email telling me that only one chart was being selected in the TX2 file this month instead of all the charts.  Investigating I found that chart B was the only one showing up which is the first chart … Continue reading →

Posted in Aggregate | Leave a comment