Search Results cst_mgd_infl_adj_per_statuses




Overview
Explore in AI Chat

Overview

The CST_MGD_INFL_ADJ_PER_STATUSES table is a Bills of Material (BOM) schema object within Oracle E-Business Suite that stores the inflation adjustment status for each accounting period, scoped by inventory organization. It functions as the period-level control record for the Cost Management "managed inflation adjustment" process, indicating whether inflation adjustments have been processed, are pending, or are otherwise incomplete for a given organization and period combination.

The table resides in the BOM schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. The documented physical schema lists 12 columns. The primary key, CST_MGD_INFL_ADJ_PER_STATUS_PK, is composed of ORGANIZATION_ID and ACCT_PERIOD_ID. A unique index, CST_MGD_INFL_ADJ_PER_STATUS_U1, enforces the same (ORGANIZATION_ID, ACCT_PERIOD_ID) combination as a business-key candidate.

From a heuristic Data Vault modeling perspective, the FK structure classifies this table as satellite-leaning. Its natural grain — one record per organization per accounting period, dependent on the ORG_ACCT_PERIODS parent — makes it a descriptor-bearing satellite rather than a hub or link.

Key Information Stored

The 12 documented columns capture both the business key and standard Oracle WHO-column audit metadata, along with the operational status flag:

  • ORGANIZATION_ID — Inventory organization identifier; part of the composite primary key and the business-key unique index.
  • ACCT_PERIOD_ID — Accounting period identifier; also part of the primary key and unique index, and the FK to ORG_ACCT_PERIODS.
  • STATUS — The inflation adjustment status flag for the organization/period combination; the principal functional payload of the row.
  • LAST_UPDATE_DATE — Timestamp of the most recent row modification.
  • LAST_UPDATED_BY — User ID that last modified the record.
  • CREATION_DATE — Timestamp when the status record was created.
  • CREATED_BY — User ID that created the record.
  • LAST_UPDATE_LOGIN — Login identifier associated with the last update.
  • REQUEST_ID — Concurrent request ID that processed or updated the status.
  • PROGRAM_APPLICATION_ID — Application owning the program that last touched the row.
  • PROGRAM_ID — Concurrent program identifier.
  • PROGRAM_UPDATE_DATE — Date the owning program last updated the row.

The surrogate-style audit columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) allow tracing the exact concurrent process responsible for a status change, which is essential for reconciliation and audit.

Common Use Cases and Queries

Typical usage centers on determining whether inflation adjustments have completed for an organization and period before downstream costing runs proceed. A common diagnostic query joins the status table to the period definition:

  • Period readiness check — Verify the STATUS value for a given organization and period prior to running inflation or cost rollup processes.
  • Reconciliation reporting — Correlate the concurrent REQUEST_ID with request history to confirm which job set the status.
  • Audit trail — Track LAST_UPDATED_BY and LAST_UPDATE_DATE to establish who last altered the inflation status.

A representative query pattern selects the status alongside the accounting period name through ORG_ACCT_PERIODS, filtered by ORGANIZATION_ID and ACCT_PERIOD_ID. Because (ORGANIZATION_ID, ACCT_PERIOD_ID) is unique, lookups by this pair return a single row, making the pattern efficient for point-in-time checks.

Related Objects

  • ORG_ACCT_PERIODS — Parent table; joined on CST_MGD_INFL_ADJ_PER_STATUSES.ACCT_PERIOD_ID = ORG_ACCT_PERIODS.ACCT_PERIOD_ID and ORGANIZATION_ID. Supplies period name, start date, and end date.
  • ORG_ORGANIZATION_DEFINITIONS — Provides organization name and code for reporting on ORGANIZATION_ID.
  • CST_MGD_INFL_ADJUSTMENTS — Related Cost Management inflation adjustment data typically consumed alongside this status.
  • FND_CONCURRENT_REQUESTS — Resolves REQUEST_ID to the concurrent program name and run details.
  • FND_USER — Resolves CREATED_BY and LAST_UPDATED_BY to user names.

These relationships give developers and analysts a complete picture of inflation adjustment state per organization and period.