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.

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.

 

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.

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.

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.

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.

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.

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