System Data Table Schema

About Oracle Primavera P6 Enterprise Project Portfolio Management

Oracle Primavera P6 Enterprise Project Portfolio Management (P6 EPPM) is arobust and easy-to-use integrated solution for G Lobally prioritizing, planning,managing, and executing projects, programs, and portfolios. It optimizesrole-specific functionality to satisfy each team member ' s needs,responsibilities, and skills. IT provides a single solution for managingprojects of any size, adapts to various levels of complexity within a project,an D intelligently scales to meet the needs of various roles, functions, orskill levels in your organization and on your Proj ECT team.

Thousands of companies rely on P6 EPPM to:

• Plan, schedule, and manage the right strategic mix ofprojects
• Make informed project, cost, and resource managementdecisions
• Enhance team collaboration and workflow productivity
• Maximize each project contributor ' s skills andresponsibilities
• Track progress and optimize capacity for maximumprofitability
• Deliver programs and projects on time and within budget
• Share data with human capital, financial management, andenterprise resource planning systems

Actual deployments require a variety of databases, servers, Applications,and supporting technologies. P6 EPPM also integrates with many other optionalsolutions such as Primavera contract Management, Oracle Primavera PRIME,PR Imavera unifier, Oracle Primavera Risk Analysis, Oracle PPM, and primaveraearned Value Management.

Working with the Oracle Primavera P6 eppmsuite

Depending on your organization ' sspecific deployment, P6 EPPM generally consists of the applications, Functions,and Databas Es depicted below.

Applications:

P6:most users would rely almostexclusively on the P6 Web application running in a standard Web browser. Simplytermed P6, it is the primary interface for administering and managing projects.

P6 mobile:allows team members toprovide status on their tasks and to enter timesheets while working "onthe go".

P6 Team Member Web:this Webinterface allows team members to provide status on their tasks and record Timein timesheets US ing a Web browser.

P6 Team Member e-mail Statusingservice:this method allows team members to provide status on their tasks Usingany HTML or Plain Text e-mail application.

P6 Professional for eppm:the p6web application are the main interface for all project management functionality. You can also with the P6 Professional software to take advantage of its coreproject planning and scheduling functionality. The P6 Professional applicationand its features, including P6 Visualizer, and run on Microsoft Windows. P6professional is also available for the users who need to work on their projects Inan offline mode.

P6 Professional Cloud Connect:connects P6 Professional to a EPPM Oracle database on the cloud. P6integration API (in remote mode) was installed by default. Using this, P6 eppmusers working on a WAN environment can achieve performance levels comparable Tocompression server Insta Llation. This is optional for on premises users.

P6 Integration api:a Java-basedapplication Programming Interface (API) enabling your P6 EPPM deployment tointerface with Other components and systems.

P6 EPPM Web services:p6 EPPM Web Services is a integrationtechnology that extends P6 business objects and functionality . Based on openstandards including SOAP, XML and WSDL, P6 EPPM Web Services enables developersto leverage standard interface s to create integrated software solutions thatinteroperate with a wide variety of enterprise software applications running Ona diversity of hardware and operating system platforms.

Primavera Gateway:primaveragateway is a highly configurable application, integrates P6 EPPM with otherproducts for in creased risk and scope management.

Functionality (included with P6 EPPM):

Core Enterprise Functionality:use P6 for all of the following core enterprise functionality:

• Administrationand Enterprise Data:administer user accounts, preferences, views, applicationsettings, and Enterprise Data .
• Project,portfolio, and Resource MANAGEMENT:P6 provides an extensive array of featuresdesigned to optimize all phases of P Roject Management, Resource Management, Andportfolio Management. It includes full support for activities, work breakdownstructures, planning and scheduling, costs, resource administration Andassignment, roles, teams, portfolio analysis, capacity planning, Return oninvestment (ROI), and convenient dashboards For measuring performance at Everylevel on any moment.
• DOCUMENTS:P6 includes document management support with or without the optional documentrepository option. Use the optional document collaboration features to conductdocument reviews with key stakeholders to keep projects moving or meetregulatory compliance.
• Workflows:the workflow engine bundled with P6 EPPM provides business Process modelingnotation (BPMN) compliant graphical n Otation that depicts the steps in Yourproject initiation workflows. Use the integrated workflows Portlet tocoordinate the sequence of the tasks for flow between different processparticipants in A series of stages.
• Reports:generate and view Reports using your standard Web browser running P6. Reportscan be generated and routed via e-mail, saved to a gkfx or local file, orprinted to a traditional printer.

Planning and Scheduling:the p6professional component of the suite can be used standalone or connected to aneppm database. IT provides a robust set of features primarily for planners andschedulers, including Reflection Projects and a report des Igner. Use the P6visualizer feature to create and customize visual depictions of complex projectschedule information, including G Antt charts with Grid data, timescaled logicdiagrams, and Schedule Comparison. Some functionality of P6 Professional isavailable only then connected to an EPPM database.

