Oracle Fusion Projects Tables :15 Most Important Oracle Fusion Projects Tables

Oracle Fusion Projects Tables

In this post , We will be discuss about the Oracle Fusion Projects Tables. In Oracle fusion , Projects tables have been changed as compared to the Oracle apps. I will share the some of the important projects tables in oracle fusion. These tables helps to store the Oracle fusion project information. These table will store different types of Oracle project informations likes 'Project name , Project space template that is associated to the project , The project type that classifies the project, organization that is responsible for the project work, Project Status , Start Date of The Project, Project Completion Date, Legal entity , PROJECT_CATEGORY, ACTUAL_DURATION, Project People.

15 Most Important Oracle Fusion Projects Tables

1.PJF_PROJECTS_ALL_TL

2.PJF_PROJECT_TYPES_B

3.PJF_PROJECT_PARTIES

4.PJF_PROJECT_SETS_B

5.PJF_PROJECT_STATUSES_B

6.PJF_BU_IMPL_ALL

7.PJF_BU_IMPL_ALL

8.PA_IMPLEMENTATIONS_ALL

9.PJF_PROJ_ELEMENTS_B

10.PJF_PROJ_ROLE_TYPES_B

11.PJF_P_PERIODS_ALL_V

12.PJF_RATE_SCHEDULES_B

13.PJF_RBS_HEADERS_B

14.PJF_PROJ_ELEMENTS_TL

15.PJF_TXN_DOCUMENT_TL

Detail Explanation of Oracle Fusion Projects Tables

1.PJF_PROJECTS_ALL_TL  & PJF_PROJECTS_ALL_B

In this Table , we do get the basic Project related Information like Project space template that is associated to the project , The project type that classifies the project, organization that is responsible for the project work, Project Status , Start Date of The Project, Project Completion Date, Legal entity , PROJECT_CATEGORY, ACTUAL_DURATION

PJF_PROJECT_TYPES_B & PJF_PROJECT_TYPES_TL

We do get the Project Type's Information in this Table.

PJF_PROJECT_PARTIES

We do get all project people associated with the project whether active or inactive from this table

PJF_PROJECT_SETS_B & PJF_PROJECT_SETS_TL This table stores the Project Set information.

PJF_PROJECT_STATUSES_B & PJF_PROJECT_STATUSES_TL

This table is used to store various statuses related with a project.

PJF_BU_IMPL_ALL

PA_IMPLEMENTATIONS_ALL stores the parameters and defaults that define the configuration of your Oracle Projects installation. . If you have a multi-organization installation, you define one row for each operating unit.

PJF_PROJ_ELEMENTS_B

PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use.

PJF_PROJ_ROLE_TYPES_TL & PJF_PROJ_ROLE_TYPES_B

This table stores information about various roles, both seeded and user defined.

PJF_P_PERIODS_ALL_V

This Table help to Store the project Periods

PJF_RATE_SCHEDULES_B

Header table that stores sets of rate schedules used to calculate cost, bill, plan, budget, and forecastamounts. All rate schedules belong to a set and have an associated currency.

PJF_RBS_HEADERS_TL & PJF_RBS_HEADERS_B

This table stores the identifier, effective dates and related information for a resource breakdown structure.

PJF_PROJ_ELEMENTS_TL

PJF_TXN_DOCUMENT_TL

This table is used to store the Transaction Documents.

SELECT p.PROJECT_ID, s.PROJECT_SYSTEM_STATUS_CODE

FROM PJF_PROJECTS_ALL_B p, PJF_PROJECT_STATUSES_B s

WHERE p.PROJECT_STATUS_CODE = s.PROJECT_STATUS_CODE