Results for “pa_comp_ot_exp_types”

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

Overview

PA_COMP_OT_EXP_TYPES is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that assigns labor cost multipliers to overtime expenditure types for each labor costing rule. The multipliers defined here are applied during raw cost calculation for transactions charged to the associated expenditure types. In effect, the table acts as the bridge that binds a compensation rule set, an expenditure type, and a named labor cost multiplier into a single costing directive that Oracle Projects observes when computing raw labor cost.

The table resides in the PA schema and is listed with a VALID status in the ETRM repository. From a Data Vault modeling perspective, the mined classification for this object is link. This is a heuristic suggestion rather than a physical Data Vault declaration: the table satisfies the profile of a link because it primarily carries foreign key associations among PA_COMPENSATION_RULE_SETS, PA_EXPENDITURE_TYPES, and PA_LABOR_COST_MULTIPLIERS, with descriptive audit columns rather than a rich set of dependent attributes. The documented physical schema in 12.2.2 shows eight columns.

Key Information Stored

The table's grain is defined by its unique index, and the columns that matter most for interpretation are those that carry the costing relationship itself.

• LABOR_COSTING_RULE — Part of the composite primary key and the foreign key to PA_COMPENSATION_RULE_SETS. It identifies the labor costing rule under which the multiplier applies.
• EXPENDITURE_TYPE — The second component of the composite primary key and the foreign key to PA_EXPENDITURE_TYPES. It identifies the overtime expenditure type to which the multiplier is bound.
• LABOR_COST_MULTIPLIER_NAME — The foreign key to PA_LABOR_COST_MULTIPLIERS. It names the multiplier that Oracle Projects applies to raw cost for transactions charged to the associated expenditure type.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when and by whom the row was inserted.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification and the login responsible for it.

The primary key, PA_COMP_OT_EXP_TYPES_PK, is composite on (LABOR_COSTING_RULE, EXPENDITURE_TYPE). A unique index, PA_COMP_OT_EXP_TYPES_U1, exists on the same two columns, which is therefore the business-key candidate. Because the uniqueness of the relationship is enforced by that composite key rather than by a single surrogate identifier, the table has no standalone surrogate primary key column; the two business columns together serve as the identifier.

Common Use Cases and Queries

Typical uses center on configuring and verifying overtime costing behavior. An implementation team may validate that each applicable overtime expenditure type is mapped to the intended multiplier under a given costing rule.

SELECT coet.labor_costing_rule,
       coet.expenditure_type,
       coet.labor_cost_multiplier_name
  FROM pa.pa_comp_ot_exp_types coet
 WHERE coet.labor_costing_rule = :rule
 ORDER BY coet.expenditure_type;

A reporting query may join the multipliers to see the percentage or rate applied:

SELECT coet.expenditure_type,
       lcm.labor_cost_multiplier_name,
       lcm.multiplier_percentage
  FROM pa.pa_comp_ot_exp_types coet,
       pa.pa_labor_cost_multipliers lcm
 WHERE coet.labor_cost_multiplier_name = lcm.labor_cost_multiplier_name
   AND coet.labor_costing_rule = :rule;

Common scenarios include auditing overtime cost buildup, troubleshooting unexpected raw cost on overtime transactions, and preparing extracts for reconciliation of labor costing rules across operating units.

Related Objects

• PA_COMPENSATION_RULE_SETS — Referenced by PA_COMP_OT_EXP_TYPES.LABOR_COSTING_RULE; supplies the costing rule context.
• PA_EXPENDITURE_TYPES — Referenced by PA_COMP_OT_EXP_TYPES.EXPENDITURE_TYPE; defines the overtime expenditure type.
• PA_LABOR_COST_MULTIPLIERS — Referenced by PA_COMP_OT_EXP_TYPES.LABOR_COST_MULTIPLIER_NAME; supplies the multiplier value.

These three parent tables form the core dependency chain, and any query that resolves the full costing meaning of a PA_COMP_OT_EXP_TYPES row must join across all three.