Results for “product_group”

29 results




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

Overview

BIS_CSTMRGPGTT_V is a reporting view in the Oracle EBS Applications BIS (Business Intelligence System) product family. Its documentation metadata describes it as "Retrofitted," indicating that the object was carried forward from an earlier release line into the 12.1.1 / 12.2.2 codebase, and it is listed under the ETRM record as "Not implemented in this database." The latter designation is significant: the view is defined in the repository for reference and upgrade purposes but is not instantiated in every environment.

The object belongs to the Oracle Balanced Scorecard / target-management area of BIS, which stores business plan definitions, target values, and performance ranges. Its suffix "_V" identifies it as a view rather than a base table, and its name contains the string "CSTMRGPGTT", which the view text ties explicitly to a target level short name. Functionally, the view flattens hierarchical target data into a denormalized, report-friendly shape suitable for business reporting and downstream integration.

Underlying Base Objects

The view text is defined over a four-table join:

  • BIS_TARGET_VALUES — alias VAL, the fact-style table holding target values and range boundaries.
  • BIS_BUSINESS_PLANS — alias PLAN, supplying plan identity, naming, version, and current-plan status.
  • BIS_TARGET_LEVELS — alias LVL, defining the target level and process context.
  • GL_PERIODS — alias GL, the General Ledger period reference used in the join.

The ETRM metadata records no referenced base objects separately ("none documented"), so the authoritative source for join structure is the embedded view text. The join predicate links VAL.TARGET_LEVEL_ID = LVL.TARGET_LEVEL_ID, VAL.PLAN_ID = PLAN.PLAN_ID, and filters LVL.SHORT_NAME = 'CSTMRGPGTT', with GL_PERIODS participating in the FROM clause. The hard-coded short name means the view returns only the target level associated with the "CSTMRGPGTT" (customer/product group target) definition.

Key Columns

  • WF_PROCESS — the workflow or process context inherited from the target level.
  • PLAN_ID, PLAN_SHORT_NAME, VERSION_NO, CURRENT_PLAN_FLAG — plan identity and versioning attributes; CURRENT_PLAN_FLAG distinguishes the active plan version from historical ones.
  • TOTAL_TIME — the time bucket associated with the target value.
  • PRODUCT_GROUP — the product group dimension value, which corresponds to the user search term. This is the primary dimensional column for grouping results.
  • TARGET, RANGE1_LOW, RANGE1_HIGH, RANGE2_LOW, RANGE2_HIGH, RANGE3_LOW, RANGE3_HIGH — the target figure and up to three performance ranges, commonly used for scorecard banding and threshold analysis.
  • ROLE1_ID, ROLE2_ID, ROLE3_ID and ROLE1, ROLE2, ROLE3 — role identifiers and their display names, assigning accountability for each target.

Common Use Cases and Queries

Typical usage is ad hoc reporting over balanced-scorecard targets by product group, filtering to the current plan version and comparing actual performance against the defined ranges.

  • Listing current product-group targets:
    SELECT product_group, target, range1_low, range1_high
      FROM bis_cstmrpgtt_v
     WHERE current_plan_flag = 'Y';
  • Reviewing role accountability for a plan:
    SELECT plan_short_name, product_group, role1, role2, role3
      FROM bis_cstmrpgtt_v
     WHERE plan_id = :plan_id;
  • Examining all versions of a plan:
    SELECT plan_short_name, version_no, current_plan_flag, product_group, target
      FROM bis_cstmrpgtt_v
     ORDER BY plan_short_name, version_no;

Because the view is documented as not implemented in all databases, queries should first confirm object existence, and consumers should expect the object to appear only in environments where the BIS target-level configuration for "CSTMRGPGTT" has been deployed.