Search Results pa_cc_tp_schedules_bg




Overview
Explore in AI Chat

Overview

The PA_CC_TP_SCHEDULES_BG table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for transfer price schedules. These schedules are critical for defining the rules and methods used to calculate the internal transfer price for cross-charged transactions between a provider organization (which supplies a resource or item) and a receiver organization (which consumes it). The table underpins the financial management of inter-organization transactions for both labor and non-labor costs, ensuring accurate internal billing and cost allocation across the enterprise.

Key Information Stored

The primary identifier for each schedule is the TP_SCHEDULE_ID column, which is the table's primary key. While the provided metadata does not list all columns, the table's description and foreign key relationships indicate it stores the header-level definition of a transfer price schedule. This typically includes attributes such as the schedule name, effective dates, calculation method (e.g., markup on cost, fixed rate), and the associated business group context (implied by the "_BG" suffix, common in Oracle EBS multi-org architecture). The detailed rules and rates for the schedule are stored in the related child table, PA_CC_TP_SCHEDULE_LINES.

Common Use Cases and Queries

This table is central to configuration and inquiry processes. Administrators use it to set up and maintain transfer pricing policies. Common operational queries involve identifying which schedules are assigned to specific projects or tasks, and validating schedule definitions for reporting. A typical reporting query would join this header table to its detail lines and to project assignments to analyze transfer pricing rules across the portfolio.

  • Find schedules assigned to projects: SELECT p.segment1 project, s.tp_schedule_id, s.schedule_name FROM pa_projects_all p, pa_cc_tp_schedules_bg s WHERE p.labor_tp_schedule_id = s.tp_schedule_id;
  • List all schedule headers with their line count: SELECT s.tp_schedule_id, s.schedule_name, COUNT(l.tp_schedule_line_id) FROM pa_cc_tp_schedules_bg s, pa_cc_tp_schedule_lines l WHERE s.tp_schedule_id = l.tp_schedule_id GROUP BY s.tp_schedule_id, s.schedule_name;

Related Objects

The PA_CC_TP_SCHEDULES_BG table has defined relationships with several key tables in the Projects module, as documented in the provided foreign key metadata.

  • PA_CC_TP_SCHEDULE_LINES: Stores the detailed rate or markup rules for a schedule. Joined via TP_SCHEDULE_ID.
  • PA_CC_TP_SCHEDULE_LINE_LKP: A lookup table for schedule lines, referencing the header via TP_SCHEDULE_ID.
  • PA_PROJECTS_ALL: A project can reference a transfer price schedule for labor (LABOR_TP_SCHEDULE_ID) and for non-labor (NL_TP_SCHEDULE_ID).
  • PA_TASKS: A task can have its own overriding transfer price schedules for labor and non-labor, also via LABOR_TP_SCHEDULE_ID and NL_TP_SCHEDULE_ID columns.