Results for “cbs_element_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_FP_PLANNING_RES_TMP1_1 is a temporary planning table in the PA (Projects) schema of Oracle E-Business Suite, documented as VALID in ETRM release 12.2.2. It belongs to the Project Resource Management / forecasting and planning area of the Projects module, and is one of a family of interim (TMP) tables used by the resource planning and forecasting programs to stage, sort, or aggregate planning rows before they are consumed by reporting logic or promoted into permanent planning tables. Because the name carries a numeric suffix, it should be regarded as a workspace or scratch table rather than a transactional master: contents are generally transient, scoped to a single planning run, and should not be treated as a system of record for committed project data.
From the mined foreign key structure, the object is classified heuristically as a standalone data vault construct. This is a modeling suggestion rather than a definitional statement: the table does not currently exhibit the hub-and-link topology typical of a normalized integration model, which is consistent with an interim planning staging table whose grain is defined by the combination of a task, a resource, and a planning window rather than by a single durable business entity. Implementers treating this object in a warehouse or integration layer should therefore consider a satellite-style treatment keyed on the task and resource combination, with the planning dates as descriptive context.
Key Information Stored
The documented physical schema exposes seven columns. The most significant are:
- TASK_ID — identifier of the project task against which planning is performed. This is the principal business-key candidate for the row grain.
- RESOURCE_LIST_MEMBER_ID — the resource list member being planned, linking the row to a specific resource within a resource list definition.
- RESOURCE_ASSIGNMENT_ID — the resource assignment context, tying the planning row to how the resource is assigned on the project.
- TOP_TASK_ID — the top-level task for the planning structure. This is the only documented foreign key, referencing PA_TOP_TASKS_IT, and is used to roll planning rows up to a structural parent task.
- PLANNING_START_DATE and PLANNING_END_DATE — the effective window over which the resource is planned, providing the temporal dimension of the staging row.
- CBS_ELEMENT_ID — the cost breakdown structure element used to classify the planned cost or effort.
No surrogate primary key is documented in the metadata excerpt; the effective row identity is therefore the composite of task, resource, CBS element, and planning window. Because this is an interim table, any uniqueness is generally enforced by the process that populates it rather than by a permanent constraint.
Common Use Cases and Queries
Typical uses are diagnostic and reporting-oriented: verifying that a forecasting run staged the expected planning rows, reconciling planned resource effort against assignments, and joining planning windows to financial periods for capacity reporting.
- Audit a planning run by task: SELECT task_id, resource_list_member_id, planning_start_date, planning_end_date FROM pa_fp_planning_res_tmp1_1 WHERE task_id = :task_id;
- Rollup by top task: join to PA_TOP_TASKS_IT on TOP_TASK_ID to group planned resources by structural parent.
- Cost classification review: group rows by CBS_ELEMENT_ID to confirm planned effort maps to the intended cost element.
- Resource demand by window: filter on PLANNING_START_DATE / PLANNING_END_DATE to build time-phased resource demand extracts.
- Reconciliation: outer join the temporary rows to resource assignment facts on RESOURCE_ASSIGNMENT_ID to identify staged rows with no matching assignment.
Queries should be constrained tightly and executed soon after the planning process runs, since interim content is subject to truncation.
Related Objects
- PA_TOP_TASKS_IT — referenced via PA_FP_PLANNING_RES_TMP1_1.TOP_TASK_ID; provides the top-level task structure used for rollups.
- PA_TASKS — supplies the task definition behind TASK_ID.
- PA_RESOURCE_ASSIGNMENTS — the assignment context behind RESOURCE_ASSIGNMENT_ID.
- PA_RESOURCE_LIST_MEMBERS — the resource list membership behind RESOURCE_LIST_MEMBER_ID.
- PA_CBS_ELEMENTS — the cost breakdown structure element behind CBS_ELEMENT_ID.
- PA_FP_PLANNING_RES_TMP1 and sibling interim tables in the PA_FP_PLANNING_RES_TMP family — parallel staging objects produced by the same planning programs.
- PA_PROJECTS_ALL — the project master used to resolve planning rows to project context.
Because the metadata available is limited to column and FK information, the above related objects are inferred from documented column semantics and should be validated against the live data dictionary in the target 12.1.1 or 12.2.2 instance before being relied upon in production SQL.
-
Table: PJI_FP_TXN_ACCUM1 12.2.2
This table stores summarized commitment measures at project, task and periodic levels for project performance
-
View: PA_ONLINE_TASKS_V 12.2.2
Customizable view for tasks used in Self Service Time, Oracle Time Capture, and Sel f Service Expense applications. PA_ONLINE_TASKS_V is a customizable view for Self Service Time application , Oracle Time Capture, and Self Service Expense.
APPS.PA_ONLINE_TASKS_V·↳ FND_PROFILE·↳ PA_ALTERNATE_TASKS·↳ PA_IMPLEMENTATIONS·Explore PA module →
-
This table stores summarized cost and revenue measures at project, task and periodic levels for project performance
-
View: PA_TASKS_ALL_EXPEND_V 12.2.2
View of the tasks for a given project to which you can charge expenditures
APPS.PA_TASKS_ALL_EXPEND_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_ALTERNATE_TASKS·Explore PA module →
-
This table stores the resource attribute combinations which are used for resource breakdown structure mapping
-
Summarization criteria for burden summarization of expenditure items.
APPS.PA_CDL_BURDEN_SUMMARY_V·↳ PA_BURDEN_COSTING·↳ PA_CDL_BURDEN_DETAIL_V·↳ PA_CLIENT_EXTN_BURDEN_RESOURCE·Explore PA module →
-
10SC Only
APPS.PA_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
APPS.PA_CDL_BURDEN_SUMMARY_V·↳ PA_BURDEN_COSTING·↳ PA_CDL_BURDEN_DETAIL_V·↳ PA_CLIENT_EXTN_BURDEN_RESOURCE·Explore IPA module →
-
View: PA_CDL_BURDEN_DETAIL_V 12.2.2
APPS.PA_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ PA_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore IPA module →
-
Table: PJI_FM_AGGR_FIN7 12.2.2
This intermediate table is used for staging data between PJI and PJP summarization runs.
-
Estimated percent completion for all levels of the work breakdown structure.
-
Commitment transactions for summarized project summary commitment amounts
-
Project-related AP invoice distributions not yet in Oracle Projects.
APPS.PA_PROJ_AP_INV_DISTRIBUTIONS·↳ AP_INVOICES_ALL·↳ AP_INVOICES_PKG·↳ AP_INVOICE_DISTRIBUTIONS_ALL·Explore PA module →
-
View: PA_CDL_BURDEN_DETAIL_V 12.2.2
Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary
APPS.PA_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ PA_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore PA module →
-
View: PA_TASKS_EXPEND_V 12.2.2
View of the tasks for a given project to which you can charge expenditures
APPS.PA_TASKS_EXPEND_V·↳ FND_PROFILE·↳ PA_ALTERNATE_TASKS·↳ PA_IMPLEMENTATIONS·Explore PA module →
-
Table: PA_FP_FCST_GEN_TMP1_1 12.2.2
-
View for project-related uninvoiced purchase order distributions. The non-recoverable tax is added to the amount outstanding invoice values.
APPS.PA_PROJ_PO_DISTRIBUTIONS·↳ FND_PROFILE·↳ GL_LEDGERS·↳ HR_GENERAL·Explore PA module →
-
View: PA_TASK_ASGMTS_V 12.2.2
APPS.PA_TASK_ASGMTS_V·↳ PA_BUDGET_VERSIONS·↳ PA_LOOKUPS·↳ PA_PROJECTS_ALL·Explore PA module →
-
View that displays project-related distributions in Oracle Purchasing that have not yet been purchased as a purchase order.
APPS.PA_PROJ_REQ_DISTRIBUTIONS·↳ FND_PROFILE·↳ GL_LEDGERS·↳ HR_GENERAL·Explore PA module →
-
Table: PJI_FM_XBS_ACCUM_TMP4 12.2.2
-
This table stores the changes to financial plan data
-
The smallest units of expenditure charged to projects and tasks
-
Table: PJI_FM_AGGR_FIN1 12.2.2
This intermediate table contains PJI summarization data during a summarization run.
-
View: PA_COMMITMENT_TXNS_V 12.2.2
A view of all oustanding project-related commitment costs.
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ FND_PROFILE·Explore PA module →
-
Table: PJI_FM_AGGR_FIN8 12.2.2
This intermediate table is used for staging data between PJI and PJP summarization runs.
-
View: PA_EXPENDITURE_ITEMS_V 12.2.2
10SC Only
APPS.PA_EXPENDITURE_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Interface table to import transactions from external sources into Oracle Projects
-
View: PA_TASK_ASSIGNMENTS_V 12.2.2
APPS.PA_TASK_ASSIGNMENTS_V·↳ PA_BUDGET_VERSIONS·↳ PA_EXPENDITURES_UTILS·↳ PA_FIN_PLAN_UTILS·Explore PA module →
-
This is table that is used to store temporary data from web ADI Layout to upload to Oracle Projects.
-
PA_PROGRESS_ROLLUP stores rolled up progress information for tasks and structures.
-
Information about expenditure item cost distribution
-
Pa_Cost_Distribution_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Resource assignments for a budget version at a branch of project's work breakdown
-
This intermediate table is used for the first aggregation of PJP data by periods.
-
APPS.GMS_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ GMS_AWARD_DISTRIBUTIONS·Explore GMS module →
-
View: PA_COMMITMENT_TXNS_V 12.2.2
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ FND_PROFILE·Explore JA module →
-
Pa_Txn_Interface_Audit_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
APPS.PA_ASSIGNMENT_PROGRESS_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
This intermediate table contains PJI summarization data during a summarization run.
-
This intermediate table contains dangling PJI summarization data between summarization runs.
-
10SC Only
APPS.PA_EXPEND_ITEMS_ADJUST_V·↳ FND_LOOKUP_VALUES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PA module →
-
Pa_Expenditure_items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Auditing information about updates on PA_TRANSACTION_INTERFACE_ALL
-
11i Only
APPS.PA_EXPEND_ITEMS_ADJUST2_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
VIEW: APPS.PA_OLAP_STAGE_V 12.2.2