Project template table in Oracle Fusion

Project template table in Oracle Fusion

In this post , we will be discuss about the Project template table in Oracle Fusion. Project template tables help to store the Project space template that is associated to the project. Here below is the complete Project tables list having detail informations about each project table in oracle fusion. 

Project template table in Oracle Fusion

15 Important Project template table in Oracle Fusion

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 Project template table in Oracle Fusion

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.

SQL Query to Extract the Project template table in Oracle Fusion

SELECT

TASK.ROWID ROW_ID,

TASK.PROJ_ELEMENT_ID TASK_ID,

TASK.PROJECT_ID,

TASK.ELEMENT_NUMBER TASK_NUMBER,

TASK.CREATION_DATE,

TASK.CREATED_BY,

TASK.LAST_UPDATE_DATE,

TASK.LAST_UPDATED_BY,

TASK.LAST_UPDATE_LOGIN,

PPETL.NAME TASK_NAME,

TASK.DENORM_TOP_ELEMENT_ID TOP_TASK_ID,

TASK.DENORM_WBS_LEVEL WBS_LEVEL,

TASK.DENORM_PARENT_ELEMENT_ID PARENT_TASK_ID,

PPETL.DESCRIPTION,

TASK.CARRYING_OUT_ORGANIZATION_ID,

TASK.SERVICE_TYPE_CODE,

TASK.MANAGER_PERSON_ID TASK_MANAGER_PERSON_ID,

TASK.CHARGEABLE_FLAG,

TASK.BILLABLE_FLAG,

TASK.LIMIT_TO_TXN_CONTROLS_FLAG,

TASK.START_DATE,

TASK.COMPLETION_DATE,

TASK.LABOR_COST_MULTIPLIER_NAME,

TASK.ATTRIBUTE_CATEGORY,

TASK.ATTRIBUTE1,

TASK.ATTRIBUTE2,

TASK.ATTRIBUTE3,

TASK.ATTRIBUTE4,

TASK.ATTRIBUTE5,

TASK.ATTRIBUTE6,

TASK.ATTRIBUTE7,

TASK.ATTRIBUTE8,

TASK.ATTRIBUTE9,

TASK.ATTRIBUTE10,

TASK.ATTRIBUTE11,

TASK.ATTRIBUTE12,

TASK.ATTRIBUTE13,

TASK.ATTRIBUTE14,

TASK.ATTRIBUTE15,

TASK.COST_IND_RATE_SCH_ID,

TASK.COST_IND_SCH_FIXED_DATE,

TASK.PM_SOURCE_REFERENCE PM_TASK_REFERENCE,

TASK.PM_SOURCE_CODE PM_PRODUCT_CODE,

TASK.LEAF_NODE_FLAG,

TASK.ALLOW_CROSS_CHARGE_FLAG,

TASK.CC_PROCESS_LABOR_FLAG,

TASK.LABOR_TP_SCHEDULE_ID,

TASK.LABOR_TP_FIXED_DATE,

TASK.CC_PROCESS_NL_FLAG,

TASK.NL_TP_SCHEDULE_ID,

TASK.NL_TP_FIXED_DATE,

TASK.RECEIVE_PROJECT_INVOICE_FLAG,

TASK.WORK_TYPE_ID,

TASK.OBJECT_VERSION_NUMBER,

TASK.RETIREMENT_COST_FLAG,

TASK.CINT_ELIGIBLE_FLAG,

TASK.CINT_STOP_DATE,

TASK.CLIN_ELEMENT_ID CLIN_TASK_ID,

TASK.GEN_ETC_SOURCE_CODE,

TASK.CREATED_FROM_SOURCE_ID,

TASK.PLANNING_START_DATE,

TASK.PLANNING_END_DATE,

TASK.BASELINE_START_DATE,

TASK.BASELINE_FINISH_DATE,

TASK.ETC_CALC_METHOD,

TASK.PERCENT_COMP_CALC_METHOD,

TASK.SITE_USE_ID,

TASK.PLANNING_DATES_ROLLUP_FLAG,

TASK.CAPITALIZABLE_FLAG,

TASK.DENORM_ELEM_VER_ID,

TASK.DENORM_PARENT_STRUCT_VER_ID,

TASK.DENORM_PARENT_ELEM_VER_ID,

TASK.DENORM_PARENT_OBJECT_TYPE,

TASK.DENORM_WBS_NUMBER,

TASK.DENORM_DISPLAY_SEQUENCE,

TASK.IC_CLIN_ELEMENT_ID,

TASK.CRITICAL_FLAG,

TASK.MILESTONE_FLAG,

TASK.OVR_COST_IND_RATE_SCH_ID

FROM

PJF_PROJ_ELEMENTS_B TASK,

PJF_PROJ_ELEMENTS_TL PPETL

WHERE

TASK.PROJ_ELEMENT_ID = PPETL.PROJ_ELEMENT_ID AND PPETL.LANGUAGE = USERENV('LANG') AND TASK.ELEMENT_TYPE = 'FINANCIAL' AND TASK.OBJECT_TYPE = 'PJF_TASKS'