Project Partners Blog


Archive for the ‘Oracle Primavera’ Category

 

 

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

 

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

Primavera Data Service (PDS) is a new free offering for P6 and Unifier cloud customer to enable and use. It exposes a set of endpoints that enables extraction of data from application database. It uses data service endpoints to discover which database tables and columns are accessible and then run queries against them. It provides read only access to data. It is available to both new and existing cloud customers.

Primavera Data Service can be used to read data from cloud environment. Data can be extracted in CSV file format or it can be stored in local database. Once the data is extracted, either in CSV file or stored in local database, reports and dashboard can be built on such data. The complete process to read the data using PDS and writing it to local database or CSV file can be automated. It can be run at pre-determined time or ad-hoc basis based on the requirement.

Primavera Data Service uses JavaScript Object Notation. JSON, is an open-standard file format or data interchange format that uses human-readable text to transmit data objects consisting of attribute–value pairs and array data types (or any other serializable value) – Through JSON Applications, PDS makes use of RESTful end points to access the cloud database.

Primavera Data Service provide read only access to the following for P6 EPPM:

  • SELECT privileges on all P6 tables (including PX tables) except ADMIN_CONFIG, BRE_REGISTRY, PREFER, PUBUSER, SETTINGS, and tables that start with DLT, DR$ and MDRT_.
  • For granted tables, synonyms use the same name as the table.
  • Views for PXRPTUSER (ds_p6reportuser config is used to access these views).

Note that this data need to be extracted periodically to keep it current, although it will still not be real time but good for data analysis and generating month end reports using tools like Tableau, Microsoft Power BI, etc.

For real time data, P6 web services can be used. P6 web services can read and write data and can be used for integration where as PDS can only be used to read data.

Limitation:

  1. The data service cannot be used to read BLOB or CLOB fields.
  2. Complex SQL queries cannot be written to extract data.
  3. API does not support queries using LIKE and IN conditions.

*Important NOTE: PDS is currently available for customers running P6/Unifier 19.4 or later in GBUCS environments.  PDS is available for OCI running P6/Unifier 19.12.1/20.1 or later.

List of tables available for P6 EPPM with configuration ds_p6adminuser:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

List of views available for P6 EPPM with configuration ds_p6adminuser:

 

List of views available for P6 EPPM with configuration ds_p6reportuser:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If you are looking for a solution to extract data from cloud database (P6, Unifier or Oracle Primavera Cloud) and build reporting solution, or looking for a demo to extract the data from your cloud environment one time to see how the data looks like, contact us at sgupta@projectp.com, or http://www.projectp.com/demos/contact_us.cgi

*Reference: How P6 and Unifier Cloud Customers Can Utilize Primavera Data Service (PDS) to Access their Cloud Database (Doc ID 2552583.1)

For more information on Project Partners go to www.projectp.com

 

 

 

FOR ANNOUNCEMENT | IMMEDIATE RELEASE


Project Partners, LLC. receives MBE certification from WRMSDC

A privately held minority consulting services and software solutions firm achieves National
Minority Business Enterprise (MBE) certification

_______________________________________

Half moon Bay, CA–July, 2020 – Project Partners, the world’s foremost Experts in Enterprise Project Portfolio Management™ for project-centric organizations is proud to announce that is has received the Minority Business Enterprise (MBE) of the Western Regional Minority Supplier Development Council (WRMSDC) National certification. After completing the extensive application, meeting, and passing the review and rigorous requirements of the MBE certification process, this certification award proves that Project Partners, LLC meets the requirements to do business with large corporations, local, state, and federal government departments as a minority business entity. This milestone is an exciting opportunity for Project Partners with its mission to expand and continue to deliver a consistent level of high-quality services that positively impact the organizations it serves.

“Receiving this coveted certification is definitely an honor.  I know that the WRMSDC fully supports the growth and welfare of minority communities by championing the use of minority-owned businesses, therefore has a stringent national certification process.  We are proud to have successfully gone through the process and been awarded our MBE certification,” says Randy Egger, CEO and President of Project Partners.  “We also look forward to participating and leveraging WRMSDC’s community of MBE’s and tools that will provide us access to new prospects in our pursuit for growth and development of our products and services exclusively to project-centric organizations leveraging Oracle Technology. It’s a tremendous opportunity.”

To learn more about Project Partners, LLC, including its new status, visit www.projectp.com

###

