ATTACHMENT_A_(As-Is_-_Future_Design)_REVISED.pdf

PDF 108 KB Posted

Attached to
Oracle E-Business Suite (EBS) Current-State (As-Is) Assessment and Oracle Fusion Cloud Future-State (To-Be) Design
Solicitation number
123581
Issued by
Prince George's County, Maryland

About this file

Attachment A: Current Environment Profile

This document is a current-state environment profile attachment for the Washington Suburban Sanitary Commission (WSSC Water) in Maryland's Oracle E-Business Suite (EBS) Current-State (As-Is) Assessment and Oracle Fusion Cloud Future-State (To-Be) Design solicitation. WSSC Water is soliciting sealed responses for comprehensive assessment and design services, with responses due by 2:00 p.m. on Friday, December 11, 2026, through WSSC's OpenGov eProcurement Portal. The project scope includes documenting current operations, defining organizational requirements, mapping needs against Oracle Fusion Cloud standard capabilities, and designing optimized future-state processes. Deliverables will establish the current-state baseline, requirements documentation, and future-state design for use in subsequent design, configuration, and implementation phases. The awardee and its teaming partners may not participate as a prime or subcontractor in any future System Integrator solicitation but may participate in future Program Management and Organizational Change Management solicitations.

WSSC Water's current environment operates on Oracle E-Business Suite Release 12.2.9 with Oracle Database 19c, hosted on-premises and managed internally, serving approximately 1,900 employees. The system encompasses General Ledger, Accounts Payable, Purchasing (including iProcurement), iSupplier Portal, Sourcing, Procurement Contracts, Inventory, HRMS, Self-Service HR, Payroll, Benefits, Time and Labor, and a custom Compliance module. The environment includes more than 200 RICE customizations, approximately 30 inbound and outbound interfaces connecting to external systems, and approximately 300 seeded and custom reports utilizing Oracle BI Publisher, Oracle Business Intelligence (OBIEE), Financial Statement Generator, Web ADI, Noetix Views, and custom SQL reporting tools. Additionally, approximately 10 named applications outside EBS—including Questica, SAP SuccessFactors, PeopleAdmin, Pathlore, Percipio, DocuSign, Primavera P6, e-Builder, Oracle Work and Asset Management, Oracle Utilities Customer to Meter, and Trimble Unity Maintain—support budgeting, performance management, recruiting, learning, e-signature, capital project management, and asset management functions. Work must comply with GASB standards, WSSC Code of Regulations, MBE/SLBE program requirements, the Maryland Public Information Act, Maryland personal information protection law, federal and state payroll tax requirements, collective bargaining agreements, and federal and State of Maryland grant requirements.

View the file

Other files

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

ATTACHMENT A – CURRENT ENVIRONMENT PROFILE

Part 1 –Oracle EBS Profile

Item WSSC Water Response Oracle EBS release and patch level; database version; hosting Oracle E-Business Suite Release 12.2.9; Oracle

Database 19c; hosted on premises and managed by WSSC Water.

Modules in current EBS production General Ledger, Accounts Payable, Purchasing (including iProcurement), iSupplier Portal, Sourcing, Procurement Contracts (limited use), Inventory, Compliance module (custom), HRMS, Self-Service HR, Payroll, Benefits, and Time and Labor.

Number of employees (represented / non-represented) Approximately 1,900 employees. Approximately 5 to 25 users in each area.

Payroll frequency, pay groups, and annual payroll runs Bi-weekly. Pay groups and annual payroll runs Fiscal year (start/end) and key blackout periods July 1 to June 30. Blackout periods include fiscal year-end close and calendar year-end payroll processing.

Number of custom application objects (RICE) 200+ customizations across the in-scope modules.

Number of inbound/outbound interfaces and key connected systems Approximately 30 applications exchange data with

EBS through inbound or outbound interfaces.

Number of custom and frequently used reports; reporting/BI tools Approximately 300 seeded and custom reports.

Tools: Oracle BI Publisher, Oracle Business Intelligence (OBIEE), Financial Statement Generator, Web ADI, custom SQL reports, Noetix Views, and GL Wand.

