SQL Queries tables in Oracle Fusion Project Management

 In Oracle Fusion Project Management, several key tables store data related to various aspects of project management. These tables are integral for managing project finances, resources, and operations. Here are some of the key tables:

1. Projects and Tasks

   • PJF_PROJECTS_ALL: Stores information about projects.
   • PJF_TASKS: Stores details of tasks associated with projects.

2. Expenditures

   • PJC_EXPENDITURE_ITEMS: Holds expenditure item data.
   • PJC_EXPENDITURE_TYPES: Stores types of expenditures.

3. Budgets and Forecasts

   • PJF_BUDGET_VERSIONS: Contains budget versions for projects.
   • PJF_BUDGET_LINES: Stores individual budget lines.

4. Project Costing

   • PJC_COST_DISTRIBUTION_LINES: Contains cost distribution lines.
   • PJC_TRANSACTIONS: Stores project transaction details.

5. Billing

   • PJB_INVOICES_ALL: Contains billing invoice data.
   • PJB_INVOICE_LINES_ALL: Stores invoice lines.

6. Resources and Assignments

   • PJR_RESOURCES: Contains information about resources assigned to projects.
   • PJR_ASSIGNMENTS: Stores details of resource assignments to tasks.

7. Contracts and Funding

   • PJB_CONTRACTS_ALL: Holds contract information.
   • PJB_FUNDING_DISTRIBUTIONS: Contains funding distribution details.

8. Project Integration and Reporting

   • PJF_PROJECT_REPORTING: Stores data for project reporting purposes.
   • PJF_INTEGRATION_EVENTS: Contains integration event data for project management.

These tables are crucial for the functionality of Oracle Fusion Project Management, allowing users to manage projects comprehensively from budgeting and costing to billing and resource management.

Please refer to the Oracle documentations for any changes in the latest releases.