<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1831166137;
mso-list-type:hybrid;
mso-list-template-ids:882300144 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1860005500;
mso-list-type:hybrid;
mso-list-template-ids:-2099071034 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Banner Report Users,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">A clarification.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Some Banner pages listed as <b>‘Launch Forms’</b> in <b>column C</b> attached, such as FWIBUDG, FWIGITD, FGITBAL, FZITRND, PWIFOAP, FGIBDST, FWIVNDH, PWIEMPL and PWIVERI, allow us to query real time data on screen.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">No change planned for these and other Banner query pages/forms.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It is the PDF or spreadsheet report outputs, typically launched from a Banner page using the
<b>Tools menu</b> with Either the <b>‘Run’ or ‘Create Report or Spreadsheet’</b> command<b>
</b>that are deprecated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The PDF files and spreadsheets with <b>‘Report Titles’</b> listed in
<b>column B</b> attached must be re-written if still needed.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Notes:</b> <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l1 level1 lfo1">The <b>
‘Export Data’</b> Action on the <b>Tools menu</b> of many Banner pages is baseline functionality and will remain available allowing users to place queried data into a spreadsheet file.<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<ol style="margin-top:0in" start="2" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l1 level1 lfo1">Cognos reports currently run against Banner data warehouse that is updated nightly so result sets generally reflect yesterday’s data. Information Services will make real time data
available from Cognos reports where needed.<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hope that helps.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sorry for any confusion.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cheers<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Mark McCulloch </b>Director Info Systems Business Affairs<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#222222;background:white">he/him/his<o:p></o:p></span></p>
<p class="MsoNormal"><a href="mailto:mmccullo@uoregon.edu"><span style="font-size:10.0pt">mmccullo@uoregon.edu</span></a><span style="font-size:10.0pt;color:#154733"> 541-346-6249<o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://map.uoregon.edu/f996b9646"><span style="font-size:10.0pt">Thompson University Center</span></a><span style="font-size:10.0pt;color:#154733"> Suite 302B<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#154733">720 East 13th Avenue Eugene, OR 97403</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img border="0" width="109" height="23" style="width:1.1354in;height:.2395in" id="Picture_x0020_3" src="cid:image001.png@01D708F9.8292B2D0" alt="UOSignature-3435-CGY11-4C"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> <a href="mailto:bao-news-bounces@lists.uoregon.edu">
bao-news-bounces@lists.uoregon.edu</a> <<a href="mailto:bao-news-bounces@lists.uoregon.edu">bao-news-bounces@lists.uoregon.edu</a>>
<b>On Behalf Of </b>Business Affairs Office News<br>
<b>Sent:</b> Friday, February 19, 2021 9:23 AM<br>
<b>To:</b> <a href="mailto:bao-news@lists.uoregon.edu">bao-news@lists.uoregon.edu</a><br>
<b>Subject:</b> Banner/Oracle Reports Three Questions<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello again Banner report users:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">As promised, attached you will find a list of all Banner reports. Finance reports on the first tab, AR the second and Payroll the third.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Some reports are marked obsolete because they haven’t been run in the past year.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Most reports are still needed and will be re-written over the course of the coming year using IBM Cognos.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Some Banner Finance reports such as Indexes, Account Hierarchy, Budget Status and Transaction Detail already have Cognos equivalents and will be marked obsolete.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We expect most reports will run fine from Cognos instead of Banner using the same parameter choices and formatted to look similar.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Of course, those among us who are not already Cognos users will want to register for training in the coming months to ease the transition.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Information Services is testing the ability to launch a Cognos report from Banner for situations where the Banner context is critical.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Information Services is also preparing a new live view of Banner data for Cognos reports that require up to the minute data.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Three questions for you:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo2">Is there any report that must be run from Banner instead of from Cognos ? Why is the Banner context critical ?<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo2">Is there any report you run from Banner where real time data is critical ? Or would the same Cognos report be adequate if it reflected yesterday’s Banner data ?<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo2">Would you like to participate in a Banner report virtual meeting to discuss this transition, ask questions and share suggestions with your colleagues ?<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please respond to me directly to identify reports that must be run from Banner, or must have real time data, and/or to receive an invitation to discuss this transition.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Mark McCulloch </b>Director Info Systems Business Affairs<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#222222;background:white">he/him/his<o:p></o:p></span></p>
<p class="MsoNormal"><a href="mailto:mmccullo@uoregon.edu"><span style="font-size:10.0pt">mmccullo@uoregon.edu</span></a><span style="font-size:10.0pt;color:#154733"> 541-346-6249<o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://map.uoregon.edu/f996b9646"><span style="font-size:10.0pt">Thompson University Center</span></a><span style="font-size:10.0pt;color:#154733"> Suite 302B<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#154733">720 East 13th Avenue Eugene, OR 97403</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img border="0" width="109" height="23" style="width:1.1354in;height:.2395in" id="Picture_x0020_2" src="cid:image001.png@01D708F9.8292B2D0" alt="UOSignature-3435-CGY11-4C"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> <a href="mailto:bao-news-bounces@lists.uoregon.edu">
bao-news-bounces@lists.uoregon.edu</a> <<a href="mailto:bao-news-bounces@lists.uoregon.edu">bao-news-bounces@lists.uoregon.edu</a>>
<b>On Behalf Of </b>Business Affairs Office News<br>
<b>Sent:</b> Tuesday, February 16, 2021 16:46<br>
<b>To:</b> <a href="mailto:bao-news@lists.uoregon.edu">bao-news@lists.uoregon.edu</a><br>
<b>Subject:</b> Banner/Oracle Reports Retirement<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Banner report users:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The Oracle Reports technology, used by developers at Information Services to publish reports that users can run from Banner pages, is being retired in about a year.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Reports in use and still needed will be re-written (with considerable effort) using a newer technology.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Oracle reports are run from FWIORPT and PWIORPT and many other Banner pages that have the “Create Report or Spreadsheet Option” under the Tools menu.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The “Create Report or Spreadsheet Option” may no longer be needed now that the Export Action has been added to the Tools menu on many Banner pages.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We will soon share a list of reports we feel are obsolete based either on lack of use or on the fact that alternatives exist such as the Banner Export Action or a substantially similar Cognos report.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We would appreciate your help understanding if and why any report marked “Obsolete” is still needed and should therefore be re-written.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We will also host a meeting of Oracle Report power users to discuss this transition, hear concerns, and answer any questions.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Mark McCulloch </b>Director Info Systems Business Affairs<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#222222;background:white">he/him/his<o:p></o:p></span></p>
<p class="MsoNormal"><a href="mailto:mmccullo@uoregon.edu"><span style="font-size:10.0pt">mmccullo@uoregon.edu</span></a><span style="font-size:10.0pt;color:#154733"> 541-346-6249<o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://map.uoregon.edu/f996b9646"><span style="font-size:10.0pt">Thompson University Center</span></a><span style="font-size:10.0pt;color:#154733"> Suite 302B<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#154733">720 East 13th Avenue Eugene, OR 97403</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img border="0" width="109" height="23" style="width:1.1354in;height:.2395in" id="Picture_x0020_1" src="cid:image001.png@01D708F9.8292B2D0" alt="UOSignature-3435-CGY11-4C"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>