Project Partners Blog


Posts Tagged ‘oracle projects’

Project Partners Blog Author:
Sachin Gupta | Oracle Primavera Solution Architect – Application Integration Specialist

In recent years, many customers have preferred Oracle Primavera P6 EPPM applications on the cloud. It saves them from typical deployment and system administration tasks of creating databases, hosting servers, configuring supporting technologies, and integrating supported applications.

One of the most pertaining questions asked by new and existing customers alike is – how easy it is to integrate Oracle Primavera P6 EPPM applications on the cloud with other application?

Let us look at this in more detail.

Most of the time cloud customers do not have in-house IT staff to maintain infrastructure or a team of programmers. Their requirements are often small and specific like:

  • automating calculation or rolling up some UDF data
  • performing certain task conditionally
  • perform certain task periodically for which there is no schedule/background job available
  • other custom functionality more specific to their organization
  • exchanging data with other application

Being a cloud customer, they often think that it is not possible to have a solution around it without spending a significant amount of money on servers and license cost of related software. They are also concerned with ongoing cost of maintaining and monitoring the infrastructure. So, they end up using excel or similar tool and maintain data manually. This comes with its own set of issues like human error, redundant data, etc.

Well, there is a relatively simple solution to all this and much more – Serverless Architecture.

Use AWS Lambda to run integration code with zero administration. AWS Lambda is a serverless compute service that allows to run code without provisioning or managing servers, creating workload-aware cluster scaling logic, maintaining event integrations, or managing run-times. AWS Lambda in conjunction with other services like Amazon S3, Amazon DynamoDB, Amazon API Gateway, can be used to run specific integration code.

Oracle Primavera P6 EPPM provides web services. These web services can be consumed in the integration solution to meet business requirement. The integration solution can be hosted on AWS Lambda to perform the desired operation at specific time and frequency.

If you have a similar requirement and want to discuss how serverless architecture can be utilized effectively, then drop an email to Sachin directly at sgupta@projectp.com.

Project Partners, a long-standing Oracle Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

www.projectp.com

 

 

 

Project Partners Blog Author:
Sachin Gupta | Oracle Primavera Solution Architect – Application Integration Specialist

Activity Excel Utility Using P6 EPPM Web Services

P6 EPPM Web Services is a great way of integrating external systems with P6 EPPM application. Activity excel utility allows reading and writing data to Oracle Primavera P6 EPPM using P6 EPPM Web Services.

Activity excel utility allow user to:

  • Maintain activity details
  • Maintain activity relationship
  • Assign global and project activity code to activity
  • Assign resource or role to activity
  • Maintain activity steps
  • Maintain activity UDF
  • Maintain resource assignment UDF
  • Maintain activity step UDF

 

 

 

 

 

 

 

 

Update Project List – download list of projects from the connected P6 EPPM application

Read All Data – allows downloading all activity data at the click of button

Clear All Data – removes data from all worksheets

Read – Read or download data from P6 EPPM using Web Services

Modify – Create, Update or Delete the data for the corresponding business object

Screenshots of some of the worksheet are shown here for reference

Activity Details allows creating new activity and maintaining existing activity data. CRUD flag is used to identify the operation to be performed

“C” – Create, “U” – Update, “D” – Delete, “R” – Read.

Activity data is downloaded with CRUD flag as “R”

 

Activity attributes like Duration Type, % Complete Type, etc. use same set of values as in the application.

Activity Relationship can be created and updated within excel utility. Relationship Type has a predefined set of values as used in application – Task Dependent, Resource Dependent, Level of Effort, Start Milestone, Finish Milestone, WBS Summary.

 

 

 

Activity Code Assignment allow user to assign activity code to activities. Both global and project specific activity codes can be assigned to activities.

 

 

 

Resource Assignment allow user to assign resource/role to activities. This can be used to maintain resource assignment for activities of the project.

 

 

 

User interface for all other worksheets are similar to the one shown above.

Download evaluation copy here.

—————————-

Project Partners, a long-standing Oracle Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

www.projectp.com


Questions About ERP | PPM Cloud?
  Time Slots Filling Up Fast, But Still Available!

Check it out and join us during the month of May & June as we offer our DEDICATED office chats. Project Partners ERP | PPM Cloud subject matter experts will be available for a deep dive informative discussion addressing your questions around your key top of mind issues/pain points. We’ll share our insights, guidance and solutions within your personalized FREE Q&A phone consultation.

Don’t miss this opportunity to ask your questions, no matter where you are in your Oracle ERP | PPM Cloud journey. We look forward to having great discussions and providing you with expert insight, analysis and the answers you’re searching for.

LEVERAGE OUR EXPERTISE TO THE FULLEST.

We’re here to help and solution with you.  Simply Register Below & Secure Your Spot for a One-on-One Office Hour Chat!

SECURE YOUR OFFICE CHAT TIME HERE


www.projectp.com


INTRODUCING PROJECT PARTNERS PROJECT APPLICATION – PROCESS ASSESSMENT SERVICES

Whether helping you uncover hidden project challenges stemming from your current functional and operational applications/processes to understanding the why and how to migrate to the cloud, our Project Application/Process Assessment services give you the rigorous framework you need to grow and quickly achieve organizational success.

Our Team Will Partner With You to Assess Your Project Applications and Background Processes Inside and Out. 

Projects is the link that can penetrate your entire organization and requires careful analysis to maximize efficient operations.  If you are experiencing what appears to be a pain in your organization’s business process and applications, then now is the time to take another look and assess with the experts.

We are extending a SPECIAL ASSESSMENT offering that has proven results for our customers.  Just take the SIMPLE next steps to obtain Project Partners holistic approach to a full assessment and associated discount offer.

CLICK | SCHEDULE AN ASSESSMENT HERE TO GET STARTED

www.projectp.com

Your Organization Could Have a Whole New Level of VISIBILITY INTO PROGRESS & PERFORMANCE OF PROJECTS?

PROJECT PARTNERS ORACLE PRIMAVERA UNIFIER CONSULTING SERVICES has successfully helped many of our customers by providing their organizations a best-in-class cloud-based solution that enables governance across all project phases, from planning and building to operations and maintenance.

The Oracle Primavera Unifier solution manages capital projects and facilities of any size in every vertical market. It combines rich cost management and control, document management, schedule and resource management, fund management, and more through “base” pre-built modules. In addition to its robust functionalities, it also has the ability to create custom modules to meet each organization’s unique business requirements.

We are a Primavera Authorized Reseller and are considered by our customers as one of the best in “Unifying”, integrating and tying your data together, even if your organization is running outside of the Oracle footprint. That’s our proven strength.

GO TO THE NEXT LEVEL WITH A BETTER PLAN FOR A RAPID PROJECT EXECUTION.

CLICK HERE NOW
To learn more about the FEATURES & BENEFITS and get a glimpse into how our
Oracle Primavera Unifier Consulting solution works with a brief DEMO HERE.

For immediate response/call back please connect with us here:  P: #1.650.712.6203   Email: cfryc@projectp.com