Oracle Cloud Project Portfolio Management (PPM) is a comprehensive solution for project management, resource management, and project financial management. It uses a database to store various types of data, and within that database, multiple tables are involved. These tables help manage everything from project details and resource allocation to financial data and more.

Here is a list of some common tables you might encounter when dealing with Oracle Cloud PPM:

Project Information

1. PA_PROJECTS_ALL – Stores information about projects.
2. PA_TASKS – Contains details about tasks within projects.

Resource Management

1. PA_RESOURCE_ASSIGNMENTS – Holds resource assignment data.
2. PA_RESOURCE_POOLS – Contains resource pools.

Financials

1. PA_EXPENDITURE_ITEMS – Information on project-related expenditures.
2. PA_COST_DISTRIBUTION_LINES – Details about the distribution of costs across various accounts.

Time and Labor

1. HXT_TIME_CARDS – Timecard entries from resources.
2. HXT_PERIODS_OF_SERVICE – Contains periods of service data.

Billing and Revenue

1. PA_BILLING_EVENTS – Stores billing events for projects.
2. PA_REVENUE_PLAN – Holds the revenue plan for a project.

Others

1. PA_USER_DATA – Custom user data fields for projects.
2. PA_PROJECT_CLASSES – Classifications for projects.

It’s worth noting that the names and availability of these tables may differ based on the version of Oracle Cloud PPM you’re using. Also, Oracle might employ views or other database objects for more complex operations.