Search Results pa_cc_tp_rules_bg




Overview
Explore in AI Chat

Overview

The PA_CC_TP_RULES_BG table is a core data object within the Oracle E-Business Suite Projects module (PA). It serves as the master repository for defining the business rules governing transfer price calculations. Transfer pricing is a critical financial mechanism for internal cost accounting, enabling organizations to assign a monetary value to goods, services, or labor transferred between different internal entities, such as departments or projects. This table stores the configurable rule definitions that determine how these prices are computed, forming the foundation for accurate intercompany or inter-project billing and cost allocation in a multi-organization environment.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the description explicitly states the table holds attributes that define the calculation methodology. Based on standard Oracle Projects functionality, a typical TP_RULE_ID record would include fields specifying the calculation method (e.g., fixed markup, schedule-based), the base amount to which the rule is applied (such as raw cost, burdened cost, or revenue), and the final percentage or markup value. Crucially, the table acts as a header that can be linked to detailed schedules of rates or percentages stored in related tables, allowing for complex, multi-tiered pricing structures.

Common Use Cases and Queries

The primary use case is the setup and maintenance of transfer pricing rules within the Oracle Projects application. Administrators create and manage these rules, which are then assigned to specific expenditure types, organizations, or projects to automate transfer price calculations. For reporting and data validation, common queries involve joining this table to its child schedule lines or to assignment tables. A fundamental query retrieves all rules for a given calculation method:

  • SELECT tp_rule_id, rule_name, calculation_method_code FROM pa_cc_tp_rules_bg WHERE calculation_method_code = 'SCHEDULE';

Another critical pattern is tracing which schedule lines use a specific rule, essential for understanding the full pricing structure before modifying a rule:

  • SELECT sched.* FROM pa_cc_tp_schedule_lines sched WHERE sched.labor_tp_rule_id = :p_rule_id OR sched.nl_tp_rule_id = :p_rule_id;

Related Objects

The PA_CC_TP_RULES_BG table has a defined primary key constraint, PA_CC_TP_RULES_BG_PK, on the TP_RULE_ID column. It is referenced by foreign keys in the PA_CC_TP_SCHEDULE_LINES table, establishing a one-to-many relationship. This relationship is documented in two distinct contexts:

  • PA_CC_TP_SCHEDULE_LINES.LABOR_TP_RULE_ID references PA_CC_TP_RULES_BG.TP_RULE_ID, linking rules to schedule lines for labor-related costs.
  • PA_CC_TP_SCHEDULE_LINES.NL_TP_RULE_ID references PA_CC_TP_RULES_BG.TP_RULE_ID, linking rules to schedule lines for non-labor (NL) costs.

This structure allows a single pricing rule definition in PA_CC_TP_RULES_BG to be utilized by multiple detailed rate schedules for different cost types, promoting reusability and consistent rule application across the system.

  • Table: PA_CC_TP_RULES_BG 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CC_TP_RULES_BG,  object_name:PA_CC_TP_RULES_BG,  status:VALID,  product: PA - Projects ,  description: Rules that define how transfer price is calculated, which include such attributes as calculation method, base amount, schedule or markup, and final percentage. ,  implementation_dba_data: PA.PA_CC_TP_RULES_BG , 

  • Table: PA_CC_TP_RULES_BG 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CC_TP_RULES_BG,  object_name:PA_CC_TP_RULES_BG,  status:VALID,  product: PA - Projects ,  description: Rules that define how transfer price is calculated, which include such attributes as calculation method, base amount, schedule or markup, and final percentage. ,  implementation_dba_data: PA.PA_CC_TP_RULES_BG , 

  • Table: PA_CC_TP_SCHEDULE_LINES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CC_TP_SCHEDULE_LINES,  object_name:PA_CC_TP_SCHEDULE_LINES,  status:VALID,  product: PA - Projects ,  description: Transfer price schedule lines which make up a transfer price schedule. ,  implementation_dba_data: PA.PA_CC_TP_SCHEDULE_LINES , 

  • Table: PA_CC_TP_SCHEDULE_LINES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CC_TP_SCHEDULE_LINES,  object_name:PA_CC_TP_SCHEDULE_LINES,  status:VALID,  product: PA - Projects ,  description: Transfer price schedule lines which make up a transfer price schedule. ,  implementation_dba_data: PA.PA_CC_TP_SCHEDULE_LINES , 

  • View: PA_CC_TP_RULES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CC_TP_RULES,  object_name:PA_CC_TP_RULES,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CC_TP_RULES , 

  • View: PA_CC_TP_RULES 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CC_TP_RULES,  object_name:PA_CC_TP_RULES,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CC_TP_RULES ,