Search Results txn_revenue

Overview

The table PJI_FM_EXTR_PLAN_LINES resides in the PJI schema and belongs to the Project Intelligence (PJI) product family, which Oracle classifies as Obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM repository, this table stores the changes to financial plan data. It functions as a staging and delta-capture structure within the Project Intelligence extraction and reporting framework, holding plan line records that have been captured from the source financial planning model for downstream analytical processing.

The heuristic Data Vault classification derived from the foreign key structure is link. This designation reflects the table's role as an associative construct: it resolves relationships between PA_BUDGET_VERSIONS, PA_PROJECTS_ALL, PA_PROJ_ELEMENTS, PA_RBS_ELEMENTS, and PA_RBS_VERSIONS_B. In a dimensional modeling exercise, this object is therefore best treated as a link (or fact-like association table) rather than a hub or satellite, since it primarily carries the intersection of project, element, and version identifiers alongside measures.

Key Information Stored

The documented physical schema contains 47 columns. The most significant identifiers and measures include:

PROJECT_ID – Foreign key to PA_PROJECTS_ALL; identifies the project whose plan is being captured.
PROJECT_ELEMENT_ID – Foreign key to PA_PROJ_ELEMENTS; the work breakdown or cost element context.
PLAN_VERSION_ID – Foreign key to PA_BUDGET_VERSIONS; identifies the specific plan/budget version.
RBS_ELEMENT_ID and RBS_VERSION_ID – Reference the resource breakdown structure element and version (PA_RBS_ELEMENTS, PA_RBS_VERSIONS_B).
PERIOD_NAME, START_DATE, END_DATE, CALENDAR_TYPE – Provide the temporal grain of the plan line.
CBS_ELEMENT_ID – Links the line to a cost breakdown structure element.
RESOURCE_CLASS_CODE and RATE_BASED_FLAG – Describe the type of resource planned and whether rate-based costing applies.
TXN_RAW_COST, PRJ_RAW_COST, PFC_RAW_COST, and their burdened and revenue counterparts – Carry transactional, project, and project functional currency amounts.
QUANTITY, ACT_QUANTITY, and ETC_QUANTITY – Represent planned, actual, and estimate-to-complete quantities; matching ACT_* and ETC_* cost and revenue columns support variance and forecasting.

The metadata does not document a single surrogate primary key column; PROJ

ECT_ID combined with PROJECT_ELEMENT_ID, PLAN_VERSION_ID, RBS_ELEMENT_ID, RBS_VERSION_ID, and PERIOD_NAME constitutes the probable composite business key.

Common Use Cases and Queries

Typical usage centres on comparing planned, actual, and estimate-to-complete financials across projects and RBS elements. A representative query joins to the master tables on the documented keys:

Plan-versus-actual variance analysis: select PRJ_BURDENED_COST and ACT_PRJ_BURDENED_COST, grouping by PROJECT_ID, PLAN_VERSION_ID, and PERIOD_NAME.
ETC forecasting: aggregate ETC_QUANTITY, ETC_TXN_RAW_COST, and ETC_PFC_BURDENED_COST by RESOURCE_CLASS_CODE.
Currency-translation reporting: reconcile TXN_*, PRJ_*, and PFC_* amounts using TXN_CURRENCY_CODE, PRJ_CURRENCY_CODE, and PFC_CURRENCY_CODE.

Joins to PA_PROJECTS_ALL and PA_BUDGET_VERSIONS are essential to resolve project names and version labels in any report.

Related Objects

PA_PROJECTS_ALL – joined on PROJECT_ID.
PA_BUDGET_VERSIONS – joined on PLAN_VERSION_ID.
PA_PROJ_ELEMENTS – joined on PROJECT_ELEMENT_ID.
PA_RBS_ELEMENTS – joined on RBS_ELEMENT_ID.
PA_RBS_VERSIONS_B – joined on RBS_VERSION_ID.

These five relationships constitute the complete documented dependency set for this obsolete Project Intelligence extraction table.