Known Finance, Procurement, and HR systems, tools, and spreadsheets used outside EBS

Approximately 10 named applications plus spreadsheets, shared drives, email approvals, and paper forms, covering budgeting, performance management, recruiting and onboarding, learning, e-signature, capital project management, and financial reporting. See Part 2 of this Attachment.

Mobile applications currently used for Finance, Procurement, or HR processes Yes – Oracle Approvals limited and self service browser based tools.

Systems currently used for capital projects, work orders Capital projects: Primavera P6 and e-Builder; in EBS, projects are tracked through Chart of Accounts Job and Activity segments (approximately 2,000 operating and 3,300 capital projects). Work orders: Oracle Work and Asset Management (WAM). Trimble Unity Maintain

(TUM)

Existing documentation available (process maps, SOPs, configuration documents, integration diagrams)

Each area has SOPs, Policies, existing or developing IOPs, and some process maps. Gaps in supported documentation will require materials to be developed.

Compliance environment (e.g., GASB, WSSC Code of Regulations, state and federal requirements, data privacy)

GASB; WSSC Code of Regulations; MBE/SLBE program requirements; Maryland Public Information Act; Maryland personal information protection law; federal and state payroll tax;

collective bargaining agreements; federal and State of Maryland grant requirements.

Part 2 – Known Systems Outside EBS and Connected Systems

The systems below are known to WSSC Water as of the solicitation date. Outside EBS systems are in scope. This list is a baseline for planning, is not exhaustive, and does not reduce the Vendor's obligations under Tasks 3 and 4 of the SOW.

System Type Department Relationship to EBS Questica Budgeting Finance Outside EBS. Operating and capital budgets;

loaded to GL by spreadsheet; actuals uploaded to Questica.

GL Wand; Noetix Views Reporting Finance; IT Outside EBS. Excel-based and view-based reporting over EBS data.

SAP SuccessFactors Performance management

Human Resources Outside EBS. Receives employee demographics and employment information from EBS.

PeopleAdmin Applicant tracking and onboarding

Human Resources Outside EBS. No integration; data re-entered in EBS. Integrated with HireRight for background checks.

Pathlore; Percipio Learning Human Resources Outside EBS. User credentials for authentication.

No other integration. Pathlore is approaching end of support.

DocuSign E-signature Human Resources;

Finance

Outside EBS. Job offers and approval of some PO invoices; not integrated.

Primavera P6; e-Builder Capital project management

Engineering and Construction

Outside EBS. No EBS projects integration identified.

Property management software

Lease management Finance Outside EBS. Approximately 100 land leases;

product selection in progress.

Spreadsheets, shared drives, email, paper

Manual tools All Outside EBS. Financial reporting, recruiting lists, bulk salary changes, invoice approvals, and other manual steps.

Oracle Work and Asset Management (WAM)

Enterprise asset management

Operations; General Services

Connected system. Scheduled interfaces for items, vendors, departments, employees, stock requests, on-hand balances, returns, and invoices. Upgrade in progress.

Oracle Utilities Customer to Meter (C2M)

Customer information system

Finance Connected system. Customer refunds to Payables; journals to General Ledger.

Trimble Unity Maintain (TUM) Maintenance management

Operations Connected system.

Oracle Integration Cloud (OIC) Integration middleware

Information Technology Connected system.

Financial Institutions Banking Finance Connected. checks, EFT, positive pay, statements to Cash Management, virtual card payments, wire accounts.

Empower 457(b) recordkeeper

Human Resources;

Payroll

Connected. Manual: contribution files keyed into EBS; payroll file uploaded through web portal.

Cigna, Kaiser Permanente;

Delta Dental;

Benefits Human Resources Connected. Carrier interfaces

Retiree Payroll and Employee Pension System

Pension Finance Connected. Interface from EBS HR/Payroll.

Employee employment and payroll data

Oracle Identity Management

(OIM)

Authentication IT Connected. Inbound and Outbound

HireRight; Concentra Pre-employment services

Human Resources Background checks through PeopleAdmin; pre-employment medicals managed manually.

GIS; data warehouse various Information Technology Connected

ATTACHMENT A – CURRENT ENVIRONMENT PROFILE

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