Time REPORTING:P6 EPPM includestimesheet entry in P6 Team Member Web, P6 for Android, and P6 for IOS Withreview and Appro Val support in P6.

Integrated Solutions: Build or deploy other systems and use the P6 integration API, P6 EPPM webservices, or Primav ERA Gateway to integrate them with P6 EPPM. Integrate Riskand Scope functionality from the Oracle Primavera Prime with P6 EPPM via Primaveragateway. Leverage P6 EPPM ' s project planning and scheduling system against Primaveraunifier ' s cost control system via integration W ITH Primavera Gateway.

Technology:

The P6 EPPM database:the maindatabase for all your P6 EPPM data. The EPPM database includes the P6 Extendedschema optimized for reporting.

BPM workflow:the Separateworkflow engine bundled with P6 EPPM.

Oracle BI publisher:thereporting Tool, reports on the data, is exposed in the databasereporting.

The content repository:use anoracle content Repository or any cmis-compliant Repository to host documents INA shared repo Sitory enabling collaborative functionality such as Documentcheck-in/check-out and versioning.

Related Topics

About Oracle Primavera P6 enterpriseproject Portfolio Management

For more information

Legal Notices

For more information

Where to Get documentation

Complete documentation librariesfor P6 EPPM releases is available on the Oracle technology Network (OTN) at:

Http://www.oracle.com/technetwork/documentation/primavera-093289.html

From this location you can eitherview libraries online or download them to the local copies. We recommendviewing them from OTN to ensure all access the latest versions, includingcritical corrections and Enhan Cements.

The documentation assumes Astandard setup of the product, with full access rights to all features Andfunctions.

Help System Access

P6 EPPM is configured-accessits Help systems on OTN. However, downloadable versions of the "Help systems arealso available" on OTN if you need to download, deploy, and access a Local copy.

Documentation Accessibility

For information on Oracle ' scommitment to accessibility, visit the Oracle Accessibility Program website at http://www.or Acle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle support

Oracle customers this havepurchased support has access to electronic support through My Oracle support.for information, V Isit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup? Ctx=acc&id=trs If you are hearing impaired.

Where to Get Training

To access comprehensive trainingfor all Primavera products, go to:

Http://education.oracle.com

Oracle Learning Library

The Oracle Learning Library (OLL) provides online learning content covering Primavera products. Content includeswhitepapers, videos, tutorials, articles, demos, step-by-step instructions toaccomplish specific tasks, a ND self-paced interactive learning modules.

To access the Learning Library ' sprimavera content, go to:

Http://www.oracle.com/oll/primavera

Where to Get support

If you have a question aboutusing, Oracle products, or your network administrator cannot resolvewith information in The documentation or help, Clickhttp://support.oracle.com.this page provides the latest information on contacting Oracle Global Customersupport, knowledge articles, and the support renewals process. For moreinformation on working with support, visit https://support.oracle.com/epmos/faces/DocumentDisplay?id= 888813.2 to view support Tools & Tips.

Using Primavera ' s support Resource Centers

Primavera ' s support Resourcecenter provides links to important support and productinformation. Primavera ' s Product information Centers (PICs) organizedocuments found on My Oracle Support (MOS), providing quick access To Productand version specific information such as important knowledge documents, Releasevalue propositions, and Oracle Un Iversity training. PICs also offerdocumentation on Lifetime Management, from planning to installs, upgrades, andmaintenance.

Visit https://support.oracle.com/epmos/faces/DocumentDisplay?id=1486951.1 to access links to all of the currentpics.

PICs also provide access to:

• § Education VIAA List of available Primavera product trainings through Oracle University. Theoracle Advisor Webcast Program brings interactive expertise straight to thedesktop using Oracle Web conferencing Techno Logy. This capability brings youand Oracle experts together to access information on support services,products, technologies, Best practices, and more.

Creating a Service Request

P6 EPPM integrates with differentoracle applications; When you create a Service Request, being sure to open therequest with the proper support team. To ensure your reach the proper supportteam, enter the correct product information when you create the servicerequest. Each product have its own support line.

• Usethe §useone of the following support lines if you have a installation orconfiguration issues that does not relate to P6 EPPM.
• Oracle WebLogic Server
• Oracle Database Server
• BI Publisher
• Bpm
• Oracle Webcenter Content corecapabilities (formerly Universal content Management)
• Oracle Enterprise Manager
• Oracle Access Manager
• Oracle AutoVue

Keeping Your software up to Date

To ensure you has the latestversions of your products, being sure to download and install all available patchsets from http: Support.oracle.com.

Finding security-related Patches

To get the latest informationabout Critical Patch Updates, visit http://www.oracle.com/technetwork/topics/security/ Alerts-086861.html.

System Data Table Schema