Banner PO Scripts
by Bruce Knox bknox
@t uaex.edu
Oracle Database Programmer/Analyst
date last updated 02/13/2014
This page is intended for users of SCT's Banner Purchasing Software Only!
These
are programs that we use to help manage the Purchasing System.
The program scripts have UNIX commands that are
run by using the HOST statement. We
use the HOST abbreviation of ! for our IBM
pSeries under AIX (IBM’s UNIX). Other servers may use the $ for this abbreviation.
If you are not on a UNIX server, then the
underlying statements must be converted as well. These are mostly just information sent to the user while
running the script. However, each
program also removes files.
open_po.sql Open PO (Aging) Report by Established Date
Creates file: open_po.lst
The open_po.sql program is an aging list, but it
is not the traditional cross-tab accounting report.
po_close.sql Close the
Records for Open but Zero Encumbrance POs, by Fiscal Year
Creates two files:
po_close_start.sql
po_close.lst
This program updates a number of tables.
Be aware that updating Banner tables from user scripts can be a Support
Issue with SCT. I suggest you
discuss this with your DBA or IT Manager before using the script.
While these updates work for our site, they may
not correctly update your tables. The
Banner Tables have very complex relationships.
Since the relationships can vary (depending upon the site and the data in
the tables), your tables may not be correctly updated by our scripts.
But, I think this script will serve as a good
starting point for you.
Updates FGBENCD: Encumbrance Distribution Table
Updates FPBPOHD: Purchase Order Header Table
Updates FPRPODT: Purchase Order Detail GOODS
Table
Updates FPRPODA: Purchase Order Accounting Detail
Table
Prints a Log of POs Closed
Updates FGBENCH: Encumbrance Ledger Header Table
po_open.sql
SET fgbench_status_ind = 'O'
SET fgbencd_status = 'O'
SET fpbpohd_closed_ind = 'N'
SET fpbpohd_closed_date = NULL
SET fprpodt_closed_ind = NULL
SET fprpoda_closed_ind = NULL
po_flags.sql List the Current Indicators and Status Flags for PO related
Tables
requisition_close.sql Close the Records for Open but Zero Balance Encumbrance Requisitions, by Fiscal Year.
This is very similar to the po_close.sql above and the same warning apply. Use with great care.
Creates two files:
requisition_close_start.sql
requisition_close.lst
The program updates a number of tables.
Be aware that updating Banner tables from user scripts can be a Support
Issue with SCT. I suggest you
discuss this with your DBA or IT Manager before using the script.
While these updates work for our site, they may
not correctly update your tables. The
Banner Tables have very complex relationships.
Since the relationships can vary (depending upon the site and the data in
the tables), your tables may not be correctly updated by our scripts.
But, I think this script will serve as a good
starting point for you.
Updates FGBENCD: Encumbrance Distribution Table
Updates FGBENCH: Encumbrance Ledger Header Table
Updates FPRREQD: Request Detail Table
Updates FPRREQA: Request Accounting Table
Prints a Log of Requisitions Closed
Updates FGBENCH: Encumbrance Ledger Header Table
http://betwinx.com/banner_po_scripts.htm
is about miscellaneous Purchase Order scripts for Banner.
This is a special topic personal page maintained by Bruce Knox ( bknox @t uaex.edu ) documenting some University of Arkansas, Division of Agriculture, Cooperative Extension Service IT projects.
Disclaimer
Most of the works of art on my pages other than the
Extension banner |
http://betwinx.com is
my personal site. betwinx?
This site is largely oriented to Oracle Reporting Solutions in the
context of generating bespoken reports from Ellucian's Banner
product.
(I maintain a number of special topic pages with links from this primary site.) |