APPS Database Oracle Upgrade/ Migration



Project is 10% complete, starting on Mon 4/17/23 and ending on Tue 10/31/23.

In Process [In Process]

10% complete, updated on Tue 6/27/23 4:40 PM by Wendy Bentley

Changed Status from New to In Process.
Changed Percent Complete from 0% to 10%.
Changed Health from None - No health has been set to Green - On track.
The Integrations and Development team is finishing up analysis on this project and will soon start the upgrade process.


Mon 4/17/23 - Tue 10/31/23
Enterprise Applications
Business Applications / Existing business application support
IT Projects / DoIT Project
Green - On track
Newest version of Oracle with long term support.
All applications and services successfully cut over to new database.
Fri 5/26/23 2:21 PM
Tue 6/27/23 4:40 PM

Project Costs

Is funding already secured for this request?
Funding is not necessary

Project Details

Project Champion
Person who voluntarily takes special interest in the adoption, implementation, and success of the project. They will help enforce the project solution with internal resources and promote it across campus.
Divisional VP Support
Does your divisional VP support this request?
What would a successful solution look like?
What outcome will you have at the conclusion of this project? If this proposal is one of a multi-phase project, please explain your plans, goals, and timelines for subsequent phases.
All systems, applications and integrations utilizing the APPS database successfully migrate to new database with minimal impact or disruption.
Is this project mandated or required?
Required (not mandated) to keep a campus system running properly

Project Impact

How will you measure the impact of this project?
What are some metrics or KPIs that will be used to measure success? Think about the five metrics to measure: quality, quantity, timeliness, cost, and customer satisfaction.
The decommission of the old APPS database will be measured by security metrics and reduced risk to campus.
What are the consequences of not doing this project?
For example: direct significant negative consequences to the University, unable to conduct basic services; failure to resolve customer complaints or requests; loss of opportunity for improved service delivery or efficiency. Please explain.
We run the risk of dozens of applications, services, integrations breaking if there are issues with the current database. Being out of support, we would not have access to Oracle support and resolution.
How many employees will be impacted by this change?
Select the size of the employee population that will be impacted by this request.
A few
How many students will be impacted by this change?
Select the size of the student population that will be impacted by this request.

Project Resources & Effort

What resources will this project require?
Identify the department and/or individuals that might need to work on this project and the level of effort required (minimal, moderate, extensive/substantial).
Complexity of Implementation
What is the complexity of the project?
Moderate (multiple interfaces/impacts/dependencies)
What is the solution type?
The solution type translates to the level of impact on IT staffing and technology maintenance. Based on consultation with your IT representative, pick the best fit for your proposed solution.
Complete new system or complete replacement of existing system


The shared APPS Oracle database, used to host application and system database schemas is beyond end of life and needs to be replaced. ESYS will provision a new Oracle database with the latest version of Oracle and EAPP will migrate schemas/data and update applications for all EAPP managed systems. Additionally, there will be users on the database outside DoIT. ESYS and EAPP will work collaboratively to identify and assist outside groups with their migration.


Alternate Manager(s)


Stakeholders (2)

Scott Kodai
Scott Kodai
Senior Director, Enterprise Applications
Fri 5/26/23 2:05 PM
Steve Krok
Chico State
Fri 5/26/23 2:05 PM