Search Results gl_curr_mst




Overview
Explore in AI Chat

Overview

The GL_CURR_MST table is a master data repository for currency definitions within the Oracle E-Business Suite, specifically for the Process Manufacturing Financials (GMF) module. Its primary role is to serve as the central reference for all currency codes utilized across integrated financial and operational processes. A critical implementation detail is that, when Oracle Financials is integrated, this table is populated and synchronized with currency data from the core Oracle Financials applications, ensuring a single source of truth for currency information across the manufacturing and financial ecosystem.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure is defined by its purpose. The primary column is CURRENCY_CODE, which serves as the unique identifier and primary key (GL_CURR_MST_PK). This code corresponds to standard ISO currency codes like USD, EUR, or GBP. Based on its description and foreign key relationships, the table likely stores associated descriptive attributes for each currency, such as the currency name, symbol, and potentially precision details. It acts as the validating entity for any currency code used in transactional and master data tables throughout the GMF and related modules.

Common Use Cases and Queries

This table is fundamental for any reporting or data validation involving monetary amounts. Common use cases include validating currency codes in data imports, generating reports that list all active currencies, and supporting multi-currency transactions in Process Manufacturing. A typical query would join GL_CURR_MST to transactional tables to retrieve currency descriptions alongside amounts.

  • Basic Currency Listing: SELECT currency_code FROM gl_curr_mst ORDER BY currency_code;
  • Validation in Data Loads: Ensuring a provided currency code exists: SELECT COUNT(*) FROM gl_curr_mst WHERE currency_code = :p_curr_code;
  • Reporting Join Example: Retrieving purchase order details with currency description: SELECT poh.order_number, poh.billing_currency, cm.currency_name FROM po_ordr_hdr poh, gl_curr_mst cm WHERE poh.billing_currency = cm.currency_code;

Related Objects

GL_CURR_MST is a foundational table referenced extensively by foreign keys across GMF and adjacent modules, primarily in Procurement (PO), Order Management (OP), and General Ledger setup tables. Key documented relationships include: