Wednesday 18 May 2022

Export Oracle Primavera P6 EPPM Project Data to P6 XML using Excel

If you have an option of exporting project out of Oracle P6 EPPM application using excel, will you use it?

Introducing new excel utility that will let you do just that. It will let you select one or multiple projects and export it to the directory of your choice on your desktop. You can optionally export baselines along with the project. There is no restriction on number of projects that you select to export. You can export all projects in your Oracle Primavera P6 EPPM application using this excel utility.


The excel utility uses P6 web services to export projects. As a result, exporting the project using this excel utility will not impact the performance of P6 EPPM application or P6 Professional.

Projects are downloaded in XML format. Each project is downloaded to the export folder specified. This will avoid navigation in the P6 EPPM application to multiple screen to select the project and then download project file.

To use the excel utility 

  • Enter P6 application login credential. You are required to have access to P6 web services. 
  • Select the folder where P6 Project XML files will be saved. 
  • Click Read Project button to fetch P6 projects based on user access to the Project worksheet
  • Mark the projects in the column Export Project as "Y" that you want to export.
  • Click on Export Projects to export selected projects.
  • Verify the P6 Project XML file in the Export Folder.


Download the file from here. Drop me a message, if you are unable to download evaluation copy.


Monday 21 June 2021

Going Serverless with Oracle Primavera P6 EPPM – Part 2

In the previous article we touched upon utilizing AWS serverless architecture with Oracle Primavera P6 EPPM cloud. You can refer the article here.

In this article we will see how to utilize AWS serverless architecture to cut down on processing time for large volume of transactions, when importing them to Oracle Primavera P6 EPPM cloud using P6 web services.

One of the customers had the requirement of importing, roughly 50,000 financial transactions from their ERP application to Oracle Primavera P6 EPPM cloud on a weekly basis. Additionally, they wanted to perform validation based on pre-defined set of rules, for each transaction, during import and capture the information in UDF fields. This resulted in importing transaction individually instead of in a batch of 1000, allowed by P6 web services.

This had significant impact on overall time required to process 50,000 transactions. With average of 1 second per transaction, it required around 14 hours to import 50,000 transactions in Oracle Primavera P6 EPPM cloud.

At 1 second per transaction,

50,000 transaction = 50,000 seconds or

(50,000/60) = 833.33 minutes or

(50,000/60/60) = 13.89 hours

 

This was a huge problem.

 

Serverless architecture


With the use of AWS serverless architecture model and carefully choosing services to fit the requirement, the processing time was reduced considerably. All of this, without worrying about additional cost of infrastructure or fluctuation in volume of transaction in future.

The transactions from ERP application were uploaded to Amazon DynamoDB.

AWS Lambda was configured to trigger when new data was inserted in DynamoDB. It was configured to trigger up to 10 Lambda function concurrently.  With 10 instances of lambda function processing the transactions concurrently at any given time, the overall time came down drastically from 14 hours to under 2 hours.

Previously, (50,000/60/60) = 13.89 hours

Now, (50,000/60/60/10) = 1.39 hours

Note: The distribution of data among instance of Lambda function is not same so the time will almost always be little higher than the above (theoretical) calculation.

The above approach is just one way to reduce overall processing time. A carefully designed solution with serverless approach can go a long way. Customers with on-premises integration solutions, who are constrained due to existing hardware configuration or otherwise, can also benefit by moving to serverless architecture.

If you have a similar requirement and want to discuss how serverless architecture can be utilized effectively, then leave a message or drop an email.


Tuesday 19 January 2021

Going Serverless with Oracle Primavera P6 EPPM

 

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 runtimes. AWS Lambda in conjunction with other services like Amazon S3, Amazon DynamoDB, Amazon API Gateway, can be used to run specific integration code.


AWS Lambda - P6 EPPM


Oracle Primavera P6 EPPM provides web services. These web services can be consumed in integration solution to meet business requirement. 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 leave a message or drop an email.

Thursday 1 October 2020

Oracle E-Business Suite and Oracle Unifier Integration Framework

One of our clients is a long-time on-premise Oracle EBS customer.

They implemented Oracle Unifier cloud few months back. They were looking for an effective solution to load actuals transactions from on-premise Oracle EBS to Oracle Unifier cloud. They had created business process in Oracle Unifier for actuals transaction and enabled for integration.

They had one simple requirement. They need a scalable solution to load eligible actuals transaction from on-premise Oracle EBS to Oracle Unifier cloud daily using rest API.

Digging deeper we could identify few more things to be taken care

  • Ability to introduce new attribute in the integration equilibrium which may require updating all transactions in Unifier with the data from EBS.
  • Avoid duplicate transactions.
  • Capable to identifying and create/update transactions and in rare scenario delete transactions from Unifier to keep it always in sync with Oracle EBS

After reviewing various options with customer, they agreed on the framework shown below

  1. Utilize Oracle EBS concurrent request to populate data daily in a staging table.
  2. Pull data from Oracle Unifier cloud in staging table.
  3. Compare the data in two staging tables to identify new and modified data.
  4. Call Oracle Unifier Rest API to process the data.

1.  

 

Advantage of this framework

  • Scalable  It can easily process a volume of 100,000 transactions daily.
  • Automated – It can identify new vs modified data and discard data that do not require change.
  • Extensible – New attributes introduced for integration, can be easily populated for all existing transactions in Oracle Unifier Cloud.


Wednesday 12 February 2020

Primavera Data Service (PDS) to Access Cloud Database - P6 EPPM and Unifier


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:
ACCOUNT
FORMTMPL
QUERYLIB
TASKDOC
ACTIVITYCODEHIERARCHY
FUNDSRC
RCATTYPE
TASKDOCX
ACTIVITYCODETYPESECURITY
GATEWAYDEPLOYMENT
RCATVAL
TASKFDBK
ACTIVITYSPREAD
GATEWAYPROVIDER
RCATVALX
TASKFIN
ACTVCODE
GATEWAYSYNCACTION
REFRDEL
TASKFINX
ACTVCODEX
GCHANGE
REITTYPE
TASKMEMO
ACTVTYPE
GLOBALSECURITY
RELEASE
TASKMEMOX
ADDTASKPROC
GREPLACE
RELITEMS
TASKNOTE
ADDTASKPROCX
GTT_PKLIST
RELITER
TASKPRED
ADDTRSRC
HQDATA
RELPROJ
TASKPREDX
ADMIN_CONFIG
HQUERY
REPORTDATE
TASKPROC
ALERT
IMAGEDATA
REPORTTIME
TASKPROCX
ALERTPARAM
ISSUHIST
RESOURCEASSIGNMENTCBSSPREAD
TASKRISK
ANNOUNCEMENT
ITERATION
RESOURCEASSIGNMENTSPREAD
TASKRISKX
ANNOUNCEMENT_USER
ITERTASK
RESOURCECODEHIERARCHY
TASKRSRC
ARBITER_COUNTER
ITERTEAM
RESOURCEHIERARCHY
TASKRSRCX
ATTR_MASTER
JOBLOG
RESOURCELIMIT
TASKSUM
AUTOVUE_ATTR
JOBPROJ_LKP
RFOLIO
TASKSUMFIN
BASETYPE
JOBRPT
RFOLIOX
TASKUSER
BGPLOG
JOBSET
RISK
TASKWKSP
BRE_REGISTRY
JOBSVC
RISKCTRL
TASKX
BUDGCHNG
LEANTASK
RISKIMPACT
TEMPKEYS
BUDGCHNGX
LOCATION
RISKMIT
THRSPARM
CALENDAR
MDRT_12D3F$
RISKMITIMP
TIMESHT
CALENDARX
MDRT_12D46$
RISKMITX
TIMESHTX
CBS
MEMOTYPE
RISKMTXSCR
TMPLCATG
CHECKPROJINTEG
MTXSCRTYP
RISKRSPPLN
TPROJMAP
CHGHEAD
NEXTKEY
RISKRSPPLNX
TRAKVIEW
CHGTASK
NONWORK
RISKSCRMTX
TRSRCFIN
CHGTASKACTV
NOTE
RISKSCRTHR
TRSRCFINX
CHGTASKACTVX
OBS
RISKSCRTYP
TRSRCSUM
CHGTASKMEMO
OBSPROJ
RISKTYPE
TRSRCSUMFN
CHGTASKMEMOX
P6_CERTS
RISKX
TSAUDIT
CHGTASKPROC
P6_KEYS
RLFOLIO
TSDATES
CHGTASKPROCX
PAUDIT
RLFOLIOX
TSDELEGATE
CHGTASKX
PAUDITX
ROLELIMIT
UACCESS
CHGTRSRC
PCATTYPE
ROLERATE
UDFCODE
CHGTRSRCX
PCATUSER
ROLERATEX
UDFCODEX
CHGUDFVALUE
PCATUSERX
ROLES
UDFTYPE
CHGUDFVALUEX
PCATVAL
ROLFOLIO
UDFVALUE
COSTACCOUNTHIERARCHY
PCATVALX
RPT
UDFVALUEX
COSTSECURITY
PC_KEY_XREF
RPTBATCH
UEVNTREG
COSTTYPE
PC_PROCESS_STAT
RPTGROUP
UMEASURE
CURRTYPE
PFOLIO
RPTLIST
UPKLIST
CURRTYPEX
PFOLIOUSER
RSRC
USERCOL
DASHBOARD
PFOLIOX
RSRCANDASH
USERDATA
DASHUSER
PHASE
RSRCANVIEW
USERENG
DELTASKPROC
PKXREF
RSRCCURV
USEROBS
DELTASKPROCX
PLPROJREF
RSRCCURVX
USEROBSX
DISCUSSION
POBS
RSRCHOUR
USEROPEN
DISCUSSION_READ
PREFER
RSRCHOURX
USERS
DLTACCT
PRMQUEUE
RSRCLOC
USERSET
DLTACTV
PROCGROUP
RSRCOVERALLOC
USERSX
DLTOBS
PROCITEM
RSRCPROP
USERWKSP
DLTROLE
PROFILE
RSRCRATE
USER_ACCEPTANCE_CONSENT
DLTRSRC
PROFPRIV
RSRCRATEX
USESSAUD
DLTRSRL
PROFPRIVX
RSRCRCAT
USESSION
DLTUSER
PROJCOST
RSRCRCATX
USROPNVAL
DM_ATTR
PROJCOSTX
RSRCROLE
VIEWPREF
DOC
PROJDEPLMENT
RSRCROLEASGNMENTSPREAD
VIEWPROP
DOCCATG
PROJECT
RSRCROLEX
VWPREFDASH
DOCREVIEW
PROJECTCODEHIERARCHY
RSRCSEC
VWPREFDATA
DOCREVIEWTASK
PROJECTCOSTCBSSPREAD
RSRCSECX
VWPREFUSER
DOCSTAT
PROJECTSECURITY
RSRCX
WBRSCAT
DOCUMENT
PROJECTSPREAD
RSRFOLIO
WBSBUDG
DOCUMENTX
PROJECTX
SAFETYDATE
WBSBUDGX
DOCUMENT_MAPPER
PROJECT_ETL_LIST
SCENARIO
WBSHIERARCHY
DOC_FOLDER
PROJEST
SCENPROJ
WBSMEMO
DOC_RECENT
PROJFUND
SCENROLE
WBSMEMOX
DOC_VERSION
PROJFUNDX
SCENUSER
WBSRSRC
DR$DOCVER_DOCDATA_QSI$I
PROJISSU
SETTINGS
WBSRSRCX
DR$DOCVER_DOCDATA_QSI$K
PROJISSUX
SHIFT
WBSRSRC_QTY
DR$DOCVER_DOCDATA_QSI$N
PROJPCAT
SHIFTPER
WBSRSRC_QTYX
DR$DOCVER_DOCDATA_QSI$R
PROJPCATX
SNAPGROUP
WBSSPREAD
DR$DOCVER_DOCDATA_QSI$U
PROJPROP
SNAPPROJ
WBSSTEP
EPSHIERARCHY
PROJRISK
SNAPSHOT
WBSSTEPX
EPSSPREAD
PROJSET
SPIDMAP
WKFLTMPL
EXPPROJ
PROJSHAR
SUMPROJCOST
WKFLUSER
EXTAPP
PROJTHRS
SUMTASK
WORKFLOW
FACTOR
PROJWBS
SUMTASKSPREAD
WORKSPACE
FACTVAL
PROJWBSX
SUMTRSRC
WRK_LOG_RESULTS
FILTPROP
PROJWSRPT
TASK
SYNC$SYS_NUMLIST
FINDATES
PRPFOLIO
TASKACTV
SYNC$SYS_STRLIST
FORMCATG
PUBUSER
TASKACTVX

