primavera data integrity when performing imports 4-30-13
DESCRIPTION
importTRANSCRIPT
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 1
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 2
FYI: New Portal with same DocID
Archive
740964.1
Schedule
740966.1
Generic Advisor
Webcast Note
740966.1
before
now
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 3
Data Integrity When Performing P6 Imports
Teleconference Access: US & Canada: 888-259-4812 Toll Number: 706-679-4880 Password: AdvisorPG Current Advisor Webcast Schedule and Archived Download – DOC#740966.1
Upcoming live webcasts and recent recordings:
April 25, 2013: PeopleSoft Payroll for North America and Benefits Release
9.2 – Empowering Employees with Employee Self Service
April 25, 2013: PeopleSoft: Your Upgrade: Preparing for Platform Changes
April 25, 2013: JDE E1: Change Assistant: Overview and Benefits
April 25, 2013: Database: Automation of patch conflict resolution and
deployment through EM 12c
April 25, 2013: EBS – MFG: ASCP-Rapid Planning Integration
April 30, 2013: FM: Diagnostics Enhancements in SOA Suite 11g PS6
(11.1.1.7)
April 30, 2013: Mutexes in Oracle Database
April 30, 2013: Demonstration of the benefits of PeopleSoft ePerformance
9.2
May 1, 2013: What’s New in PeopleSoft Recruiting Solutions 9.2
May 2, 2013: Campus Solutions: Financial Aid Regulagtory 2013-2014
Release 3 (9.0 Bundle #29)
May 2, 2013: PeopleTools: Search Framework Introduction and Setup
May 7, 2013: Upgrading to PeopleTools 8.53
May 7, 2013: Oracle Systems: Best Practices for Migrating to Oracle
Solaris 11
May 7, 2013: Proactive Capabilities in MOS for JD Edwards EnterpriseOne
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 4
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into
any contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decision. The
development, release, and timing of any features
or functionality described for Oracle’s products
remains at the sole discretion of Oracle.
Safe Harbor Statement
<Insert Picture Here>
Data Integrity When Performing P6 Imports
Ifeanyi Enigwe
Technical Support Engineer
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 6
AGENDA
Today’s presentation will cover the following:
Project level Import Actions
Activity level Import Actions
Activity Costs
Activity Relationships
Resource Assignments
Activity Codes
Reflection Projects
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 7
AGENDA (cont’d)
Today’s presentation we will cover the following:
P6 Pro vs. P6 Web import options
XML vs. XER Differences
XML Web Import
P6 R8.3 XML Import Improvements
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 8
Project Level Import Actions
Add Into Existing Project
Create New Project
Ignore this Project
Replace Existing Project
Update Existing Project
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 9
Project Level Import Actions (cont’d)
Add Into Existing Project
Purpose: Merge Project Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 10
Project Level Import Actions (cont’d)
Add Into Existing Project
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 11
Project Level Import Actions (cont’d)
Real World Example: Add Into Existing Project
Scheduler has a master schedule.
Outsources WBS nodes to different contractors
Merge these WBS nodes into the Master schedule.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 12
Project Level Import Actions (cont’d)
Create New Project
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 13
Project Level Import Actions (cont’d)
“Create New Project”
Project IDs remain unique
Project IDs can be changed
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 14
Project Level Import Actions (cont’d)
Real World Example
Preserve the existing project in the database.
Create a new project based on an existing
schedule.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 15
Project Level Import Actions (cont’d)
Ignore This Project
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 16
Project Level Import Actions (cont’d)
Replace Existing Project
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 17
Project Level Import Actions (cont’d)
Replace Existing Project: Real World Example:
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 18
Project Level Import Actions (cont’d)
Update Existing Project
Adds New Data if the Data does not currently
exist.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 19
Project Level Import Actions (cont’d)
Real World Example: Update Existing Project
Master Schedule the same activities as update
file
Update file has logic ties that aren’t in Master
Schedule
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 20
Activity Level Import Actions
Do Not Import
Insert New
Keep Existing
Update Existing
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 21
Activity Level Import Actions (cont’d)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 22
Activity Level Import Actions (cont’d)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 23
Activity Level Import Actions (cont’d)
Existing Data No Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 24
Activity Level Import Actions (cont’d)
“Do Not Import”
The record is not imported. No changes are
made to the existing record.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 25
Activity Level Import Actions (cont’d)
“Insert New”
A new record is added to the database.
With Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 26
Activity Level Import Actions (cont’d)
“Insert New”
A new record is added to the database.
Without Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 27
Activity Level Import Actions (cont’d)
“Keep Existing”
No Changes made to import file or database.
A new record is added to the database
With Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 28
Activity Level Import Actions (cont’d)
“Keep Existing”
A new record is added to the database
Without Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 29
Activity Level Import Actions (cont’d)
“Update Existing”
Data associated with the record is updated.
Record added to the database.
With Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 30
Activity Level Import Actions (cont’d)
“Update Existing”
Record added to the database.
Without Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 31
Activity Costs
Expense Costs
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 32
Activity Costs (cont’d)
Expense Costs
Expenses assigned to activities will import with
the project.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 33
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 34
Activity Costs (cont’d)
Resource Costs
Price / Unit
Decimals
Exchange Rate
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 35
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 36
Activity Costs (cont’d)
Resource Costs
Price/Unit
Calculate Cost from Units Tab
Rate Source
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 37
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 38
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 39
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 40
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 41
Activity Costs (cont’d)
Resource Costs
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 42
Resources Assignments
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 43
Resources Assignments (cont’d)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 44
Importing Activity Relationships
How Does P6 Handle the Import of External
Relationships?
Keep Existing
Update Existing
Insert New
Do Not Import
Delete
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 45
Importing Activity Relationships (cont’d)
How Does P6 Handle the Import of External
Relationships?
Keep Existing
Update Existing
Insert New
Do Not Import
Delete
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 46
Importing Activity Relationships (cont’d)
How Does P6 Handle the Import of External
Relationships?
Important Information Regarding the Import Process
Project ID, Activity ID, and Relationship Type.
“Edit Project Activity Relationships” privilege
“Add/Edit Project Activities Except Relationships” privilege
External project/external activity not in database.
The “Delete field”
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 47
Activity Codes
EPS Codes
Secure Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 48
Activity Codes (cont’d)
EPS Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 49
Activity Codes (cont’d)
EPS Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 50
Activity Codes (cont’d)
EPS Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 51
Activity Codes (cont’d)
EPS Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 52
Activity Codes (cont’d)
EPS Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 53
Activity Codes
Secure Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 54
Reflection Projects
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 55
Reflection Projects (cont’d)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 56
Web & Client Differences
P6 Client Import Options
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 57
Web & Client Differences (cont’d)
P6 Web Import Options
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 58
Web & Client Differences (cont’d)
P6 Web Import Options
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 59
XML & XER Differences
Wizard
Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 60
XML & XER Differences: Wizard
Import Based on Security
Resource/Role Imports
Individual Data Types
Multiple Projects
Methodology Manager
Import Options
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 61
XML & XER Differences: Wizard (cont’d)
Import Product and Documents
Import Exclusive Access
Published Schema vs. Proprietary Format
Matching options on all business objects
Limit Project Data
Calculated Fields & Physical Fields.
Performance(Speed)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 62
XML & XER Differences: Wizard (cont’d)
Files Versions
Global Data
Matching Data Level
Shifts
External Relationships
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 63
XML & XER Differences: Wizard (cont’d)
Modify Option for Code Assignments
Past Period Actuals (PPA)
Effect Dates
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 64
XML & XER Differences: Data
Business Rules/Errors
WP and Documents
Bucket Planning
Taskuser table
Admin Preferences
PPA values/Financial Periods
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 65
XML & XER Differences: Data (cont’d)
Duplicate Resource Assignments
Issue Codes
Secure codes
Calendar Data
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 66
XML & XER Differences: Data (cont’d)
EPS Codes
Codes Length
WBS RSRC category table
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 67
XML & XER Differences: Data (cont’d)
Resource Security
Honors Resource Security
Resource not in user’s Security node
Users with ‘View Privileges’
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 68
XML & XER Differences: Data (cont’d)
Issue History
Activity Owner
Responsible Manager (OBS)
Resource Dictionary/Assignments
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 69
P6 R8.3 XML Import Granularity
XML Import Improvements
Multi Project XML
Handling of Global Data
Codes
UDFs
Calendars
Resources
Import Templates
Log File
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 70
P6 R8.3 XML Import Granularity (cont’d)
XML Import Improvements - Codes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 71
P6 R8.3 XML Import Granularity (cont’d)
XML Import Improvements – User Defined Fields
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 72
P6 R8.3 XML Import Granularity (cont’d)
XML Import Improvements – Calendars
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 73
P6 R8.3 XML Import Granularity (cont’d)
XML Import Improvements – Resources
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 74
P6 R8.3 XML Import Granularity (cont’d)
XML Import Improvements – Log File
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 75
P6 R8.3 XML Import UN/CEFACT Support
Schedule formats
Export Only
Desktop Client and P6 Web
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 76
Conclusion
References
KM Budgeted Costs Are Not Imported Correctly When Importing An XER Into A Different Database [Article ID 897284.1]
KM Considerations For Importing Microsoft Project Files (MPP, MPX, XML) Into P6 And Contractor [ID 903268.1]
KM Unable to Import P3 Project Directly into P6 [ID 910992.1]
KM Differences Between XML and XER Import / Export in Project Management [ID 907653.1]
KM How To Import EPS Activity Code Assignments From An XER File [ID 901318.1]
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 77
Conclusion (cont’d)
Q & A Q: Is there any resume table for XML and XER differences?
A: See KM: Differences Between XML and XER Import / Export in
Project Management [ID 907653.1]
Q: Does XML support multiple project imports?
A: Yes
Q: If the user does not have the ability to add resources, does the
XML import utility gray out the resources selections; since the user
does not have the ability to import resources through security?
A: Yes
Q: Is Microsoft project 2010 supported by 8.3?
A: Yes, but only in XML format.
Q: If you setup a XML import template in EPPM is that template
visible in P6 professional?
A: Yes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 78
Are You Ready To Get Proactive?
Avoid the unexpected
Don’t leave value on the table
Lower overall organizational costs through preventative
maintenance
Reduce risks and maximize uptime
Achieve resolution faster
Streamline and simplify your daily operations
Get even more through connection
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 79
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 80
THANK YOU