Table: PJI_FM_EXTR_PLAN_LINES 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_EXTR_PLAN_LINES, object_name:PJI_FM_EXTR_PLAN_LINES, status:VALID, product: PJI - Project Intelligence , description: This table stores the changes to financial plan data , implementation_dba_data: PJI.PJI_FM_EXTR_PLAN_LINES ,
Table: PA_FI_AMOUNT_DETAILS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FI_AMOUNT_DETAILS, object_name:PA_FI_AMOUNT_DETAILS, status:VALID, product: PA - Projects , description: This table stores the amount details information for a forecast item. , implementation_dba_data: PA.PA_FI_AMOUNT_DETAILS ,
Table: PA_FI_AMOUNT_DETAILS_AR 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FI_AMOUNT_DETAILS_AR, object_name:PA_FI_AMOUNT_DETAILS_AR, status:VALID, product: PA - Projects , description: This table stores the amount details information for a forecast item. , implementation_dba_data: PA.PA_FI_AMOUNT_DETAILS_AR ,
Table: PJI_FM_AGGR_FIN1 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN1, object_name:PJI_FM_AGGR_FIN1, status:VALID, product: PJI - Project Intelligence , description: This intermediate table contains PJI summarization data during a summarization run. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN1 ,
Table: PJI_FP_TXN_ACCUM 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FP_TXN_ACCUM, object_name:PJI_FP_TXN_ACCUM, status:VALID, product: PJI - Project Intelligence , description: This table stores summarized cost and revenue measures at project, task and periodic levels for project performance , implementation_dba_data: PJI.PJI_FP_TXN_ACCUM ,
Table: PJI_FP_TXN_ACCUM 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FP_TXN_ACCUM, object_name:PJI_FP_TXN_ACCUM, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This table stores summarized cost and revenue measures at project, task and periodic levels for project performance , implementation_dba_data: PJI.PJI_FP_TXN_ACCUM ,
Table: PJI_FM_AGGR_ACT1 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT1, object_name:PJI_FM_AGGR_ACT1, status:VALID, product: PJI - Project Intelligence , description: This is an intermediate summarization table. , implementation_dba_data: PJI.PJI_FM_AGGR_ACT1 ,
Table: PJI_FM_AGGR_FIN7 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN7, object_name:PJI_FM_AGGR_FIN7, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table is used for staging data between PJI and PJP summarization runs. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN7 ,
Table: PJI_FM_EXTR_PLAN_LINES_DEBUG 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG, object_name:PJI_FM_EXTR_PLAN_LINES_DEBUG, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This table stores the changes to financial plan data , implementation_dba_data: PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG ,
Table: PJI_FM_EXTR_PLAN_LINES_DEBUG 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG, object_name:PJI_FM_EXTR_PLAN_LINES_DEBUG, status:VALID, product: PJI - Project Intelligence , description: This table stores the changes to financial plan data , implementation_dba_data: PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG ,
Table: PJI_FM_AGGR_ACT4 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT4, object_name:PJI_FM_AGGR_ACT4, status:VALID, product: PJI - Project Intelligence , description: This intermediate table stages data between PJI and Project Performance summarization. , implementation_dba_data: PJI.PJI_FM_AGGR_ACT4 ,
Table: PJI_FM_XBS_ACCUM_TMP1_DEBUG 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG, object_name:PJI_FM_XBS_ACCUM_TMP1_DEBUG, status:VALID, product: PJI - Project Intelligence , implementation_dba_data: PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG ,
Table: PA_FP_FCST_GEN_TMP1_1 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_FCST_GEN_TMP1_1, object_name:PA_FP_FCST_GEN_TMP1_1, status:VALID, product: PA - Projects , implementation_dba_data: PA.PA_FP_FCST_GEN_TMP1_1 ,
Table: PJI_FM_AGGR_FIN8 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN8, object_name:PJI_FM_AGGR_FIN8, status:VALID, product: PJI - Project Intelligence , description: This intermediate table is used for staging data between PJI and PJP summarization runs. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN8 ,
Table: PA_FI_AMOUNT_DETAILS_AR 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FI_AMOUNT_DETAILS_AR, object_name:PA_FI_AMOUNT_DETAILS_AR, status:VALID, product: PA - Projects , description: This table stores the amount details information for a forecast item. , implementation_dba_data: PA.PA_FI_AMOUNT_DETAILS_AR ,
Table: PJI_FM_AGGR_FIN8 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN8, object_name:PJI_FM_AGGR_FIN8, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table is used for staging data between PJI and PJP summarization runs. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN8 ,
Table: PJI_FM_EXTR_PLAN_LINES 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_EXTR_PLAN_LINES, object_name:PJI_FM_EXTR_PLAN_LINES, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This table stores the changes to financial plan data , implementation_dba_data: PJI.PJI_FM_EXTR_PLAN_LINES ,
Table: PA_FP_RES_ASSIGNMENTS_TMP 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_RES_ASSIGNMENTS_TMP, object_name:PA_FP_RES_ASSIGNMENTS_TMP, status:VALID, product: PA - Projects , description: Stores the resource assignment level data for internal use of Oracle Projects , implementation_dba_data: PA.PA_FP_RES_ASSIGNMENTS_TMP ,
Table: PJI_FM_AGGR_FIN9 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN9, object_name:PJI_FM_AGGR_FIN9, status:VALID, product: PJI - Project Intelligence , implementation_dba_data: PJI.PJI_FM_AGGR_FIN9 ,
Table: PJI_FM_XBS_ACCUM_TMP4 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_XBS_ACCUM_TMP4, object_name:PJI_FM_XBS_ACCUM_TMP4, status:VALID, product: PJI - Project Intelligence(Obsolete) , implementation_dba_data: PJI.PJI_FM_XBS_ACCUM_TMP4 ,
Table: PA_BUDGET_LINES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_LINES, object_name:PA_BUDGET_LINES, status:VALID, product: PA - Projects , description: Detail lines of project and task budgets , implementation_dba_data: PA.PA_BUDGET_LINES ,
Table: PJI_FM_AGGR_FIN1 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN1, object_name:PJI_FM_AGGR_FIN1, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table contains PJI summarization data during a summarization run. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN1 ,
Table: PA_BUDGET_LINES_M_UPG_DTRANGE 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_LINES_M_UPG_DTRANGE, object_name:PA_BUDGET_LINES_M_UPG_DTRANGE, status:VALID, product: PA - Projects , description: INTERNAL , implementation_dba_data: PA.PA_BUDGET_LINES_M_UPG_DTRANGE ,
Table: PA_FRCST_ITEMS_AR 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FRCST_ITEMS_AR, object_name:PA_FRCST_ITEMS_AR, status:VALID, product: PA - Projects , description: This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled , implementation_dba_data: PA.PA_FRCST_ITEMS_AR ,
Table: PJI_FM_AGGR_FIN6 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN6, object_name:PJI_FM_AGGR_FIN6, status:VALID, product: PJI - Project Intelligence , description: This intermediate table is used for the first aggregation of PJP data by periods. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN6 ,
Table: PA_FP_SPREAD_CALC_TMP 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_SPREAD_CALC_TMP, object_name:PA_FP_SPREAD_CALC_TMP, status:VALID, product: PA - Projects , description: This is an internal table that is used to store temporary data required for calculate and spread api internal processing. This is a global temporary table. , implementation_dba_data: PA.PA_FP_SPREAD_CALC_TMP ,
Table: PJI_FM_XBS_ACCUM_INT 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_XBS_ACCUM_INT, object_name:PJI_FM_XBS_ACCUM_INT, status:VALID, product: PJI - Project Intelligence(Obsolete) , implementation_dba_data: PJI.PJI_FM_XBS_ACCUM_INT ,
Table: PA_FI_AMOUNT_DETAILS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FI_AMOUNT_DETAILS, object_name:PA_FI_AMOUNT_DETAILS, status:VALID, product: PA - Projects , description: This table stores the amount details information for a forecast item. , implementation_dba_data: PA.PA_FI_AMOUNT_DETAILS ,
Table: PA_FP_RES_ASSIGNMENTS_TMP 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_RES_ASSIGNMENTS_TMP, object_name:PA_FP_RES_ASSIGNMENTS_TMP, status:VALID, product: PA - Projects , description: Stores the resource assignment level data for internal use of Oracle Projects , implementation_dba_data: PA.PA_FP_RES_ASSIGNMENTS_TMP ,
Table: PA_BUDGET_LINES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_LINES, object_name:PA_BUDGET_LINES, status:VALID, product: PA - Projects , description: Detail lines of project and task budgets , implementation_dba_data: PA.PA_BUDGET_LINES ,
Table: PJI_FM_AGGR_FIN6 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN6, object_name:PJI_FM_AGGR_FIN6, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table is used for the first aggregation of PJP data by periods. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN6 ,
Table: PJI_FM_AGGR_FIN7 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN7, object_name:PJI_FM_AGGR_FIN7, status:VALID, product: PJI - Project Intelligence , description: This intermediate table is used for staging data between PJI and PJP summarization runs. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN7 ,
Table: PJI_FM_AGGR_ACT1 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT1, object_name:PJI_FM_AGGR_ACT1, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This is an intermediate summarization table. , implementation_dba_data: PJI.PJI_FM_AGGR_ACT1 ,
Table: PA_FORECAST_ITEMS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FORECAST_ITEMS, object_name:PA_FORECAST_ITEMS, status:VALID, product: PA - Projects , description: This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled , implementation_dba_data: PA.PA_FORECAST_ITEMS ,
Table: PA_FORECAST_ITEMS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FORECAST_ITEMS, object_name:PA_FORECAST_ITEMS, status:VALID, product: PA - Projects , description: This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled , implementation_dba_data: PA.PA_FORECAST_ITEMS ,
Table: PJI_FM_AGGR_ACT4 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT4, object_name:PJI_FM_AGGR_ACT4, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table stages data between PJI and Project Performance summarization. , implementation_dba_data: PJI.PJI_FM_AGGR_ACT4 ,
Table: PA_FRCST_ITEMS_AR 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FRCST_ITEMS_AR, object_name:PA_FRCST_ITEMS_AR, status:VALID, product: PA - Projects , description: This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled , implementation_dba_data: PA.PA_FRCST_ITEMS_AR ,
Table: PJI_FM_XBS_ACCUM_TMP1_DEBUG 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG, object_name:PJI_FM_XBS_ACCUM_TMP1_DEBUG, status:VALID, product: PJI - Project Intelligence(Obsolete) , implementation_dba_data: PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG ,
Table: PJI_FM_AGGR_FIN2 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN2, object_name:PJI_FM_AGGR_FIN2, status:VALID, product: PJI - Project Intelligence , description: This intermediate table contains PJI summarization data during a summarization run. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN2 ,
Table: PJI_FM_AGGR_FIN2 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_FIN2, object_name:PJI_FM_AGGR_FIN2, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table contains PJI summarization data during a summarization run. , implementation_dba_data: PJI.PJI_FM_AGGR_FIN2 ,
Table: PA_BUDGET_LINES_M_UPG_DTRANGE 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_LINES_M_UPG_DTRANGE, object_name:PA_BUDGET_LINES_M_UPG_DTRANGE, status:VALID, product: PA - Projects , description: INTERNAL , implementation_dba_data: PA.PA_BUDGET_LINES_M_UPG_DTRANGE ,
Table: PJI_FM_DNGL_FIN 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_DNGL_FIN, object_name:PJI_FM_DNGL_FIN, status:VALID, product: PJI - Project Intelligence , description: This intermediate table contains dangling PJI summarization data between summarization runs. , implementation_dba_data: PJI.PJI_FM_DNGL_FIN ,
Table: PJI_FM_DNGL_ACT 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_DNGL_ACT, object_name:PJI_FM_DNGL_ACT, status:VALID, product: PJI - Project Intelligence , description: This is an intermediate summarization table. , implementation_dba_data: PJI.PJI_FM_DNGL_ACT ,
Table: PJI_FM_DNGL_FIN 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_DNGL_FIN, object_name:PJI_FM_DNGL_FIN, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This intermediate table contains dangling PJI summarization data between summarization runs. , implementation_dba_data: PJI.PJI_FM_DNGL_FIN ,
Table: PJI_FM_AGGR_ACT5 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT5, object_name:PJI_FM_AGGR_ACT5, status:VALID, product: PJI - Project Intelligence , implementation_dba_data: PJI.PJI_FM_AGGR_ACT5 ,
Table: PJI_FM_AGGR_ACT2 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT2, object_name:PJI_FM_AGGR_ACT2, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This is an intermediate summarization table. , implementation_dba_data: PJI.PJI_FM_AGGR_ACT2 ,
Table: PJI_FM_DNGL_ACT 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_DNGL_ACT, object_name:PJI_FM_DNGL_ACT, status:VALID, product: PJI - Project Intelligence(Obsolete) , description: This is an intermediate summarization table. , implementation_dba_data: PJI.PJI_FM_DNGL_ACT ,
Table: PJI_FM_AGGR_ACT2 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT2, object_name:PJI_FM_AGGR_ACT2, status:VALID, product: PJI - Project Intelligence , description: This is an intermediate summarization table. , implementation_dba_data: PJI.PJI_FM_AGGR_ACT2 ,
Table: PA_FP_SPREAD_CALC_TMP 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_SPREAD_CALC_TMP, object_name:PA_FP_SPREAD_CALC_TMP, status:VALID, product: PA - Projects , description: This is an internal table that is used to store temporary data required for calculate and spread api internal processing. This is a global temporary table. , implementation_dba_data: PA.PA_FP_SPREAD_CALC_TMP ,
VIEW: PJI.PJI_FP_TXN_ACCUM# 12.2.2