Results for “forecast_flag”

42 results




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

Overview

CN_PERIOD_STATUSES_ALL is the master period definition and status table for Oracle Incentive Compensation (CN) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the accounting periods used by Sales Compensation, recording the Incentive Compensation period status in addition to the corresponding General Ledger period status. Because Incentive Compensation maintains its own processing, calculation, and payment cycles that are frequently offset from GL close schedules, this table allows the CN module to track its distinct lifecycle states (open, closed, frozen) without depending solely on GL period control.

The table is owned by the CN schema and resides in the APPLSYSPUB/APPS-accessible data model as an _ALL object, meaning it is partitioned by operating unit through the ORG_ID column and is therefore multi-org enabled. In Data Vault modeling terms, the documented 27-column schema and single-column primary key make this object a good candidate for a hub: the surrogate key PERIOD_ID anchors each unique period instance, and the descriptive/status attributes form satellite-like payload that can be versioned over time. This classification is a heuristic model suggestion rather than a mandated design.

Key Information Stored

The table contains 27 columns; the most significant are summarized below.

Two unique indexes stand out as business-key candidates: CN_PERIOD_STATUSES_U1 (PERIOD_ID, ORG_ID) and CN_PERIOD_STATUSES_U2 (ORG_ID, PERIOD_NAME, PERIOD_SET_ID, PERIOD_TYPE_ID). The second confirms that a period name is unique within an operating unit, period set, and period type combination.

Common Use Cases and Queries

Typical uses include locating the current open period for a compensation plan, validating period status before running calculations or payments, and reconciling CN period state against GL. A representative query to find open periods for an operating unit follows:

  • SELECT period_id, period_name, period_status, processing_status_code
  • FROM cn_period_statuses_all
  • WHERE org_id = :p_org_id AND period_status = 'O'
  • AND trunc(sysdate) BETWEEN start_date AND end_date;

Reporting scenarios frequently join this table to GL_PERIODS on period_set_name and period_name to compare CN and GL statuses, or filter on FREEZE_FLAG to prevent post-close adjustments. Period calendars are also commonly queried through FORECAST_FLAG and PERIOD_YEAR for trend and forecast reporting.

Related Objects

CN_PERIOD_STATUSES_ALL is referenced by numerous Incentive Compensation transactional and setup tables through foreign keys, confirming its role as a central hub.