Thursday 2 January 2025
Alpha Financials is UC Merced’s program dedicated to updating our financial systems as part of our commitment to modernizing systems and processes. This includes implementing Oracle Financials Cloud and Oracle Enterprise Planning and Budget as well as redesigning our Full Accounting Unit to a Common Chart of Accounts.
The goal of Alpha Financials is to ensure UC Merced has the infrastructure in place to deliver high-value, reliable, and easy-to-access financial services that allow the campus to focus on our mission of teaching, research and public service.
To do this, Alpha Financials will cut ties to the legacy financial system hosted at UCLA and replace it with Oracle Cloud applications, as well as transform how we track spending, perform financial reporting, and improve auditability across the university to align with the UC system’s restructured Common Chart of Accounts (CCoA). The new CCoA will improve financial management at UC Merced and across the UC system.
The project team has completed the planning and initial discovery phase and is conducting design and build sessions for the system, which is scheduled to be production-ready in December 2020 and go live in January 2021.
The simple answer is that our existing system does not meet the needs of our growing campus and key components will soon be phased out.
UC Merced’s financial systems date back to the early 1980s, when the operating environment was substantially less complex than it is today. It is comprised of a sub-unit in UCLA’s financial system and a suite of home-grown applications.
Because the existing system is not meeting the campus’ needs, there are numerous shadow systems being used to manage data. These unconnected systems lack standardized processes and controls, which contribute to risks to compliance and information security, as well as data integrity issues.
Additionally, UCLA is planning to sunset the existing system we depend on and switch to a Oracle Software as a Service (SaaS) based system; as a result, UC Merced will need to have a replacement financial system in place. Since 2017, UC Merced, in partnership with UCOP, has been evaluating various options to replace the university’s existing financial system. After due diligence, a decision was made in September 2018 to replace our financial system with an Oracle SaaS-based integrated financial system.
The implementation of Oracle Financials is a milestone for UC Merced’s financial management capability that aligns with UC’s Cloud First Strategy. It will modernize our financial systems and processes and lays the foundation for dramatically improving access to financial data. A modern financial system will deliver functionality that is currently distributed on shadow systems, meaning campus will have one reliable, accessible source of truth for financial transactions, business process execution, and reporting. This will reduce the administrative burden associated with conducting basic financial management activities. Finally, we will have the ability to transform how work is done in the future by converting manual processes to automated procedures that save time, increase accuracy, and enhance our reporting ability.
We assembled a team to lead the Alpha Financials project that represents finance needs across UC Merced. The project Advisory Board includes representation from faculty, academic departments, administration, budget, finance, the Center of Institutional Effectiveness, and the Office of Information Technology. Within the project, a team of finance and budget subject experts is designing and configuring the system with our support contractor, Deloitte, bringing in campus stakeholders as their expertise is needed.
UC Merced has partnered with Deloitte to assist with the implementation of the Oracle Applications Cloud. The company is providing functional and technical expertise for the implementation and integration of the new system, as well as supporting business process mapping and optimization, project management, change management, and training. UC Merced is responsible for the overall leadership of the project and for staffing each workstream with experts to advise the configuration of the cloud and to design the new business processes.
Alpha Financials project has adopted a Hybrid/Agile approach to planning, executing, and monitoring and controlling the project work with sprints of incremental delivery or iterative prototyping of design broken into three phases:
The project team anticipates it will be production-ready in December 2020 for a go-live date in January in 2021 (following the campus holiday break, or curtailment).
There are pros and cons to performing a mid-fiscal year financial system cutover. Going live at fiscal close provides a clean break from the old to new system; a mid-year go-live requires additional planning related to conversion of balances, reconciliations, and financial reporting. Universities have successfully gone live with large financial enterprise resource planning systems at the fiscal close and at mid-year; both options are feasible. We believe the period during curtailment when systems are quiet provides additional opportunity to test and validate before business resumes in 2021. In regard to conversion, the Alpha Financials team plans to convert historical summarized General Ledger balance activity from July 1, 2018 through December 31, 2020. Historical detailed journal transactions will remain available for reference in the legacy UCLA-hosted General Ledger system.
No. We are targeting one rollout to the entire campus. No groups will get the system before others.
The goal of Alpha Financials is to ensure UC Merced has the infrastructure in place to deliver high-value, reliable, and easy-to-access financial services that allow the campus to focus on our mission of teaching, research and public service. Alpha Financials benefits campus in several ways:
Campus will have one reliable, accessible source of truth for financial transactions, business process execution, and reporting; this reduces risk associated with data integrity, compliance, and information security.
By reducing manual work and automating key processes DFA will be better equipped to serve our campus customers resulting in reduced turn-around time, increased accuracy, and enhanced reporting ability.
Campus will see less duplication of effort and administrative tasks thanks to improved data integrity and improved quality of system output and reporting.
We will select sample stakeholders from across campus from the Chief Administrators Officer (CAO) group to help us with User Acceptance Testing before the project goes live. If you are a CAO and would like to volunteer, please email us: alphafinancials@ucmerced.edu.
For optimal system performance, you should use the latest version of Mozilla Firefox.
Oracle Applications Cloud is a cloud-based Enterprise Resource Planning (ERP) system. It is a modern, agile suite of integrated applications that undergo periodic updates automatically to improve functionality.
UC Merced will go live with a number of Oracle Financials Cloud modules, which will broadly impact areas, including:
|
|
The UCLA Ascend team is working on the data archiving strategy for UC Merced for all financial records housed in UCLA system to ensure records retention requirements are achieved.
We are working to cease performing transactions in the UCLA financial systems. The Alpha Financials project team, Concur project team, UCLA's Ascend team and UCOP are working to ensure we are prepared for the transition to the UC Merced Oracle Cloud as well as exit from UCLA financial applications.
CURRENT SYSTEM |
NEW SYSTEM |
COMMENTS |
BruinBuy/PAC |
BobCat Buy, powered by Oracle Cloud |
|
Corporate Financial System |
Oracle Cloud |
Oracle Cloud’s General Ledger Module will perform functions of these current systems: General Ledger, Financial Journal, TOF, Recharge, Encumbrance Voucher, and Memo-Lien Voucher. |
Recharges |
Oracle Cloud |
|
Travel Express |
Concur |
Please see the Travel website for more information on Concur. |
Pre-trip Authorization System |
Concur |
Please see the Travel website for more information on Concur. |
Direct Bill Payment System |
Concur |
Please see the Travel website for more information on Concur. |
Asset Management System (Equipment Management) |
Oracle Cloud |
|
QDB – Financials/Document Direct/CDW |
Oracle data warehouse and application reporting tools |
Note on data and records retention: The UCLA Ascend team is working on the data archiving strategy for UC Merced for all financial records housed in UCLA system to ensure required records are retained. |
SLS |
Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) |
The Oracle EPBCS Module will house recurring and one-time budgets (referred to as Permanent Budget and Error Correction Systems in the current system). |
W-9 Upload System |
BobCat Buy, powered by Oracle Cloud - Supplier Portal |
|
Procurement Card Receipt Management |
Concur |
Please see the Travel website for more information on Concur. |
UCLA Vendor Self-Service |
BobCat Buy, powered by Oracle Cloud - Supplier Portal |
|
PAN |
Oracle Cloud |
|
TRS |
TRS |
The application will move to being hosted at UC Irvine; because of this, the URL link to TRS will change. |
Glacier |
Glacier |
The vendor system (currently supported by UCOP) will move to being hosted by UC Merced; because of this, the URL link will change. |
Effort Reporting System |
Effort Reporting System |
The application will move to being hosted at UCOP; because of this, the URL link will change. |
The impacted systems are:
As part of the cutover to Oracle, the project teams must complete a massive data conversion. This will require pausing campus activity such as purchasing, travel, recharge and non-PEARS (non-payroll) entry in several existing UCLA-based systems. During this cutover period, Dec. 8 through Jan. 4, there will be limited to no functionality for most processes and transactions. Limited exceptions will be made for critical business activities, such as contracts and grants, gifts and endowments, or emergency purchases. There also will be some downtime during the cutover process for systems that interface with the UCLA financial system, including GLAAS and Banner, to allow the new interfaces to be put in place for the Oracle go-live on Jan. 4, 2021.
There are several meaningful changes to how financial transactions will be entered:
The physical location segment was structured with two different parent levels.
One parent level has child values for locations on campus and the other has child values for locations off campus. The CAAN identifiers were not used as values for locations because for many locations, there is not a 1 to 1 CAAN to location relationship.
As an example, the Bookstore, Lantern Café, and the Library are all common locations that have a physical location segment value, but only the Library building has a CAAN number.
The Common Chart of Accounts, or CCoA, is the basic structure used to record the financial effects of transactions in Oracle Cloud. The future-state Chart of Accounts will:
A new Common Chart of Accounts (CCoA) is needed for the following reasons:
The Common Chart of Accounts (CCoA) is being thoughtfully designed through a collaborative and system-wide approach. The effort began in April 2019 under a committee of finance, accounting, and extramural funding experts (the CCoA Committee). The committee is validating and fleshing out the CCoA design by strategically engaging academic, administrative, and auxiliaries leadership. The CCoA will continue to be refined in response to these engagements. After working with leadership, the CCoA Committee will engage a wider audience to explain the update to the CCoA in detail as well as demonstrate the enhanced reporting and tracking capabilities campus will have thanks to increased transparency into and better organization of financial data.
The new Common Chart of Accounts differs from the current Full Accounting Unit in the following ways:
Alpha Financials will be a change for many campus stakeholders – new systems are both exciting in their possibilities but understandably can cause some uncertainty while the project team works to configure the system.
As we make progress across functional areas, we are reaching out to subject matter experts and stakeholders across campus to understand how they use the finance system today, and what they need in the future. Our goal is a system that works for campus now and is flexible enough to grow with us in the future.
We are excited to share more about the system once it’s configured! You can expect to hear more details beginning in spring 2020. If you have questions or concerns before then, please contact: alphafinancials@ucmerced.edu.
Our team has been diligently gathering change impacts – the difference between what each of the Alpha Financials stakeholder groups do or see today, and what the future will be. We are working to validate those change impacts with Central Office Strategic Partners to refine and inform end user training. End users are everyone from the most technical finance accountants who will be living in the system every day, to campus department RAs who will occasionally need to find relevant finance data.
We are analyzing a crosswalk between all of our stakeholders (over 20 unique groups) and the functionality and reporting capability in the system to determine training personas. These personas will help us build a detailed training plan that will include appropriate amounts of instructor-led training, job aids, online tutorials, short videos, or quick references to prepare end users to operate in the system. Training will occur in fall 2020, with some stakeholder groups receiving training once the system is live.
You will still be able to access all WBTs, even if you were not assigned by the Learning Management System (LMS). WBTs will be available post Go-Live.
General Accounting is working with the campus to identify accounts that should be closed prior to conversion, which is generally part of the campus fiscal close process. You can anticipate reviews of your accounts and requests to review account statuses by the General Accounting team. With the Alpha Financials project timeline aligned to the beginning of the 2021 calendar year, we don’t foresee major impacts to the 2020 fiscal close process.
We do expect instituting a “pause” on financial transactions prior to go-live to allow for cutover of data and systems. Because of that and some dependencies between departments, fiscal close will look a little different this year. It will be a collaborative effort between departments, with each unit nominating a representative to work as a group to determine the order of operations for close, taking into account dependencies across units.
Your training deadline will be extended based on your expected return to work date.
Cutover will occur at the end of 2020, but the specific dates and details have not been finalized. System design and retrofitting analyses are in progress and will contribute to the detailed cutover plan that the project team will develop. We will share more information on the cutover strategy once it becomes available in early 2020.
Reporting is one of biggest benefits of Alpha Financials that faculty will experience. Reporting will be vastly improved over what we have today. Faculty can expect more robust reporting, more on-demand (self-service) reporting capability and more standardization of reports. We will be providing detailed instructions and training to transition to the new reporting process as the project gets closer to go-live.
Bobcat Buy is being integrated into the Oracle Cloud Financials system. This allows us to expand the catalog and ordering options for Bobcat Buy users and streamline workflows and invoicing behind the scenes.
Click here for more information.
The Faculty Portfolio Report will show budget, actuals, and encumbrances (“Commitments” in Oracle). The system itself will not do expense projections; however, you can export the information to Excel to use for expense projections outside of PPM.
In the future state, Bobcat Buy will show as an encumbrance (a “Commitment”) in PPM. However, travel reimbursements and campus recharges will not show as encumbrances in PPM.
Yes—there will be reports that can be run for administrative units for project-based expenditures.
Reports in Oracle can be pulled at any time. In many cases, the system will refresh twice a day, so that reports will continuously show current, up to date information.
PPFM will work primarily in partnership with the Contract & Grant Administration (CGA) department, a business unit of the Office of Research and Economic Development (ORED), Office of External Relations, and key units within the Division of Finance and Administration (DFA), to support a variety of campus stakeholders, such as Faculty and Research Administrators (among others), involving a host of activities including, but not limited to: Contracts & Grants, faculty funding (e.g. faculty startup, research support, etc.), Gifts & Endowments, Capital Projects, and Institutional Projects.
There are a variety of benefits that the newly formed PPFM group, business unit within the Division of Finance and Administration (in partnership with others across campus) will deliver to UC Merced. Those anticipated benefits include;
In addition to the many benefits above, the PPFM unit has been created out of a requirement to comply with UCOP policy, which mandates that the Accounting function must own the Oracle Project Portfolio Module (PPM) within the new system, and the related projects/grants tasks. More information regarding role-based policies can be found in diagram 2.
Below is a high-level visual of the future state end-to-end Contracts/Grants journey – including touchpoints, realms of ownership, and areas of collaboration. Faculty will always initiate the Contracts/Grants process, where it’s then supported by groups within ORED (Note: ORED-CGA will continue to manage guidance, policy and non-financial post award functions from award setup- closeout through solid partnerships with DFA and established relationships with faculty and sponsors) with DFA managing the data within the financial system. From there, ongoing financial management (including regular reporting), compliance (including monitoring and notification of spend limits and allowable spend types) and eventual closeout of Contracts/Grants will be handled by PPFM.
It should be noted that the below diagram 1 represents the existing process; however, modifications to the proposal and awards process are currently being developed in order to increase the level of Faculty support provided. Further, all communications within the green bubble are system generated notices and automated communications from the new Oracle based Alpha Financial System designed to be automatically delivered to Faculty, Research Administrators, and ORED in order to support research.
ORED-CGA and PPFM/DFA have worked collaboratively to define their roles and responsibilities throughout the Contracts/Grants lifecycle. Below is a step-by-step guide demonstrating who between ORED/CGA and PPFM/DFA owns what action, including the corresponding policy guidance along the way.
Live demo sessions on navigating the “ins and outs” of Faculty Portfolio View/Project Portfolio Reporting are being targeted for Fall 2020 depending on progress of data conversion for the Alpha project. The sessions will be geared towards Faculty and Research Administrators who will use the tool more regularly, though all are welcome to join. Additionally, formal training on the use of Faculty Portfolio View/Project Portfolio Reporting will be created by the Alpha Financials Project Training Team in preparation for Oracle Financials system Go-Live slated for January 2021. Stay tuned - more details to come!
Working in partnership with ORED, we’ve been able to transition, over the last several weeks for general ledger activity going back to April 1, 2020 for the following activity:
|
|
|
Office of Research and Economic Development (ORED)
Questions related to Office of Research and Economic Development (ORED) can be sent to oredrequests@ucmerced.edu
Project Portfolio Financial Management (PPFM)
If you have any additional questions about PPFM you can email the PPFM Mailbox at ppfm@ucmerced.edu.