About Project Partners, LLC:  Project Partners, LLC is a privately held firm headquartered in Half Moon Bay, California, offering consulting services and software solutions.  Project Partners is a long-standing Oracle partner and a single point solution provider for all requirements across Oracle ERP | PPM Cloud, Oracle E-Business Suite, Oracle Primavera applications for project-driven organizations. As a 100% minority-owned business with MRMSDC certification as an MBE, Project Partners is committed to stellar service and developing innovative and sustainable solutions for their clients.

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

A FRESH APPROACH TO ORACLE CAPITAL PROJECTS AND FIXED ASSETS

In this webinar, we’ll discuss how to move beyond to drive efficiencies and reporting accuracies with a fresh approach to Oracle Capital Projects, fixed assets, and showcase how Project Partners successfully delivered this solution for a customer that is using a third party fixed assets system to manage their capital projects.

We Invite You To Join Us And Learn More About This Powerful Solution:  

• The Capital Projects functionality delivered in Oracle Project Costing has enabled many of our customers to take advantage of the native integration to Oracle Fixed Assets

• However, there are industries that require a greater level of detail, control for estimating and allocating asset costs

• To address this, our team developed a solution that supports the need for greater level of detail, control of asset costs and allocations – which we will review and showcase for you

REGISTRATION OPEN NOW

Register today, and feel free to review our resource library and services overview at www.projectp.com.  HAVE QUESTIONS?  Need more information about this Webinar or other services  – We’re here to help!

Schedule a Consultation:
Phone: #1.650.712.6203   Email: cfryc@projectp.com

—————————-

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

 

Project Partners Oracle Primavera P6 EPPM

Implementation Services

Making Your Cloud Vision a Reality.


Through implementation, customization, and integration Project Partners’ Oracle Primavera P6 EPPM experts provide clients with a comprehensive, real-time view of their portfolio, enabling a deep understanding of all projects within an organization anywhere in the world.

Oracle Primavera P6 Enterprise Project Portfolio Management (EPPM) is the most powerful, robust, and easy-to-use solution for globally prioritizing, planning, managing, and executing projects, programs, and portfolios in asset-intensive industries. P6 EPPM solution enables project driven organizations to intelligently manage their programs and projects—from small and simple to large and complex.

Are You Using The Latest And Greatest P6 EPPM Versions?

P6 EPPM cloud version  provides easy access to enhanced features that make it an excellent tool for project centric organizations to meet complex Project Portfolio Management requirements. In addition, it provides comprehensive business and industry solutions based on leading practices enabling  increased productivity, accelerating business performance and providing a lower cost of ownership across the organization.

Ready to Move to the Cloud?

Oracle Primavera P6 EPPM is Ready for You.

We provide expert cloud migration services to integrate P6 EPPM with your finance and asset management systems, providing a consolidated view of the  enterprise project portfolio for an accurate, up-to-date view of projects, people and financial performance.

With Project Partners comprehensive approach to implementation, we can quickly and easily – WITHIN 4-6 WEEKS – provide a full assessment, and develop your migration path to make your Cloud Vision a Reality.

 LEARN  MORE ABOUT OUR ASSESSMENT OFFER AND
CLICK HERE NOW TO GET STARTED

www.projectp.com | Phone: +1.650.712.6200

Providing Our Customers With Better Project Delivery Through Full-Service…

PROJECT APPLICATION | PROCESS ASSESSMENTS

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 achieve success quickly.

We 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.

SPECIAL ASSESSMENT OFFER

With Your SIMPLE next steps to obtain Project Partners holistic approach to a full assessment and associated discount offer.

 

ORACLE INSTANTIS ENTERPRISETRACK IS THE SOLUTION

Project Partners is considered the Global Experts in Oracle Instantis EnterpriseTrack — Providing Your Organization full and continuous support from our specialized Instantis practice.

Instantis can improve financial performance and drive operational excellence with a top-down approach to managing, tracking, and reporting on enterprise strategies, projects, portfolios, processes, resources, and results.

Project Partners and Instantis helping you optimize project and resource investments. Working with our customers to provide an Oracle-approved solution to get you live and running on Instantis in 8 to 12 weeks. Oracle Accelerate for IT Portfolio Management With Oracle’s Instantis EnterpriseTrack™ empowers IT to become a strategic business partner in helping drive the growth of their firm.

Consider this competitive alternative that is proven, cost effective, easy to deploy quickly, easy to use and administer, and easy to achieve a compelling ROI.
Accelerate your Project Portfolio Management with Project Partners, Oracle’s preferred partner, providing end-to-end INSTANTIS SERVICE OFFERINGS.

LEARN MORE HERE

Connect With us Today – Schedule a Consultation: Phone: #1.650.712.6203   Email: cfryc@projectp.com

