Search Results pa_cc_tp_rules_bg




The PA_CC_TP_RULES_BG table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Project Costing module, specifically related to cross-charge and transfer pricing rules at the business group level. This table stores configuration rules that govern how costs are allocated, transferred, or cross-charged between different entities, projects, or organizations within an enterprise. Below is a detailed summary of its purpose, structure, and functional relevance in Oracle EBS.

Purpose and Functional Context

The PA_CC_TP_RULES_BG table is part of Oracle Project Costing's cross-charge and transfer pricing framework. It defines business-group-specific rules that determine how costs are processed when transactions cross organizational boundaries. These rules ensure compliance with internal accounting policies, tax regulations, and intercompany agreements. The table works in conjunction with other Project Accounting (PA) tables, such as PA_PROJECTS_ALL, PA_TASKS, and PA_EXPENDITURE_ITEMS_ALL, to enforce cost allocation logic during transaction processing.

Key Columns and Data Structure

The table typically includes the following columns:
  • RULE_ID: A unique identifier for each rule.
  • BUSINESS_GROUP_ID: References the HR business group to which the rule applies.
  • RULE_NAME: A descriptive name for the rule.
  • RULE_TYPE: Specifies whether the rule is for cross-charging (CC) or transfer pricing (TP).
  • SOURCE_ENTITY_TYPE: Defines the source entity (e.g., project, task, organization).
  • DESTINATION_ENTITY_TYPE: Defines the destination entity for cost transfers.
  • ENABLED_FLAG: Indicates whether the rule is active.
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the rule's validity period.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Audit columns tracking record changes.

Integration with Other Modules

The PA_CC_TP_RULES_BG table integrates with Oracle General Ledger (GL), Oracle Payables (AP), and Oracle Receivables (AR) to ensure proper accounting entries are generated during cross-charge or transfer pricing transactions. For example:
  • When a cost is cross-charged, the rule determines the GL accounts to be debited/credited.
  • For intercompany transfers, the table ensures compliance with tax and legal requirements.

Configuration and Usage

Administrators configure rules via Oracle EBS forms or APIs, such as the "Cross Charge Rules" form in the Project Costing responsibility. Rules can be prioritized, and the system evaluates them in sequence until a match is found. The table's data is leveraged during:
  • Expenditure item validation and cost distribution.
  • Invoice generation for intercompany billing.
  • Period-end accrual and reconciliation processes.

Impact of Oracle EBS Version Differences

While the core functionality of PA_CC_TP_RULES_BG remains consistent between 12.1.1 and 12.2.2, version 12.2.2 may include enhancements like:
  • Improved rule conflict resolution logic.
  • Additional columns for advanced filtering conditions.
  • Better integration with Oracle Fusion Accounting Hub in hybrid deployments.

Conclusion

The PA_CC_TP_RULES_BG table is a foundational component of Oracle EBS Project Costing, enabling enterprises to manage complex cost allocation scenarios across business groups. Its structured rule definitions ensure accurate financial reporting, compliance, and seamless intercompany transactions. Proper configuration and maintenance of this table are essential for organizations leveraging Oracle EBS for project-driven accounting.

  • 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 ,