Search Results gmf_process_organizations_gt




Overview
Explore in AI Chat

Overview

GMF_PROCESS_ORGANIZATIONS_GT is a temporary global temporary table (GTT) owned by the GMF schema within Oracle E-Business Suite, belonging to the Process Manufacturing Financials product family. As the "_GT" suffix indicates, the object is designed to hold session-scoped row data that is visible only to the session that inserts it, and whose rows are typically purged at transaction or session commit. In the context of Oracle EBS 12.1.1 and 12.2.2, the table serves as an intermediate workspace that stores process organizations for a temporary session, allowing run-time logic to collect and pass a set of relevant process manufacturing organizations between concurrent programs, forms, or PL/SQL routines without persisting them permanently in a base table.

Because the object functions as a transient staging container rather than a durable business entity, its heuristic Data Vault classification is best treated as standalone, as indicated by the mined FK structure. Where a modeling suggestion is required, the table behaves like neither a pure hub, link, nor satellite: it is an ephemeral work structure. Practitioners mapping EBS data into a Data Vault should therefore treat GMF_PROCESS_ORGANIZATIONS_GT as a transient source that feeds persistent hubs or links rather than as a modeled entity in its own right.

Key Information Stored

The documented physical schema contains six columns, reflecting its narrow, purpose-built design for carrying organization context during a temporary session. The most significant columns are:

  • ORGANIZATION_ID — the internal identifier for the process organization, and the principal surrogate/business key candidate used to join back to organization-related tables in the GMF and INV schemas.
  • ORGANIZATION_CODE — the short alphanumeric code that users recognize for the organization, useful for reporting labels and cross-referencing.
  • BASE_CURRENCY_CODE — the functional/base currency assigned to the organization, relevant to costing and financial postings.
  • STD_UOM — the standard unit of measure for the organization, applied in process manufacturing quantity handling.
  • LEGAL_ENTITY_ID — the legal entity associated with the organization; this is the sole documented foreign key, referencing FV_LEGAL_ENTITIES.
  • OPERATING_UNIT_ID — the operating unit context for the organization, used in multi-org security and subledger accounting flows.

No unique index or enforced primary key is documented for this global temporary table, which is consistent with its role as a session-scoped collection where duplicates may be tolerated or explicitly managed by the calling program.

Common Use Cases and Queries

Typical scenarios involve populating the table from a driving process, then joining to it to restrict downstream queries to a chosen set of organizations. A representative pattern is:

  • Insert the target organizations for the session: INSERT INTO gmf_process_organizations_gt (organization_id, organization_code, legal_entity_id, operating_unit_id) SELECT ... FROM mtl_parameters WHERE ...;
  • Filter financial or costing data to only those organizations: SELECT ... FROM gmf_cost_... c WHERE EXISTS (SELECT 1 FROM gmf_process_organizations_gt g WHERE g.organization_id = c.organization_id);
  • Resolve legal entity context for reporting: SELECT g.organization_id, g.legal_entity_id, l.legal_entity_name FROM gmf_process_organizations_gt g, fv_legal_entities l WHERE g.legal_entity_id = l.legal_entity_id;

Because rows are session-private, the same query executed in parallel sessions does not contend for data, making the table suitable for concurrent reporting and batch jobs. Reports that summarize balances or costs by operating unit or base currency frequently use this temporary set as a security and scope filter.

Related Objects

The most significant related objects, based on the documented FK and organizational context, include:

  • FV_LEGAL_ENTITIES — referenced through GMF_PROCESS_ORGANIZATIONS_GT.LEGAL_ENTITY_ID; the primary documented foreign key relationship.
  • HR_OPERATING_UNITS — source for the OPERATING_UNIT_ID context.
  • MTL_PARAMETERS — the inventory/process organization definition table frequently used to populate ORGANIZATION_ID and ORGANIZATION_CODE.
  • FND_CURRENCIES — validates BASE_CURRENCY_CODE values.
  • GMF_ORGANIZATION_DEFINITIONS and related GMF organization setup views — provide persistent process organization attributes.
  • GL_LEDGERS / GL_SETS_OF_BOOKS — linked indirectly through the legal entity for financial reporting.

These relationships support the table's central role as a lightweight, session-bound filter for process manufacturing financials processing.