FM_UB_ATT_11_Interface_List.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
Professional Implementation Services for Oracle Utilities Billing
Solicitation number
RFP 26-106
Issued by
Lee County, Fort Lauderdale City, Florida

About this file

This is an Interface List attachment for the City of Fort Myers, Florida's implementation of a new Oracle Utilities Billing System. The document outlines the technical integration requirements between the proposed ERP system and existing third-party systems that support the City's water, wastewater, and solid waste utility operations. The interface list identifies five systems requiring integration: Paymentus (online payment application), ITRON AMI software (automated meter infrastructure), WaterSmart (customer portal), InfoSend (billing service), and two systems under evaluation—a Point of Sale application and a backflow testing results system. For each interface, the vendor proposer must specify whether the existing system will be retained with a permanent interface built into the project, replaced with the new ERP functionality, or replaced with a new third-party system.

The document establishes standardized response categories for vendors to document integration specifications across four key dimensions: direction of data flow (inbound only, outbound only, or bi-directional), duration (temporary during implementation or permanent for the system's lifetime), frequency (real-time, hourly, daily, weekly, or monthly), and any applicable comments. The City notes its openness to alternatives, including retaining WaterSmart or adopting Oracle's native customer portal, and indicates that the current Tyler Cashiering system should be replaced with an integrated Point of Sale solution. All new third-party systems proposed as part of the vendor's solution must be added to this interface list to ensure comprehensive integration planning and technical feasibility assessment during the implementation process.

View the file

Other files

Show all 15

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

Utility Billing - City of Fort Myers, FL
Attachment 9 (Interface List)
Column E: Available Responses
Replace w/ERPSystem is replaced with functionality native to the new the ERP
Replace w/New TPSSystem is replaced with a new Third Party System (TPS) that has been proposed as part of the new solution
KeepKeep the current system and build a permanent interface as part of the project
Column F: Available Responses
Inbound OnlyData will be pulled from the TPS into the ERP System
Outbound OnlyData will be pushed from the ERP System into the TPS
Bi-DirectionalData will be pushed from the ERP System into the TPS and pulled from the TPS into the ERP System
Column G: Available Responses
TemporaryInterface will be needed for limited amount of time during the project be will not be necessary after the project is completed
PermanentInterface will be needed for the life-time of the ERP System
Column H: Available Responses
Real-TimeData is transferred, at a minimum, every 15mins.
HourlyData is transferred, at a minimum, every 60mins.
DailyData is transferred, at a minimum, every 24 hours
WeeklyData is transferred, at a minimum, every 7 days
MonthlyData is transferred, at a minimum, every 30/31 days
Column J: Available Responses
Yes
No
NOTE: All new Third Party Systems (TPS) that are part of the proposal should be added to this list.
THIS SECTION IS TO BE COMPLETED BY THE VENDOR/PROPOSER
System NameDescription / Use CaseCity's PlanVendor RecommendationDirectionFrequencyComments
PaymentusOnline payment applicationKeep
ITRONAMI software/NAAKeep
WaterSmart *Customer portalKeep
InfoSendBilling serviceKeep
TBD **Point of Sale applicationReplace w/New TPS
TBD ***Backflow testing resultsReplace w/New TPS
* The City is open to keeping WaterSmart or to utiliizing an Oracle customer portal
** The City currently uses Tyler Cashiering but would like to replace it with a POS system that integrates with Oracle
*** The City is working to onboard a new vendor for backflow testing. The results of this testing wll need to be added to the Utility Inventory

File details come from the government source that posted it. Updated .