Search Results gmf_period_statuses




Overview
Explore in AI Chat

Overview

GMF.GMF_PERIOD_STATUSES is a Process Manufacturing Financials (GMF) table that stores cost period statuses for a combination of Legal Entity and Cost Type. In Oracle EBS 12.1.1 and 12.2.2, it functions as the operational control record for the Process Manufacturing cost calendar: each row defines a discrete accounting period for a given legal entity and cost type, along with its start date, end date, and open/closed status. Downstream costing, cost rollup, period close, and inventory valuation processes in Process Manufacturing consult this table to determine whether transactions may be costed or posted into a given period.

The table is owned by the GMF schema and is documented with 46 columns. The metadata's heuristic Data Vault classification, mined from foreign key structure, is standalone. This suggests a modeling interpretation in which GMF_PERIOD_STATUSES behaves as a self-contained reference/status entity rather than as a dependent satellite or a resolving link. Its foreign keys reference other master data (FV_LEGAL_ENTITIES and CST_COST_TYPES) without any inbound reference pointing to it, reinforcing its role as a controlling reference table.

Key Information Stored

The most significant columns fall into three groups: identity, period definition, and status.

  • PERIOD_ID — surrogate primary key of the row. It is the single-column target of unique index GMF_PERIOD_STATUSES_U1.
  • LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES, identifying the legal entity whose books the period belongs to.
  • COST_TYPE_ID — foreign key to CST_COST_TYPES, identifying the costing method (e.g., frozen, average) the period applies to.
  • CALENDAR_CODE — the accounting calendar that defines the period structure.
  • PERIOD_CODE — the period name (e.g., a month or week label) within that calendar.
  • START_DATE and END_DATE — the effective date bounds of the period.
  • PERIOD_STATUS — the open/closed indicator that governs whether cost transactions may be processed.
  • TEXT_CODE — a descriptive or reference code accompanying the period.
  • DELETE_MARK — the standard soft-delete flag used throughout EBS.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns tracking audit and user attribution.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the descriptive flexfield (DFF) columns, allowing client-specific extensions without schema change.

The business-key candidate is the composite unique index GMF_PERIOD_STATUSES_U2 on (LEGAL_ENTITY_ID, COST_TYPE_ID, CALENDAR_CODE, PERIOD_CODE). This confirms that a period is uniquely identified not by its surrogate ID alone, but by the combination of legal entity, cost type, calendar, and period code.

Common Use Cases and Queries

Typical reporting and integration scenarios include determining which periods are currently open, retrieving date ranges for costing windows, and reconciling cost periods against the general ledger calendar.

To list open periods for a given legal entity and cost type:

SELECT period_code, start_date, end_date, period_status
FROM   gmf.gmf_period_statuses
WHERE  legal_entity_id = :legal_entity_id
AND    cost_type_id    = :cost_type_id
AND    calendar_code   = :calendar_code
AND    period_status    = 'O'
ORDER BY start_date;

To find the period spanning a transaction date:

SELECT period_code, period_status
FROM   gmf.gmf_period_statuses
WHERE  legal_entity_id = :legal_entity_id
AND    cost_type_id    = :cost_type_id
AND    :txn_date BETWEEN start_date AND end_date;

Reporting use cases include open-period audit reports, period-close dashboards spanning all legal entities, and validation queries that flag transactions posting outside any defined period (i.e., no matching row).

Related Objects

  • FV_LEGAL_ENTITIES — joined via GMF_PERIOD_STATUSES.LEGAL_ENTITY_ID = FV_LEGAL_ENTITIES.LEGAL_ENTITY_ID; supplies legal entity name and attributes.
  • CST_COST_TYPES — joined via GMF_PERIOD_STATUSES.COST_TYPE_ID = CST_COST_TYPES.COST_TYPE_ID; supplies cost type description and costing method.
  • GMF_PERIOD_BALANCES — the period balance table that shares the legal entity/cost type/calendar/period key and relies on GMF_PERIOD_STATUSES to know whether a period is open.
  • GMF_COST_ITEMS / GMF_ITEM_COSTS — costing results that are valid only for periods whose status is open.
  • GL_PERIOD_STATUSES — the General Ledger equivalent, commonly compared against GMF periods during close reconciliation.
  • MTL_TRANSACTIONS / MTL_MATERIAL_TRANSACTIONS — inventory transactions that are validated against the effective cost period.
  • GMF_PERIOD_CLOSING / period-close concurrent programs — processes that update PERIOD_STATUS when a period is opened or closed.