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  Open (Reset the Indicators and Status Flags for) the Records of a single PO

 

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
Use this information and these scripts at your own risk.
 As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences.  The scripts and information are provided "as is" without warranty, implied or otherwise.  Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:)
 

Most of the works of art on my pages other than the Extension banner
Book Dragon copyright 2006 J. Wilson Spenceare used by permission of J. Wilson Spence.
 

 

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.)                                 
View Bruce Knox's profile on LinkedIn