What's New in the Oracle Primavera Cloud Data Service

Oracle Primavera Cloud Data Service endpoint support varies across releases of Oracle Primavera Cloud. The following enhancements have been made.

20.12

Support for the following tables was added:

• RSK_MATRIX
• RSK_CATEGORY
• RSK_PROJECT
• RSK_MITIGATION
• RSK_ACTIVITY
• RSK_ACTV_QT_OTHR_IMPCT
• RSK_MATRIX_TOLERANCE
• RSK_PROJECT_COST
• RSK_SCORE_TYPE
• RSK_SCORE_THRESHOLD
• RSK_PROJECT_IMPACT
• WS_RSK_SCORE_TYPE
• RSK_MATRIX_SCORE
• RSK_MATRIX_SCR_TYPE
• WS_RSK_MATRIX
• RSK_QT_COST_IMPACT
• RSK_QT_OTHER_IMPACT

19.7

Support for the following tables was added:

• CO_PROJECT_CP_UF
• SM_ACTIVITY_UF

19.6

Oracle Prime Projects Data Service has been renamed Oracle Primavera Cloud Data Service.

The URL to the data service has changed to:

https://<host>:<port>/data/rest/dataservice/<endpoint>
		

18.11

Support for the following endpoint was added:

• /assignmentSpread
  • This endpoint requires that the query body contain the tableName "SM_ASSIGNMENT" or "Assignment". Other tables are ignored. The query body format is the same as the /runquery endpoint. The pageSize max value is 40.

18.7

Support for data in the Field app, Schedule app, Strategy app, as well as Portfolio data has been added.

Field Tables

• Security
  • Contact_Projects
  • Contacts
• Lots\Areas
  • Lots
  • Issues
• Issues
  • projects
  • note_status
  • note_category
  • disciplines
  • vendors
  • specialty
  • template
  • standard_issues
  • inspecting_items
  • catalog_items
  • enterprise_structure_item
  • inspections
• Inspections
  • inspection_status
• Cx Steps
  • system_users

Schedule Tables

• SM_ASSIGNMENT_FO
• SM_ASSIGNMENT_FC
• SM_ASSIGNMENT_FT
• SM_ASSIGNMENT_SDC
• SM_ASSIGNMENT_SDR
• SM_Activity_FT
• SM_Activity_FC
• SM_Activity_FO
• SM_Activity_Fav
• SM_SCHEDULE_SCENARIO
• SM_ASSIGNMENT_FAV
• SM_ACTIVITY_SETTING
• CO_LOCATION
• SM_RELATIONSHIP
• SM_ACTIVITY_STEP
• CO_PROJECT_BASELINE

Portfolio Tables

• CP_CAP_PLAN_PROJ
• CP_CAP_PLAN_PROJ_COST
• CP_CAPITAL_PLAN_TARGET-1
• CP_CAPITAL_PLAN_COST
• CP_CAPITAL_PLAN_PROJ_COST
• CP_KPI
• CP_SNAPSHOT
• CP_PROJ_DEPEND
• CP_PORTFOLIO_PROJ
• CP_PROJ_SNAPSHOT
• SYS_SNAPSHOT
• CP_PORTFOLIO
• CP_PORT_MEMBER
• CP_KPI_THRESHOLD
• CP_ANALYSIS_VIEW
• CP_ANALYSIS_VIEW_PLAN
• CP_OPTMIZATION
• CP_OPT_CONSTRAINT
• CP_OPT_CONSTRAINT_DATA
• CP_SCENARIO_PROJ
• CP_SCENARIO
• CP_PROJ_PHASE_COST
• CP_PROJ_FUND
• CP_PROJ_FUND_COST
• CP_OPT_CONSTRAINT_DATA
• CP_OPT_CONSTRAINT
• CP_PROJ_FUND_PHASE
• CP_PROJ_FUND_PHASE_COST

18.6

No updates.

18.5

The Data Service was introduced in 18.5 supporting data from the Tasks app.