Results for “gmf_calendar_assignments”

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

Overview

GMF_CALENDAR_ASSIGNMENTS is a table in the GMF schema (Process Manufacturing Financials) within Oracle E-Business Suite. It stores cost calendar assignments, which define which cost calendar and cost type combination applies to a given legal entity for the purpose of cost collection, valuation, and period-close activities. In process manufacturing, costs are accumulated and rolled up on a calendar-driven basis, so this table acts as the configuration bridge that binds a calendar code to an operating unit or legal entity and to a specific cost type.

From a data modeling perspective, the metadata's heuristic Data Vault classification is standalone. That suggests the table functions as a self-contained hub or reference record annotated by foreign keys, rather than as a pure transactional link or satellite. It carries both business-key identifying columns and audit/attribute columns typical of a reference configuration entity.

Key Information Stored

The table has 42 documented columns. The most significant are:

• ASSIGNMENT_ID — the surrogate primary key, enforced by unique index GMF_CALENDAR_ASSIGNMENTS_U1. It uniquely identifies each assignment record.
• CALENDAR_CODE, LEGAL_ENTITY_ID, and COST_TYPE_ID — the combined business key, enforced by unique index GMF_CALENDAR_ASSIGNMENTS_U2. This composite unique constraint guarantees that only one assignment exists per calendar, legal entity, and cost type combination.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES, identifying the legal entity to which the cost calendar applies.
• COST_TYPE_ID — foreign key to CST_COST_TYPES, identifying which cost type (such as standard, actual, or frozen) the calendar assignment governs.
• TEXT_CODE — a descriptive or short-code attribute used for identification in user interfaces and reports.
• DELETE_MARK — the Oracle-style soft-delete flag; rows with a nonzero value are treated as logically deleted.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording who created and last modified the assignment.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the descriptive flexfield (DFF) columns that allow customers to extend the table with site-specific configuration without schema changes.

Common Use Cases and Queries

Because cost calendar assignments drive which calendar is used to collect and value costs, the primary use cases are configuration validation, period-close troubleshooting, and reporting.

• Validate active assignments: identify which calendar and cost type are configured for a legal entity.
• Detect gaps or overlaps: confirm that each legal entity / cost type pair has exactly one active calendar assignment.
• Audit changes: use the audit columns to determine when assignments were last altered.

A representative query joins the table to its lookups:

SELECT gca.assignment_id, gca.calendar_code, fle.legal_entity_name, cct.cost_type, gca.text_code
FROM gmf.gmf_calendar_assignments gca,
     fnd.legal_entities fle,
     cst.cst_cost_types cct
WHERE gca.legal_entity_id = fle.legal_entity_id
  AND gca.cost_type_id = cct.cost_type_id
  AND NVL(gca.delete_mark,0) = 0;

Reporting typically extracts the calendar code and cost type per legal entity for reconciliation and close reporting.

Related Objects

• FV_LEGAL_ENTITIES — referenced via GMF_CALENDAR_ASSIGNMENTS.LEGAL_ENTITY_ID; the parent legal entity definition.
• CST_COST_TYPES — referenced via GMF_CALENDAR_ASSIGNMENTS.COST_TYPE_ID; defines the cost type being assigned.
• GMF_CALENDARS (and related calendar definition tables) — the calendar referenced by CALENDAR_CODE.
• GMF_CALENDAR_ASSIGNMENTS_U1 / _U2 — the unique indexes enforcing the surrogate and business keys.
• Cost collection and valuation process tables in the CST schema, which consume the resolved calendar/cost type pairing during period processing.

Together these objects form the configuration layer that governs how process manufacturing costs are collected and valued across legal entities.