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.
- PERIOD_ID — Surrogate primary key (constraint CN_PERIOD_STATUSES_PK) uniquely identifying each Sales Compensation period record.
- ORG_ID — Operating unit identifier; enforces multi-org partitioning.
- PERIOD_NAME — Human-readable period label, mirrored from the GL period naming convention.
- PERIOD_SET_NAME / PERIOD_SET_ID / CALENDAR_ID — Define the accounting calendar and period set the period belongs to; PERIOD_SET_NAME and PERIOD_NAME participate in the foreign key to GL_PERIODS.
- PERIOD_TYPE_ID / PERIOD_TYPE — Distinguishes period category (for example month, quarter, year).
- PERIOD_STATUS — The Incentive Compensation period status, tracked independently from GL status.
- PROCESSING_STATUS_CODE — Indicates the current processing state of the period within the CN calculation/payment cycle.
- FREEZE_FLAG — Marks whether the period is frozen against further transactions.
- FORECAST_FLAG / QUARTER_NUM / PERIOD_YEAR — Classification attributes useful for forecasting and calendar-based reporting.
- START_DATE / END_DATE — Date boundaries of the period.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enabling function security alignment.
- OBJECT_VERSION_NUMBER — Standard EBS optimistic locking column.
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_codeFROM cn_period_statuses_allWHERE 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.
- CN_PERIOD_QUOTAS_ALL — references PERIOD_ID; stores quota allocations by period.
- CN_COMMISSION_LINES_ALL — references PROCESSED_PERIOD_ID; holds commission transaction lines.
- CN_COMM_LINES_API_ALL — references PROCESSED_PERIOD_ID; the API interface for commission lines.
- CN_PAYRUNS_ALL — references ACCOUNTING_PERIOD_ID and PAY_PERIOD_ID; the payment run header.
- CN_PAYMENT_API_ALL — references PERIOD_ID; the payment API interface.
- CN_PROCESS_BATCHES_ALL — references PERIOD_ID; batch processing control.
- CN_SRP_PERIODS_ALL and CN_SRP_PERIOD_QUOTAS_ALL — reference PERIOD_ID for Sales Rep period setup and quotas.
- GL_PERIODS — the parent reference for period_set_name and period_name.
-
Status of the Sales Compensation accounting periods. In addition to the GL status.
-
CN_CALC_SUBMISSION_BATCHES contains information about calculation
-
Status of the Sales Compensation accounting periods. In addition to the GL status.
-
CN_CALC_SUBMISSION_BATCHES contains information about calculation
-
VIEW: APPS.CN_PERIODS_ALL_V 12.2.2
-
VIEW: APPS.CN_PERIODS_ALL_V 12.1.1
-
VIEW: APPS.CN_PERIODS 12.1.1
-
VIEW: APPS.CN_PERIODS 12.2.2
-
PACKAGE: APPS.MSC_UTIL 12.1.1
-
PACKAGE: APPS.MSC_UTIL 12.2.2
-
eTRM - CN Tables and Views 12.1.1
-
eTRM - CN Tables and Views 12.2.2