MULTIPLE, LARGE, & COMPLEX PROJECTS CAN LEAD TO MANY CHALLENGES FOR YOUR ORGANIZATION, HINDERING ITS GROWTH.

Growing rapidly and searching to improve operational efficiencies that will allow you to take on more business?

PROJECT PARTNERS ORACLE PRIMAVERA UNIFIER CONSULTING SERVICES

 We have 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, and seamlessly manages capital projects and facilities of any size, in every vertical market across the globe.

OUR PROVEN STRENGTH.

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.

CHECK OUT OUR SOLUTIONS FEATURES/BENEFITS DEMO

REQUEST A UNIFIER SOLUTION DEMO NOW

 

Project Partners solution experts will help your team assess, innovate, transform, and lead your business with our Primavera Unifier Services.

Experience a whole New Level of Visibility into Progress & Performance of Projects.

Connect With us Today – Schedule a Consultation:
Phone: #1.650.712.6203   Email: cfryc@projectp.com

PROJECT PARTNERS PROUDLY ACHIEVES PLATINUM PARTNER STATUS IN
ORACLE PARTNERNETWORK (OPN)

HALF MOON BAY, Calif., January 16, 2019 – Project Partners, a global leader in optimizing business processes and IT investments within project-driven organizations, today announced that it has achieved Platinum partner status in Oracle PartnerNetwork (OPN).  By attaining Platinum level membership, Oracle has recognized Project Partners for its in-depth expertise and continued excellence in providing services for Oracle applications and technology.

“We are honored to be in the highest level of the OPN Program. With our new designation as a Platinum Partner in the Oracle PartnerNetwork (OPN), Project Partners will continue to strengthen and build upon its 20+ year relationship with Oracle,” said Randy Egger, President/CEO, Project Partners.  Our global team has continually demonstrated deep application expertise and are working to obtain additional certified specializations across Oracle application solutions areas to better serve our project-centric customers.”

The company offers deep industry expertise across key Oracle applications and technologies including the Oracle ERP Cloud, Oracle E-Business Suite, and Oracle Primavera applications.  In addition, we have developed products and solutions to support and augment our customers’ off-the-shelf products.  We are proud to be widely recognized as The Experts in Solutions for Project-Driven Organizations™ and look forward to continuing collaboration, sharing industry experiences and leveraging our Platinum Partner status to enable organizations, partners and Oracle.

With its Platinum status, Project Partners will benefit with the high level of engagement, commitment and resources available to OPN partners.  Platinum members receive dedicated virtual account management support to build joint development plans and help broaden specialization areas and revenue opportunities. Additional benefits include priority placement in the OPN Solutions Catalog, one free application integration validated by Oracle, joint marketing and sales opportunities, discounted training and more. For more information about the benefits of becoming an OPN Platinum level partner, please visit: http://www.oracle.com/us/partnerships/index.htm

———————————–

About Project Partners, LLC.

Headquartered in Half Moon Bay, California | Project Partners is the global leader in optimizing business processes and IT investments within project-driven organizations. We are dedicated to helping businesses achieve their goals with smart, effective and scalable Oracle Application solutions that improve processes and deploy technology to maximize project life cycle ROI. Our business process experts understand and support customers with their evolving business models and help them drive productivity to meet the demands of the market and their organization.

Project Partners has a diverse team who is expert in leveraging Oracle’s ERP Cloud, E-Business Suite and Primavera solutions. We have global locations worldwide to support multi-geographical operations and have executed implementations for hundreds of clients who manage tens of thousands of projects, thousands of users, multiple languages and currencies. In addition, we have developed products and solutions to support and augment our customers’ off-the-shelf products.  Project Partners is proud to be widely recognized as The Experts in Solutions for Project-Driven Organizations™.

Project Partners is a proud Oracle Platinum Partner, Oracle Certified Education provider and authorized Reseller of Primavera and Oracle Cloud PPM, and Cloud Financials.  We hold an Oracle Cloud Standard certification, with specializations in Oracle® E-Business Suite™ with Projects, Primavera and Oracle Validated Integration’s in EBS.

For more information, visit: http://www.projectp.com/

———————————–

About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) is Oracle’s partner program that provides partners with a differentiated advantage to develop, sell and implement Oracle solutions. OPN offers resources to train and support specialized knowledge of Oracle’s products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to be recognized and rewarded for their investment in Oracle Cloud. Partners engaging with Oracle will be able to differentiate their Oracle Cloud expertise and success with customers through the OPN Cloud program – an innovative program that complements existing OPN program levels with tiers of recognition and progressive benefits for partners working with Oracle Cloud.

To find out more visit: http://www.oracle.com/partners

 

# # #