Laserfiche WebLink
REV: 04-07-2023 MI <br />C. Lump Sum Scope of Services <br />The Consultant shall be required to complete the following services/work. <br />Summary of services/work: <br />1. Development - Enhancements for Oracle Financials <br />2. Granular Account Tracking (Oracle) for Project Funding <br />3. Update User Interface to with (Oracle) Account String <br />4. Enhance Project Data Download with new Granular Account Track <br />5. Project – Update the Project User Interface and table to track Program <br />6. (Intentionally left blank) <br />7. Staff App - Enhancements for Main\Home page <br />8. Staff App - Enhancements for Project Page 1 of 3 <br />9. Staff App - Enhancements for Project Page 2 of 3 <br />10.Staff App - Enhancements for Project Page 3 of 3 <br />11.Staff App - Enhancements for Prioritization Page <br />12.Finance Administration App <br />13.CIP Committee Prioritization <br />Detail of services/work to be completed by Consultant include: <br />1. Development - Enhancements for Oracle Financials <br />1.1.Direct integration to Oracle Financials shall include: <br />1.1.1. Prepare projects list (master list of all City Projects where budgets can <br />be assigned) <br />1.1.2. Include last FY approved budget and carryover fields. <br />1.1.3. Microsoft Azure Function Update – Support new Process for <br />Calculating Carryover matching to Product Funding Details with Oracle <br />Strings <br />1.1.4. Update Rollup Summary Calculations in Dataverse <br />2. Granular Account Tracking (Oracle) for Project Funding <br />2.1.Track the Oracle Account String <br />2.1.1. For each fund on a project request, enable the user to define which <br />Oracle Cost Centers, Accounts, and Activities the fund could be <br />categorized as for each year within the current fiscal year set (Current <br />Year plus 4). <br />2.1.2. Total the Oracle values by row <br />2.1.3. Total the Oracle values by column <br />2.1.4. Ensure that the overall totals rollup and match the Fund total <br />2.1.5. Ensure that the existing Data Validation “Calculation Est Total Cost vs <br />Requested Total” is greater than Requested Total Cost. <br />2.1.6. Enable a Remove button for the Oracle value rows. <br />2.1.7. Create new table to store Oracle Cost Center, Account and Activity <br />2.1.8. Create relationship between table and Project Funding Request <br />Details. <br />ATTY/AGR.2023.075/CodeRight Inc. (CIP App) (Page 13 of 20)