Search Results pa_cc_tp_rules




Overview
Explore in AI Chat

Overview

PA_CC_TP_RULES is an APPS-owned reporting view within the Oracle Projects (PA) module. In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, the view exposes transfer price rule definitions used by the Projects costing and cross-charge functionality. Transfer price rules determine how amounts are priced or marked up when costs or revenue are transferred between projects, tasks, or organizations. The view presents a business-group-secured projection of the underlying transfer price rule data, allowing concurrent programs, forms, and external integrations to query rule definitions without directly accessing the base table. Its status is documented as VALID in the ETRM metadata, confirming it is a supported, compiled object in the APPS schema.

Underlying Base Objects

The view text identifies three referenced base objects:

  • PA_CC_TP_RULES_BG (SYNONYM) — the primary source of the transfer price rule rows. The view selects its columns directly from this base object.
  • FND_PROFILE (PACKAGE) — invoked as FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') to resolve the session's current business group for row-level security.
  • PA_CROSS_BUSINESS_GRP (PACKAGE) — supplies the ISCROSSBGPROFILE flag that governs whether cross-business-group rows are also returned.

The WHERE clause implements standard EBS multi-org security: rows are returned only when the business group matches the profile value and cross-business-group access is disabled, or when the cross-business-group profile is enabled, in which case all business groups are visible. This pattern is consistent across Oracle Projects secured views.

Key Columns

Common Use Cases and Queries

Typical uses include validating which transfer price rules are active for a business group, joining rules to transferred cost or revenue transactions, and extracting rule configuration for reconciliation or migration. A basic query returning active rules is:

  • SELECT TP_RULE_ID, NAME, RULE_TYPE, CALC_METHOD_CODE, PERCENTAGE_APPLIED FROM APPS.PA_CC_TP_RULES WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE + 1);
  • Filtering by rule type: SELECT * FROM APPS.PA_CC_TP_RULES WHERE RULE_TYPE = :rule_type;
  • Rule with audit context: SELECT NAME, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.PA_CC_TP_RULES ORDER BY NAME;

Because the view enforces business-group security dynamically, the returned row set depends on the PER_BUSINESS_GROUP_ID profile setting and the cross-business-group profile at query time, which is essential to consider when building reports or integration extracts.