Results for “asset_allocation_method”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PA_CAPITAL_PROJECTS_BASE_V view (owner: APPS, status: VALID) is a Projects (PA) module object that presents summary capital amounts for a project. Its documented description reads: "R10SC Only - Base view that shows summary capital amounts for a project." It consolidates, at the project level, the capitalizable and total costs accumulated against capital projects alongside the asset-interface attributes defined on the project type. The view is a base view: it supplies the denormalized, join-ready result set that other capital-project reporting views and capital asset interface processes build upon, rather than exposing granular transactions itself.
Because capital project reporting must reconcile two distinct sources of capital amounts — accumulated cost transactions and already-capitalized asset amounts — the view is defined as a UNION ALL of two queries. The first returns projects with cost accumulation data; the second returns projects with capitalized asset records. This makes it the canonical starting point for queries that need a single, unified picture of capital-project financial position.
Underlying Base Objects
The view is defined over the following documented base objects:
- PA_PROJECTS_ALL — the project definition, supplying name, segment, status, type, asset allocation method, capital event processing, and carrying-out organization.
- PA_PROJECT_TYPES_ALL — the project type, supplying
INTERFACE_COMPLETE_ASSET_FLAG,INTERFACE_ASSET_COST_CODE,CAPITAL_COST_TYPE_CODE,BURDEN_AMT_DISPLAY_METHOD, andTOTAL_BURDEN_FLAG. - PA_PROJECT_ACCUM_HEADERS / PA_PROJECT_ACCUM_ACTUALS — project-level accumulation buckets providing
RAW_COST_ITD,BILLABLE_RAW_COST_ITD,BURDENED_COST_ITD, andBILLABLE_BURDENED_COST_ITD. The join constrainsTASK_ID = 0andRESOURCE_ID = 0, i.e., project-level totals only. - PA_PROJECT_ASSETS — already-capitalized amounts (
CAPITALIZED_COST) returned by the second branch of the union. - HR_ORGANIZATION_UNITS — resolves the carrying-out organization name; secured via HR_SECURITY and HR_GENERAL.
- PA_TXN_ACCUM and PJI_FP_XBS_ACCUM_F — additional accumulation objects referenced in the dependency metadata.
Filtering ensures only non-template projects (TEMPLATE_FLAG <> 'Y') with project type class CAPITAL are selected, and excludes projects where PJI_SOURCE_FLAG is not null.
Key Columns
- PROJECT_ID / NAME / SEGMENT1 — project identifier, name, and number.
- PROJECT_STATUS_CODE / PROJECT_TYPE — lifecycle status and type.
- INTERFACE_COMPLETE_ASSET_FLAG / INTERFACE_ASSET_COST_CODE — control whether costs interface to Fixed Assets and which cost code is used.
- ORG_NAME — name of the carrying-out organization.
- CAPITALIZABLE_COST — derived via
DECODEonCAPITAL_COST_TYPE_CODE: billable raw or billable burdened cost ITD. - TOTAL_COST — derived via
DECODE: raw or burdened cost ITD. - CAPITALIZED_COST — capitalized amount from
PA_PROJECT_ASSETS(second union branch). - ASSET_ALLOCATION_METHOD / CAPITAL_EVENT_PROCESSING — defaulted to 'N' when null.
- CAPITAL_COST_TYPE_CODE / BURDEN_AMT_DISPLAY_METHOD / TOTAL_BURDEN_FLAG — cost-type and burden display attributes.
Common Use Cases and Queries
Typical uses include capital-project cost reviews, asset-interface readiness checks, and reconciling accumulated cost against capitalized amounts.
- Capital amounts by project:
SELECT project_id, name, segment1, capitalizable_cost, total_cost, capitalized_cost FROM pa_capital_projects_base_v; - Projects pending asset interface:
SELECT segment1, name, interface_complete_asset_flag FROM pa_capital_projects_base_v WHERE interface_complete_asset_flag = 'N'; - Reconcile accumulated vs capitalized:
SELECT segment1, total_cost, capitalized_cost FROM pa_capital_projects_base_v WHERE total_cost <> capitalized_cost;
Because the view is documented as "R10SC Only," treat it as a legacy compatibility object; confirm its presence in the target release before relying on it in custom reporting.
-
Asset Allocation Method
-
Asset Allocation Method
-
R10SC Only -Base view that shows summary capital amounts for a project
APPS.PA_CAPITAL_PROJECTS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
R10SC Only -Base view that shows summary capital amounts for a project
APPS.PA_CAPITAL_PROJECTS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Based on the Event Processing Method defined at the project level, capital events are system generat
-
Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Based on the Event Processing Method defined at the project level, capital events are system generat
-
APPS.PA_ASSET_ALLOC_EXCEPTIONS_V·↳ MO_GLOBAL·↳ PA_REPORTING_EXCEPTIONS·Explore PA module →
-
APPS.PA_ASSET_ALLOC_EXCEPTIONS_V·↳ MO_GLOBAL·↳ PA_REPORTING_EXCEPTIONS·Explore PA module →
-
View: PA_CAPITAL_PROJECTS_V 12.2.2
R10SC Only - View of summary expensed, CIP, capitalizable, capitalized, and total project costs for capital projects
APPS.PA_CAPITAL_PROJECTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_CAPITAL_PROJECTS_BASE_V·Explore PA module →
-
View: PA_CAPITAL_PROJECTS_V 12.1.1
R10SC Only - View of summary expensed, CIP, capitalizable, capitalized, and total project costs for capital projects
APPS.PA_CAPITAL_PROJECTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_CAPITAL_PROJECTS_BASE_V·Explore PA module →
-
Implementation-defined project classifications that supply default information and drive some project processing
-
View: PA_PROJECTS_AMG_V 12.1.1
Internal
APPS.PA_PROJECTS_AMG_V·↳ PA_PROJECTS·↳ PA_PROJECT_STRUCTURE_UTILS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
View: PA_PROJECTS_AMG_V 12.2.2
Internal
APPS.PA_PROJECTS_AMG_V·↳ PA_PROJECTS·↳ PA_PROJECT_STRUCTURE_UTILS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
Implementation-defined project classifications that supply default information and drive some project processing
-
View: PA_PROJECTS_V 12.2.2
APPS.PA_PROJECTS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: PA_PROJECTS_V 12.1.1
APPS.PA_PROJECTS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects.
-
PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects.
-
VIEW: PA.PA_CAPITAL_EVENTS# 12.2.2
-
VIEW: PA.PA_CAPITAL_EVENTS# 12.2.2
-
View: PA_PROJECT_TYPES 12.2.2
Single-Org
Not implemented in this database·Explore PA module →
-
View: PA_PROJECT_TYPES 12.1.1
Single-Org
Not implemented in this database·Explore PA module →
-
View: PA_CAPITAL_EVENTS_V 12.2.2
APPS.PA_CAPITAL_EVENTS_V·↳ PA_CAPITAL_EVENTS·↳ PA_LOOKUPS·Explore PA module →
-
TABLE: PA.PA_CAPITAL_EVENTS 12.2.2
-
TABLE: PA.PA_CAPITAL_EVENTS 12.1.1
-
View: PA_CAPITAL_EVENTS_V 12.1.1
APPS.PA_CAPITAL_EVENTS_V·↳ PA_CAPITAL_EVENTS·↳ PA_LOOKUPS·Explore PA module →
-
VIEW: PA.PA_PROJECTS_ALL# 12.2.2
-
View: PA_PROJECTS 12.1.1
Single-Org
Not implemented in this database·Explore PA module →
-
View: PA_PROJECTS 12.2.2
Single-Org
Not implemented in this database·Explore PA module →
-
VIEW: APPS.PA_PROJECTS_AMG_V 12.1.1
-
VIEW: APPS.PA_PROJECTS_AMG_V 12.2.2