Oracle E-Business EAM Integration to P6
Global Production Management with P6
Written by Nicole Jardin
Client Overview
As Canada's largest potash mining organization with over 20 mines in North America, managing global production supply is critical. Planning daily production, weekly short outages and monthly maintenance days while implementing larger capital projects and major shutdowns is very challenging. Using spreadsheets and lists was not working particularly well for production planning and productivity analysis in real time.
Challenges
-
Consistent coordination of Shutdowns and Capital Projects in short work windows while maintaining production and productivity forecasting
-
Detailed scope planning and resource planning across underground and above ground skilled resources
-
Easy updating, forecasting and realtime earned value analysis during the shutdown work and contractor productivity
Results
-
Realtime updates from Oracle E-Business EAM into P6 for Projects, Work Orders, Tasks and Resources allowing for easier plan development for maintenance work, mini-outage work, turnaround work windows and capital programs across several plants
-
Implemented within 6 months including dev, test, QA, and production. P6-Loader was used to move the P6 coding structures, EPS, OBS, codes, UDFs, and resources in a matter of minutes and to maintain these environments.
-
Better analysis of planned resource requirements, spending planning and timeframes across the capital programs throughout the plants
-
Improved delivery on outage deadlines, timeframes and what-if capability particularly related to managing production capacity across the plants
-
Better understanding of mining equipment and productivity rates for improved forecasting. Reduced effort to build the schedules, allowing better management of the short 1-2 power outage windows.
-
P6-Calculator ensured auto-archiving of the projects and work orders to keep the P6 database clean and manageable and to produce rollup data for resources and flagging of integration changes
Integrations Case Studies
Program Management Case Studies
P6-Calculator Case Studies
on Monday, 22 March 2021.
Posted in Case Studies
Large oil and gas company uses P6-Loader to develop turnaround plans.
Moving to consistent processes and reporting
Written by Nicole Jardin
Client Overview
Large oil plant in Australia needed a more efficient way to develop their turnaround plans. This was typically being done by an outsourced engineering and contractor joint venture every 2 years. So each time different processes and team members were working with different methodologies.
Challenges
-
Struggling to build detailed schedules since they had to pull data from internal systems and contractor inputs and remap the data into standard template formats
-
Working with contractors during the turnaround providing updates in different ways
Results
-
Streamlined data imports by over 30%
-
Drastically reduced manual data entry by 50%
-
Improved standardized reporting during the planning stage and execution
-
Expanding P6-Loader’s use into other groups to improve the usage of P6
From Our Customer
We saved 6 weeks on our planning process, and were able to get feedback more quickly after using P6-Loader.
on Sunday, 21 March 2021.
Posted in Case Studies
Used the P6-Loader to move a client to the Primavera Cloud in two weeks.
In 2 weeks - all projects were ready
Written by Nicole Jardin
Client Overview
Project Management specialist overseeing a large building remediation program after Hurricane Sandy needed to move from on-premise P6 program development to the Primavera Cloud to share schedule information with Contractors and Owners Representatives.
Challenges
-
Setup a new P6 environment in the Primavera Cloud within 2 weeks
-
Transfer all P6 program data for over 750 projects in a standalone PPM database
-
Over 400 baselines needed to be moved as well
Results
-
Emerald provided P6-Loader aaS
-
Enterprise Data: built and loaded for EPS, OBS, Users, User Profiles
-
Global Data: merged and cleaned up while loading over 400 Resources and 50 Calendars
-
Project Data: 756 projects, 455 Baselines, 265,802 activities. Activity codes, resource assignments, and relationships were all transferred.
-
Approach - used a combination of XER and P6-Loader functionality
-
Saved weeks of manually re-creating global data, users/profiles, and baseline management. Went live 1 week after getting files.
Program Management Case Studies
on Sunday, 21 March 2021.
Posted in Case Studies
Large Australian rail company uses the P6-Loader to integrate SAP to Primavera P6.
Monthly cost loading made easy for hundreds of projects.
Written by Nicole Jardin
Client Overview
Large railway projects need a tremendous amount of coordination and strong scheduling. Managing monthly costs and updates from several regional contractors so that shareholders can be informed of status can be a challenge.
Results
-
Streamlined the efforts of updating down from 4 person weeks to 2 person days. Data Imports by over 30%.
-
Errors and mismatches were reduced significantly
-
Several macros made this extract and upload much more reliable than manual inputs
-
Reloading every day during the update window was smooth
From Our Customer
SAP to P6 updates were easy to perform so that forecasting was much more accurate.
Integrations Case Studies
Transportation Case Studies
Primavera P6 Case Studies
on Sunday, 21 March 2021.
Posted in Case Studies
We integrated Aveva with P6 to drastically reduce the time our client spent updating their capital projects
Simplifying Engineering Updates
Written by Nicole Jardin
Client Overview
One of Canada's many potash companies runs all their capital projects with Primavera P6. With one scheduler on the team, it is difficult to keep up with the dozens of projects on the go to ensure monthly reporting is accurate.
Challenges
-
Updating some 20+ projects in P6 was time consuming at the end of each month
-
Mid-month reporting was not easy to do without spending extra hours to get all the updates into P6
-
Going over the updates with the extended team took a lot of coordination to schedule with so many people with different schedules
Results
-
Integrated documents statuses from Aveva
-
Templated the different task types and package types with preset calculation methods
-
Documents planned, in progress, completed, deleted
-
Set the start dates of tasks in progress, updated the percent completes and flagged changes to the tasks
-
Updated the resources - actual labor units
Integrations Case Studies
on Sunday, 21 March 2021.
Posted in Case Studies
In this short video, we will briefly discuss and demonstrate the rolldown of calendars from the global level to the project level in Primavera P6 using the P6-Loader.
The P6-Loader is a custom Primavera P6 add-on tool that was developed by Emerald Associates in order to simplify the process of loading, extracting, and updating Primavera P6 data, ensuring the process is smoother, easier, and much faster. In addition, the P6-Loader boasts multiple utilities that allow you to easily clean up and work with your data in Primavera P6. Cloud-enabled and Oracle Cloud marketplace approved, the P6-Loader can make your job a whole lot easier!
on Thursday, 18 February 2021.
The P6-Loader is a custom tool developed by the team at Emerald Associates that allows you to extract data out of Primavera P6, as well as import data back in to P6. Additionally, you can use the P6-Loader to help you clean up your database, as well as deal with the information already in P6, such as Global Data.
In this video, we're going to take a quick look at setting up a new P6 database using the P6-Loader. Specifically, we will demonstrate the creation of an empty OBS structure and an empty EPS structure in a brand new database, using information from an already existing database.
on Thursday, 18 February 2021.
P6-Loader is a custom Primavera P6 add-on tool that was developed by Emerald Associates to allow you to easily extract any data out of Primavera P6, as well as load information back in to P6. Additionally, it has many useful utilities to help you work with data residing in P6.
In this short video, we are going to take a look at usage sheets in P6-Loader, and how they can assist you with the clean up of your P6 databases. Check it out to learn how you can easily identify what is in need of cleaning up, as well as locate any duplicates that may exist in your database.
on Tuesday, 16 February 2021.
The daunting task of cleaning up 10 years of projects was made easy with P6-Loader so archiving, cleaning, fixing and upgrading could happen.
P6-Loader made it easy
Written by Sue Hopkins
Client Overview
The client is a large Canadian producer, transporter and marketer of natural gas, oil and natural gas liquids. They use P6 for many project controls functions including their capital program. After years of working in a P6 database they wanted to move to a clean P6 environment.
Challenges
-
Their IT department needed assistance in Upgrading and Migrating Major Projects and Facility, Engineering and Construction databases to a new environment
-
Their Security Profiles, User and Global Data, some of which were corrupt needed to be cleaned up prior to move to new environments
-
Move large live projects with up to 100 baselines to the new environment in a short amount of time while users were not active
Results
-
Databases edited and cleaned up prior to migration including Security Profiles, User and Global Data, some of which were corrupt, using the P6-Loader tool
-
Archived old projects in place and moved over 400 projects and baselines to a new environment with only one weekend of down time
-
Migrated data was validated and compared to previous database to ensure all data was moved accurately
-
Saved hundreds of hours of manual work
Primavera P6 Case Studies
on Thursday, 17 December 2020.
Posted in Case Studies
Large Pre-Fab Manufacturer uses P6-Loader to get control over their planning, scheduling and cost controls.
competing priorities resolved
Written by Nicole Jardin
Client Overview
Calgary pre-fab manufacturer with international projects needed to get better control over the planning, scheduling and cost controls of several hundred projects on the go at once for wide ranging clients.
Challenges
-
Fabrication team was swamped and priorities were unclear
-
Change orders were impacting priorities
-
Needed a common approach to planning 250 projects on the go
Results
-
Used the P6-Loader to develop P6 Structures - EPS/OBS/Cost Accounts
-
Fully templated program
-
Cost Loading Changes with Overhead, Profit tracking
-
Daily Costing Reporting
Manufacturing Case Studies
on Wednesday, 16 December 2020.
Posted in Case Studies
In P6, identifying which projects are using each Activity Code in a quick, consolidated, easy to use manner is challenging. Especially when you consider some clients have a LOT of baselines.
But is this is r-e-a-l-l-y information we need to be able to capture? In my experience, there are a number of scenarios where that answer is a resounding “Yes”! One common example – the Activity Codes Dictionary needs to be cleaned up.
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Thursday, 29 November 2018.
Posted in All Articles, P6-Loader, Primavera P6
Emerald Associates is well known in the US and Canada for our homegrown add-on tools for Primavera P6. We have assisted numerous companies in many diverse areas to get the most out of their P6 software. You may wonder how our tools can assist in the Department of Transportation (DOT) field to get more done in P6 with less time while still providing useful data to your stakeholders and remaining good stewards of the public's funds. Our tools will help you do more work in less time, so that your project management group has more time to analyze and perfect their schedules.
Written by Sue Fermelia - Implementation Specialist
on Friday, 27 July 2018.
Posted in All Articles, P6-Loader
In P6, identifying each specific project using each of the Global Calendars in a concise, fast, easy to use manner is challenging. Some may think this is not necessary very often, but in my experience, it has been quite the opposite!
Is this functionality already handled in Primavera P6, Client or Web? A very good question - let’s have a look.
Written by Mary Lynn Backstrom, PMP, PMI-SP, PMI-BA – Implementation Specialist
on Tuesday, 24 April 2018.
Posted in All Articles, P6-Loader
When you have a large number of users in your P6 database, it is surprising how quickly that database can get “clogged up” with a lot of unwanted data. This happens even when using Sandbox databases, restricting privileges and every other trick you have thought of; long time P6 users know what I am talking about.
Written by Nicole Jardin, P.Eng. - CEO
on Wednesday, 14 February 2018.
Posted in All Articles, P6-Loader, Primavera P6
On every Turnaround there are Pre-Turnaround activities that do not get done prior to the actual Turnaround and need to be moved into the Turnaround phase of the schedule.
The challenge is how to record actual hours earned in the PRE phase vs the TA phase, since a large number of these activities already have earned hours associated with them. Simply moving the activities would decrease the reporting of hours in PRE and create earned hours in TA for work that was actually done in PRE.
This can be done simply and quickly with P6-Loader.
Written by Sue Fermelia - Implementation Specialist
on Wednesday, 10 January 2018.
Posted in All Articles, P6-Loader
