Search Results chv_org_options




Overview
Explore in AI Chat

Overview

CHV_ORG_OPTIONS is the organization-level options table for the Supplier Scheduling (CHV) module in Oracle E-Business Suite. It is owned by the PO schema and holds configuration flags, schedule designators, and bucket pattern references that govern how supplier scheduling and cumulative quantity processing behave for a given inventory organization. In EBS 12.1.1 and 12.2.2, the table is documented as VALID with 35 columns and a single-row-per-organization design, keyed by ORGANIZATION_ID.

Under the heuristic Data Vault classification mined from the foreign-key structure, CHV_ORG_OPTIONS is modeled as a standalone satellite rather than a hub or link. This classification is a suggestion: with ORGANIZATION_ID as the primary key and no dependencies on other hub-style entities, the table functions as a descriptive satellite attached to an organizational context, but implementers should validate it against their own integration model.

Key Information Stored

The primary key is CHV_ORG_OPTIONS_PK, defined on ORGANIZATION_ID, and a further unique index CHV_ORG_OPTIONS_U1 also covers ORGANIZATION_ID. This confirms ORGANIZATION_ID as the business-key candidate and makes it the natural foreign-key target for dependent supply-chain tables.

Common Use Cases and Queries

Typical uses include confirming whether cumulative tracking is active for an organization, reviewing schedule configuration before running supplier scheduling concurrent programs, and auditing configuration changes. A representative query:

  • SELECT organization_id, enable_cum_flag, rtv_update_cum_flag FROM chv_org_options WHERE organization_id = :org_id;
  • Join to bucket patterns to resolve schedule formatting: SELECT o.organization_id, o.plan_schedule_type, p.pattern_name FROM chv_org_options o, bucket_pattern p WHERE o.plan_bucket_pattern_id = p.pattern_id;
  • Reporting on organizations where cumulative updates from return-to-vendor are enabled: SELECT organization_id FROM chv_org_options WHERE rtv_update_cum_flag = 'Y';

These patterns support administration and reconciliation reporting rather than transactional processing.

Related Objects

Because the table is modeled as standalone, it has few explicit foreign-key relationships; integration occurs by convention through ORGANIZATION_ID and the referenced designator/pattern identifiers.

  • PO.CHV_SCHEDULE_HDRS / PO.CHV_SCHEDULE_LINES — supplier schedule headers and lines scoped by ORGANIZATION_ID.
  • PO.CHV_CUM_QUANTITIES — cumulative quantity records governed by ENABLE_CUM_FLAG and RTV_UPDATE_CUM_FLAG.
  • ORG_ORGANIZATION_DEFINITIONS — resolves ORGANIZATION_ID to the organizational entity.
  • MRP/MPS plan tables referenced through COMPILE and SCHEDULE designators.
  • Bucket pattern definition tables referenced by PLAN_BUCKET_PATTERN_ID and SHIP_BUCKET_PATTERN_ID.
  • FND descriptive flexfield definitions consumed via ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.

These objects should be treated as the primary integration surface for CHV_ORG_OPTIONS data.