Results for “capacity_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_FIN_PLAN_AMOUNT_SETS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the various amount sets available for financial plans. An amount set defines the collection of cost, revenue, quantity, and rate measures that a financial plan can display, capture, and report on. Each row represents one configured amount set, and its flags determine which financial dimensions and units of measure are enabled for that set. Because financial plan layouts, entry options, and reporting behavior are driven by the amount set selected against a project's plan options, this table functions as a configuration reference table for plan presentation and calculation logic.

From a Data Vault modeling perspective, the mined relationship data classifies this object as hub-leaning. The table holds a stable, uniquely identifiable business concept (the amount set) that is referenced by multiple downstream option records, making it a candidate for a hub, with descriptive flag columns potentially modeled as a satellite.

Key Information Stored

Each row is uniquely identified by the surrogate primary key FIN_PLAN_AMOUNT_SET_ID, enforced through the PA_FIN_PLAN_AMOUNT_SETS_PK constraint. A unique index, PA_FIN_PLAN_AMOUNT_SETS_U1, covers FIN_PLAN_AMOUNT_SET_ID together with ZD_EDITION_NAME, which in the 12.2.2 schema reflects the multitenant/editioning column used to support online patching and edition-based redefinition. The most significant descriptive columns are:

• AMOUNT_SET_TYPE_CODE — classifies the amount set type, controlling how the set is interpreted by financial plan logic.
• RAW_COST_FLAG and BURDENED_COST_FLAG — enable raw and burdened cost amounts respectively.
• COST_QTY_FLAG — enables cost quantities within the set.
• REVENUE_FLAG and REVENUE_QTY_FLAG — enable revenue amounts and revenue quantities.
• TP_COST_FLAG and TP_REVENUE_FLAG — enable transfer price cost and transfer price revenue amounts.
• UTIL_PERCENT_FLAG and UTIL_HOURS_FLAG — enable utilization percentage and utilization hours measures.
• CAPACITY_FLAG — enables capacity amounts.
• BILL_RATE_FLAG, COST_RATE_FLAG, and BURDEN_RATE_FLAG — enable bill, cost, and burden rate measures.
• ALL_QTY_FLAG — enables the aggregate quantity measure.
• PRE_DEFINED_FLAG — indicates whether the amount set is seeded by Oracle as opposed to user-defined.

Standard WHO audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN track row creation and modification history.

Common Use Cases and Queries

Typical uses include identifying seeded versus user-defined amount sets, listing which financial measures are enabled for a given set, and joining amount sets to project financial plan options to explain plan behavior. A representative query lists the measure composition of each set:

• SELECT amount_set_type_code, raw_cost_flag, burdened_cost_flag, revenue_flag, tp_cost_flag, tp_revenue_flag, capacity_flag, bill_rate_flag FROM pa_fin_plan_amount_sets WHERE pre_defined_flag = 'Y';
• Reporting which amount sets are referenced by project plan options: SELECT o.project_id, o.all_amount_set_id, o.cost_amount_set_id, o.revenue_amount_set_id FROM pa_proj_fp_options o WHERE o.cost_amount_set_id = :amount_set_id;
• Validating configuration before plan generation or amount set migration by verifying that required flags (for example, COST_RATE_FLAG or BILL_RATE_FLAG) are enabled for sets in active use.

Related Objects

The documented foreign key relationships show that PA_PROJ_FP_OPTIONS is the principal dependent table, referencing PA_FIN_PLAN_AMOUNT_SETS through three separate columns, each joined on FIN_PLAN_AMOUNT_SET_ID:

• PA_PROJ_FP_OPTIONS.ALL_AMOUNT_SET_ID → PA_FIN_PLAN_AMOUNT_SETS — the amount set applied to the "all" plan view.
• PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID → PA_FIN_PLAN_AMOUNT_SETS — the amount set applied to cost plan views.
• PA_PROJ_FP_OPTIONS.REVENUE_AMOUNT_SET_ID → PA_FIN_PLAN_AMOUNT_SETS — the amount set applied to revenue plan views.

Because PA_PROJ_FP_OPTIONS governs financial plan configuration at the project level, changes to amount set definitions propagate into plan display, entry, and aggregation behavior. Related plan and option objects in the PA financial plan schema should be reviewed alongside this table when diagnosing plan rendering or measure availability issues.