Results for “pc_discount_rate_m”

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

Overview

APPS.FPA_AW_PC_DISC_FUNDS_V is an Oracle E-Business Suite view owned by the APPS schema that exposes planning-cycle-level discount rate and funding data sourced from an Oracle OLAP analytic workspace. Within the Enterprise Territory Management (ETRM) / Oracle Incentive Compensation technology stack, this view is the reporting and integration surface for "PC" (planning cycle) funding and discount information. Rather than storing rows in a conventional relational table, the view projects analytic workspace measures into a relational result set at query time, allowing SQL-based tools, concurrent programs, and downstream applications to consume multidimensional data through standard SELECT statements. The view is documented in ETRM 12.2.2, and its construction is consistent across the EBS 12.1.1 and 12.2.2 releases, since it relies on the OLAP_TABLE pipelined function interface rather than release-specific table structures.

Underlying Base Objects

The view is defined over two documented base objects:

• FPA_UTILITIES_PVT (PACKAGE) — The ETRM utility package that supplies the OLAP workspace name through the AW_SPACE_NAME constant. The view concatenates this value with the literal ' duration query' to form the fully qualified analytic workspace name passed to OLAP_TABLE.
• OLAP_TABLE (SYNONYM) — The Oracle OLAP synonym for the pipelined table function that materializes multidimensional query results into rows and columns. The view calls it with four arguments: the workspace name, the target table alias FPA_PC_DISCOUNT_TBL, an empty limit-map parameter, and the OLAP command string that defines the dimension, attribute, and measures.

The OLAP command string maps a PLANNING_CYCLE dimension from PLANNING_CYCLE_D, an attribute PC_DISPLAY_FACTOR from FACTOR_PC_R, and the measures PC_DISCOUNT_RATE from PC_DISCOUNT_RATE_M and PC_FUNDING from PC_FUNDING_M. The view therefore does not join relational tables directly; it depends on the analytic workspace being loaded and available to the APPS schema at query time.

Key Columns

• PLANNING_CYCLE — The dimension value identifying the planning cycle to which the figures apply. It is the effective grouping key for any aggregation or filter.
• PC_DISCOUNT_RATE — The discount rate measure for the planning cycle, sourced from the PC_DISCOUNT_RATE_M measure in the analytic workspace.
• PC_FUNDING — The funding amount or factor measure for the planning cycle, sourced from PC_FUNDING_M. This column is the primary target of searches on the term "pc_funding."
• PC_DISPLAY_FACTOR — A display attribute derived from FACTOR_PC_R, typically used to control presentation, rounding, or labeling of the measures in reporting layers.

Common Use Cases and Queries

Typical usage includes verification of loaded planning-cycle funding, reconciliation between the analytic workspace and relational staging data, and extraction of discount and funding figures for compensation plan modeling and reporting.

• Retrieve all planning cycles with their funding and discount values:

  SELECT planning_cycle, pc_discount_rate, pc_funding, pc_display_factor
  FROM   apps.fpa_aw_pc_disc_funds_v
  ORDER BY planning_cycle;

• Target a single planning cycle for reconciliation:

  SELECT planning_cycle, pc_funding
  FROM   apps.fpa_aw_pc_disc_funds_v
  WHERE  planning_cycle = :p_planning_cycle;

• Aggregate funding across cycles for a summary report:

  SELECT SUM(pc_funding) total_funding
  FROM   apps.fpa_aw_pc_disc_funds_v;

Because the view invokes OLAP_TABLE, queries against it require the analytic workspace referenced by FPA_UTILITIES_PVT.AW_SPACE_NAME to be attached and current. If the workspace is unavailable or unloaded, queries fail or return no rows, so operational use should be preceded by a check of the AW load status. Security follows standard APPS-schema view privileges; grant access through a custom synonym or secured grant rather than querying APPS directly where segregation of duties applies.