FORMPROJ
PXJOBRUN
TASKCBSX


List of views available for P6 EPPM with configuration ds_p6adminuser:
OPENING_ACCOUNT
PROJRSRC_VIEW
WBSRSRC_ASSGN_BY_ROLE_BY_QTR
OPENING_ACTVCODE
PROJSHAR_BL_VIEW
WBSRSRC_ASSGN_BY_ROLE_BY_WEEK
OPENING_OBS
RESOURCEUSAGE
WBSRSRC_ASSGN_BY_ROLE_BY_YEAR
OPENING_ROLE
WBSRSRC_ASSGN_BY_PROJROLE_MON
WBSRSRC_ASSGN_BY_RSRC_BY_MONTH
OPENING_RSRC
WBSRSRC_ASSGN_BY_PROJROLE_QTR
WBSRSRC_ASSGN_BY_RSRC_BY_QTR
OPENING_RSRCROLE
WBSRSRC_ASSGN_BY_PROJROLE_WEEK
WBSRSRC_ASSGN_BY_RSRC_BY_WEEK
OPENING_USERS
WBSRSRC_ASSGN_BY_PROJROLE_YEAR
WBSRSRC_ASSGN_BY_RSRC_BY_YEAR
PFLOAD_IP_UACCESS_VIEW
WBSRSRC_ASSGN_BY_PROJRSRC_MON
WBSRSRC_ASSGN_SUMMARY_BY_MON
PFLOAD_IP_VIEW
WBSRSRC_ASSGN_BY_PROJRSRC_QTR
WBSRSRC_ASSGN_SUMMARY_BY_QTR
PFLOAD_UACCESS_VIEW
WBSRSRC_ASSGN_BY_PROJRSRC_WEEK
WBSRSRC_ASSGN_SUMMARY_BY_WEEK
PFLOAD_VIEW
WBSRSRC_ASSGN_BY_PROJRSRC_YEAR
WBSRSRC_ASSGN_SUMMARY_BY_YEAR
PROJROLE_PS_VIEW
WBSRSRC_ASSGN_BY_PROJ_BY_MONTH
WBSRSRC_ASSN_BY_PROJROLE_BY_FP
PROJROLE_VIEW
WBSRSRC_ASSGN_BY_PROJ_BY_QTR
WBSRSRC_ASSN_BY_PROJRSRC_BY_FP
PROJRSRCROLE_PS_VIEW
WBSRSRC_ASSGN_BY_PROJ_BY_WEEK
WBSRSRC_ASSN_BY_PROJ_BY_FP
PROJRSRCROLE_VIEW
WBSRSRC_ASSGN_BY_PROJ_BY_YEAR
WBSRSRC_ASSN_SUMMARY_BY_FP
PROJRSRC_PS_VIEW
WBSRSRC_ASSGN_BY_ROLE_BY_MONTH


List of views available for P6 EPPM with configuration ds_p6reportuser:

