1. Tables and Views for Project Management
  2. Project Portfolio Management Tables and Views

Project Portfolio Management Tables and Views

This guide contains information about tables within Oracle Project Portfolio Management Cloud and their columns, primary keys, and indexes. The guide also contains information about views within Oracle Project Portfolio Management Cloud along with the columns and queries associated with each view.

  • Tables are the basic unit of data storage in Oracle Project Portfolio Management Cloud, where data is stored in rows and columns. For example, the PJC_COST_DIST_LINES_ALL table stores the cost distributions for expenditure items, including attributes such as expenditure item ID, line number, and quantity.

  • Views are logical representations of a single or combination of tables. They use stored queries that derive data from the tables on which the views are based. The PJC_PRJ_REQ_DIST_V view displays attributes such as requisition number, item description, and vendor name.