ACTIVITY
DOCUMENTSTATUSCODE
PROJECTRESOURCE
RISKIMPACT_U
ACTIVITYCODE
DOCUMENTSTATUSCODE_FULL
PROJECTRESOURCEQUANTITY
RISKMATRIXSCORE
ACTIVITYCODEASSIGNMENT
DOCUMENTSTATUSCODE_U
PROJECTRESOURCEQUANTITY_FULL
RISKMATRIXSCORETYPE
ACTIVITYCODEASSIGNMENT_FULL
DOCUMENT_FULL
PROJECTRESOURCEQUANTITY_U
RISKMATRIXSCORETYPE_FULL
ACTIVITYCODEASSIGNMENT_GE
DOCUMENT_U
PROJECTRESOURCE_FULL
RISKMATRIXSCORETYPE_U
ACTIVITYCODEASSIGNMENT_RT
EPS
PROJECTRESOURCE_U
RISKMATRIXSCORE_FULL
ACTIVITYCODEASSIGNMENT_S
EPSBUDGETCHANGELOG
PROJECTSECURITY
RISKMATRIXSCORE_U
ACTIVITYCODEASSIGNMENT_U
EPSBUDGETCHANGELOG_FULL
PROJECTSECURITY_GE
RISKRESPONSEACTION
ACTIVITYCODEHIERARCHY
EPSBUDGETCHANGELOG_U
PROJECTSECURITY_RT
RISKRESPONSEACTIONIMPACT
ACTIVITYCODEHIERARCHY_FULL
EPSFUNDING
PROJECTSPENDINGPLAN
RISKRESPONSEACTIONIMPACT_FULL
ACTIVITYCODEHIERARCHY_S
EPSFUNDING_FULL
PROJECTSPENDINGPLAN_FULL
RISKRESPONSEACTIONIMPACT_U
ACTIVITYCODEHIERARCHY_U
EPSFUNDING_U
PROJECTSPENDINGPLAN_U
RISKRESPONSEACTION_FULL
ACTIVITYCODETYPE
EPSHIERARCHY
PROJECTSPREAD
RISKRESPONSEACTION_U
ACTIVITYCODETYPESECURITY
EPSHIERARCHY_FULL
PROJECTSPREAD_FULL
RISKRESPONSEPLAN
ACTIVITYCODETYPE_FULL
EPSHIERARCHY_U
PROJECTSPREAD_U
RISKRESPONSEPLAN_FULL
ACTIVITYCODETYPE_GE
EPSNOTE
PROJECT_FULL
RISKRESPONSEPLAN_U
ACTIVITYCODETYPE_RT
EPSNOTE_FULL
PROJECT_GE
RISKSCOREMATRIX
ACTIVITYCODETYPE_S
EPSNOTE_U
PROJECT_RT
RISKSCOREMATRIX_FULL
ACTIVITYCODETYPE_U
EPSSPENDINGPLAN
PROJECT_SC
RISKSCOREMATRIX_U
ACTIVITYCODEUPDATE
EPSSPENDINGPLAN_FULL
PROJECT_U
RISKSCORETYPE
ACTIVITYCODEUPDATE_FULL
EPSSPENDINGPLAN_U
PROJECT_UDFVALUE_U
RISKSCORETYPE_FULL
ACTIVITYCODEUPDATE_U
EPSSPREAD
PXSERVICES
RISKSCORETYPE_U
ACTIVITYCODE_FULL
EPSSPREAD_FULL
PXSETTINGS
RISKTHRESHOLDLEVEL
ACTIVITYCODE_GE
EPSSPREAD_U
REFRDELETE
RISKTHRESHOLDLEVEL_FULL
ACTIVITYCODE_RT
EPS_FULL
REFRDELETE_GE
RISKTHRESHOLDLEVEL_U
ACTIVITYCODE_S
EPS_SC
REFRDELETE_RT
RISKTYPE
ACTIVITYCODE_U
EPS_U
REFRDELETE_SC
RISKTYPE_FULL
ACTIVITYCOMMENT
ETLFILTER
RELATIONSHIP
RISKTYPE_U
ACTIVITYCOMMENT_FULL
EXPENSECATEGORY
RELATIONSHIP_FULL
RISK_FULL
ACTIVITYCOMMENT_U
EXPENSECATEGORY_FULL
RELATIONSHIP_U
RISK_GE
ACTIVITYEXPENSE
EXPENSECATEGORY_U
RELEASE
RISK_RT
ACTIVITYEXPENSE_FULL
FINANCIALPERIOD
RELEASEITERATION
RISK_U
ACTIVITYEXPENSE_GE
FINANCIALPERIOD_FULL
RELEASEITERATION_FULL
ROLE
ACTIVITYEXPENSE_RT
FINANCIALPERIOD_U
RELEASEITERATION_U
ROLEAVAILABILITY
ACTIVITYEXPENSE_U
FUNDINGSOURCE
RELEASEPROJECT
ROLELIMIT
ACTIVITYNOTE
FUNDINGSOURCE_FULL
RELEASEPROJECT_FULL
ROLERATE
ACTIVITYNOTE_FULL
FUNDINGSOURCE_U
RELEASEPROJECT_U
ROLERATE_FULL
ACTIVITYNOTE_GE
GLOBALPROFILE
RELEASE_FULL
ROLERATE_U
ACTIVITYNOTE_RT
GLOBALPROFILE_FULL
RELEASE_U
ROLEROLETEAM
ACTIVITYNOTE_U
GLOBALPROFILE_U
REPORTDATE
ROLEROLETEAM_FULL
ACTIVITYPERIODACTUAL
GLOBALSECURITY
REPORTDATE_FULL
ROLEROLETEAM_U
ACTIVITYPERIODACTUAL_FULL
GLOBAL_UDFVALUE_U
REPORTDATE_U
ROLETEAM
ACTIVITYPERIODACTUAL_GE
ISSUEHISTORY
REPORTTIME
ROLETEAM_FULL
ACTIVITYPERIODACTUAL_RT
ISSUEHISTORY_FULL
REPORTTIME_FULL
ROLETEAM_U
ACTIVITYPERIODACTUAL_SC
ISSUEHISTORY_U
REPORTTIME_U
ROLE_FULL
ACTIVITYPERIODACTUAL_U
ITERATION
RESASSIGNMENTPERIODACTUAL
ROLE_SC
ACTIVITYRISK
ITERATIONACTIVITY
RESASSIGNMENTPERIODACTUAL_FULL
ROLE_U
ACTIVITYRISK_FULL
ITERATIONACTIVITY_FULL
RESASSIGNMENTPERIODACTUAL_GE
SHIFT
ACTIVITYRISK_GE
ITERATIONACTIVITY_U
RESASSIGNMENTPERIODACTUAL_RT
SHIFTPERIOD
ACTIVITYRISK_RT
ITERATIONTEAM
RESASSIGNMENTPERIODACTUAL_SC
SHIFTPERIOD_FULL
ACTIVITYRISK_U
ITERATIONTEAM_FULL
RESASSIGNMENTPERIODACTUAL_U
SHIFTPERIOD_U
ACTIVITYSPREAD
ITERATIONTEAM_U
RESOURCEACCESS
SHIFT_FULL
ACTIVITYSPREAD_FULL
ITERATION_FULL
RESOURCEACCESS_FULL
SHIFT_U
ACTIVITYSPREAD_GE
ITERATION_U
RESOURCEACCESS_U
SNAPSHOT
ACTIVITYSPREAD_RT
LOCATION
RESOURCEASSIGNMENT
SNAPSHOTGROUP
ACTIVITYSPREAD_SC
LOCATION_FULL
RESOURCEASSIGNMENTSPREAD
SNAPSHOTGROUP_FULL
ACTIVITYSPREAD_U
LOCATION_U
RESOURCEASSIGNMENTSPREAD_FULL
SNAPSHOTGROUP_U
ACTIVITYSTEP
NEVER_LOGGED_USER_DTL
RESOURCEASSIGNMENTSPREAD_GE
SNAPSHOTPROJECT
ACTIVITYSTEPCREATE
NOTEBOOKTOPIC
RESOURCEASSIGNMENTSPREAD_RT
SNAPSHOTPROJECT_FULL
ACTIVITYSTEPCREATE_FULL
NOTEBOOKTOPIC_FULL
RESOURCEASSIGNMENTSPREAD_SC
SNAPSHOTPROJECT_U
ACTIVITYSTEPCREATE_U
NOTEBOOKTOPIC_U
RESOURCEASSIGNMENTSPREAD_U
SNAPSHOT_FULL
ACTIVITYSTEPDEL
OBS
RESOURCEASSIGNMENTUPDATE
SNAPSHOT_U
ACTIVITYSTEPDEL_FULL
OBS_FULL
RESOURCEASSIGNMENTUPDATE_FULL
TIMESHEET
ACTIVITYSTEPDEL_U
OBS_SC
RESOURCEASSIGNMENTUPDATE_U
TIMESHEETPERIOD
ACTIVITYSTEPUPDATE
OBS_U
RESOURCEASSIGNMENT_FULL
TIMESHEETPERIOD_FULL
ACTIVITYSTEPUPDATE_FULL
OVERHEADCODE
RESOURCEASSIGNMENT_GE
TIMESHEETPERIOD_U
ACTIVITYSTEPUPDATE_U
OVERHEADCODE_FULL
RESOURCEASSIGNMENT_RT
TIMESHEET_FULL
ACTIVITYSTEP_FULL
OVERHEADCODE_U
RESOURCEASSIGNMENT_SC
TIMESHEET_U
ACTIVITYSTEP_GE
PRMAUDIT_FULL
RESOURCEASSIGNMENT_U
UDFCODE
ACTIVITYSTEP_RT
PRMAUDIT_PROJ
RESOURCECODE
UDFCODE_FULL
ACTIVITYSTEP_U
PROJECT
RESOURCECODEASSIGNMENT
UDFCODE_S
ACTIVITYUPDATE
PROJECTBUDGETCHANGELOG
RESOURCECODEASSIGNMENT_FULL
UDFCODE_U
ACTIVITYUPDATE_FULL
PROJECTBUDGETCHANGELOG_FULL
RESOURCECODEASSIGNMENT_S
UDFTYPE
ACTIVITYUPDATE_U
PROJECTBUDGETCHANGELOG_U
RESOURCECODEASSIGNMENT_U
UDFTYPE_FULL
ACTIVITY_FULL
PROJECTCODE
RESOURCECODEHIERARCHY
UDFTYPE_S
ACTIVITY_GE
PROJECTCODEASSIGNMENT
RESOURCECODEHIERARCHY_FULL
UDFTYPE_U
ACTIVITY_RT
PROJECTCODEASSIGNMENT_FULL
RESOURCECODEHIERARCHY_S
UDFVALUE
ACTIVITY_SC
PROJECTCODEASSIGNMENT_GE
RESOURCECODEHIERARCHY_U
UDFVALUE_FULL
ACTIVITY_U
PROJECTCODEASSIGNMENT_RT
RESOURCECODETYPE
UNITOFMEASURE
AUDIT_PROJINFO
PROJECTCODEASSIGNMENT_S
RESOURCECODETYPE_FULL
UNITOFMEASURE_FULL
AUDIT_SETTINGS
PROJECTCODEASSIGNMENT_U
RESOURCECODETYPE_S
UNITOFMEASURE_U
AUDIT_USERS
PROJECTCODEHIERARCHY
RESOURCECODETYPE_U
USERDEFINEDVALUEUPDATE
BASELINE
PROJECTCODEHIERARCHY_FULL
RESOURCECODE_FULL
USERDEFINEDVALUEUPDATE_FULL
BASELINETYPE
PROJECTCODEHIERARCHY_S
RESOURCECODE_S
USERDEFINEDVALUEUPDATE_U
BASELINETYPE_FULL
PROJECTCODEHIERARCHY_U
RESOURCECODE_U
USERMODULEACCESS
BASELINETYPE_U
PROJECTCODETYPE
RESOURCECURVE
USERMODULEACCESS_FULL
BASELINE_U
PROJECTCODETYPE_FULL
RESOURCECURVE_FULL
USERMODULEACCESS_U
BLACTIVITY
PROJECTCODETYPE_S
RESOURCECURVE_U
USEROBS
BLACTIVITY_U
PROJECTCODETYPE_U
RESOURCEHIERARCHY
USEROBS_FULL
BLPROJECT
PROJECTCODEUSER
RESOURCEHIERARCHY_FULL
USEROBS_U
BLPROJECT_U
PROJECTCODEUSER_FULL
RESOURCEHIERARCHY_U
USERPROFILEPRIVILEGE
BLWBS
PROJECTCODEUSER_U
RESOURCEHOUR
USERPROFILEPRIVILEGE_FULL
BLWBS_U
PROJECTCODE_FULL
RESOURCEHOUR_FULL
USERPROFILEPRIVILEGE_U
CALENDAR
PROJECTCODE_S
RESOURCEHOUR_U
USERS
CALENDAR_FULL
PROJECTCODE_U
RESOURCELIMIT
USERS_FULL
CALENDAR_GE
PROJECTDOCUMENT
RESOURCELIMIT_FULL
USERS_U
CALENDAR_RT
PROJECTDOCUMENT_FULL
RESOURCELIMIT_U
USER_LOGIN_DTLS
CALENDAR_U
PROJECTDOCUMENT_U
RESOURCELOCATION
USER_NOT_LOGGED_DTL
CBS
PROJECTETLLIST
RESOURCELOCATION_FULL
WBS
CBS_GE
PROJECTETLLIST_FULL
RESOURCELOCATION_U
WBSCATEGORY
CBS_RT
PROJECTETLLIST_U
RESOURCERATE
WBSCATEGORY_FULL
CHANGESET
PROJECTFUNDING
RESOURCERATE_FULL
WBSCATEGORY_U
CHANGESET_FULL
PROJECTFUNDING_FULL
RESOURCERATE_U
WBSHIERARCHY
CHANGESET_U
PROJECTFUNDING_U
RESOURCERESOURCETEAM
WBSHIERARCHY_FULL
COSTACCOUNT
PROJECTISSUE
RESOURCERESOURCETEAM_FULL
WBSHIERARCHY_GE
COSTACCOUNTHIERARCHY
PROJECTISSUE_FULL
RESOURCERESOURCETEAM_U
WBSHIERARCHY_RT
COSTACCOUNTHIERARCHY_FULL
PROJECTISSUE_U
RESOURCEROLE
WBSHIERARCHY_U
COSTACCOUNTHIERARCHY_U
PROJECTNOTE
RESOURCEROLE_FULL
WBSMILESTONE
COSTACCOUNT_FULL
PROJECTNOTE_FULL
RESOURCEROLE_U
WBSMILESTONE_FULL
COSTACCOUNT_SC
PROJECTNOTE_GE
RESOURCES
WBSMILESTONE_U
COSTACCOUNT_U
PROJECTNOTE_RT
RESOURCESECURITY
WBSSPREAD
COSTSECURITY
PROJECTNOTE_U
RESOURCES_FULL
WBSSPREAD_FULL
COSTSECURITY_FULL
PROJECTPORTFOLIO
RESOURCES_SC
WBSSPREAD_U
COSTSECURITY_U
PROJECTPORTFOLIO_FULL
RESOURCES_U
WBS_FULL
CURRENCY
PROJECTPORTFOLIO_U
RESOURCETEAM
WBS_GE
CURRENCY_FULL
PROJECTPROFILE
RESOURCETEAM_FULL
WBS_RT
CURRENCY_U
PROJECTPROFILE_FULL
RESOURCETEAM_U
WBS_SC
DOCUMENT
PROJECTPROFILE_U
RESOURCE_UDFVALUE_U
WBS_U
DOCUMENTCATEGORY
PROJECTPROJECTPORTFOLIO
RISK

DOCUMENTCATEGORY_FULL
PROJECTPROJECTPORTFOLIO_FULL
RISKIMPACT

DOCUMENTCATEGORY_U
PROJECTPROJECTPORTFOLIO_U
RISKIMPACT_FULL


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, leave a comment or drop a message.

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

About Me

My photo
Over 24 years of experience in providing integration software solutions to various industries.Handled numerous projects implementing Primavera P6 EPPM, P6 Analytics, P6 BI Publisher Reports, Oracle BPM, SOA Suite, Primavera Gateway, Oracle Unifier, Instantis EnterpriseTrack, Oracle E-Business Suite.

Developed integration solution around these products and with ERP and legacy systems.

Designed excel utilities to quickly load and maintain data in excel for these products.

Connect with me on LinkedIn

Popular Posts

Contact Form

Name

Email *

Message *