Results for “derive_factor”

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

Overview

GL_CURR_MST is the master currency definition table for Oracle Process Manufacturing Financials (GMF). In Oracle EBS 12.1.1 and 12.2.2, it stores the set of currencies recognized by the Process Manufacturing applications, including descriptive attributes and currency derivation rules used in costing, billing, and order processing. The documented description confirms that, when Oracle Financials integration is enabled, this table is populated with currency data sourced from Oracle Financials rather than being maintained independently within GMF. This makes GL_CURR_MST effectively an integration-point reference table: the general ledger becomes the system of record, and GMF consumes the maintained currency list.

The primary key documented for the table is GL_CURR_MST_PK, defined on the CURRENCY_CODE column. This mirrors the pattern of a reference or lookup master, where the natural business identifier (the ISO-style currency code) is itself the unique key. Under the heuristic Data Vault classification supplied in the metadata, GL_CURR_MST is described as hub-leaning. In Data Vault modeling terms, it behaves as a hub: a stable, insert-oriented list of unique business keys (CURRENCY_CODE) with minimal or slowly changing descriptive attributes, surrounded by the many transactional and master tables that reference it.

Key Information Stored

The table is documented with 18 physical columns in the 12.2.2 schema. The most significant are summarized below.

• CURRENCY_CODE — The business key and the column on which the unique index GL_CURR_MST_PK is defined. It is the value referenced by all incoming foreign keys across the GMF, OPM, and Process Ordering tables.
• CURRENCY_DESC — The descriptive name of the currency, used in list-of-values displays and reporting.
• DERIVE_EFFECTIVE — Governs whether a derived (computed) exchange relationship is effective for the currency.
• DERIVE_TYPE — Identifies the method by which a currency's conversion factor is derived.
• DERIVE_FACTOR — The numeric multiplier associated with the derivation type.
• DECIMAL_PRECISION — The number of decimal places used when rounding amounts in this currency.
• TEXT_CODE — A short code used for interface or display purposes.
• TRANS_CNT — A transaction counter often used to coordinate concurrent updates in OPM tables.
• DELETE_MARK — Soft-delete indicator; rows are typically flagged rather than physically removed.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard EBS who-did-what auditing.
• Concurrent program columns — REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE identify the concurrent request that last touched the row, supporting traceability of integration loads from Oracle Financials.

No separate surrogate (system-generated numeric) primary key is documented; the business key CURRENCY_CODE also serves as the primary key and unique index.

Common Use Cases and Queries

Because GL_CURR_MST is a reference hub, most usage involves joining it to reference a currency's description, precision, or derivation rules, or validating that a currency code supplied by an external system exists in GMF.

• Currency lookup for reporting — Resolving coded values to descriptions in order, billing, and contract reports:

SELECT c.currency_code, c.currency_desc, c.decimal_precision
FROM   gl_curr_mst c
WHERE  c.delete_mark = 0
ORDER BY c.currency_code;

• Validation of inbound currency codes — Before loading contracts or customer records, confirm the currency is defined:

SELECT COUNT(*)
FROM   gl_curr_mst
WHERE  currency_code = :p_currency_code
AND    delete_mark  = 0;

• Order and billing currency enrichment — Joining order headers or detail lines to obtain the currency description and rounding precision:

SELECT h.order_no, h.billing_currency, c.currency_desc
FROM   op_ordr_hdr h, gl_curr_mst c
WHERE  h.billing_currency = c.currency_code;

• Impact analysis — Determining which master and transactional tables reference a given currency before it is deactivated, using the documented foreign-key relationships.

Reports on exchange derivation (DERIVE_TYPE, DERIVE_FACTOR) and decimal precision are useful when reconciling amounts between GMF and Oracle Financials.

Related Objects

GL_CURR_MST is referenced by a broad set of GMF, OPM, and Process Ordering tables through the documented foreign keys. The most significant are:

• GL_PLCY_MST — references GL_CURR_MST via BASE_CURRENCY_CODE, defining the base currency of accounting policies.
• GL_ACCT_MAP — references CURRENCY_CODE, joining the account mapping to a specific currency.
• GL_SUBR_LED and GL_SUBR_TST — each reference GL_CURR_MST twice, through CURRENCY_BASE and CURRENCY_TRANS, capturing both base and transaction currencies in the subledger and test tables.
• OP_CNTR_HDR — references CONTRACT_CURRENCY and BASE_CURRENCY for OPM contracts.
• OP_CUST_MST and OP_CUST_MST_OPM — reference CUST_CURRENCY, tying each customer to a default currency.
• OP_ORDR_HDR and OP_ORDR_DTL — reference BILLING_CURRENCY (and BASE_CURRENCY on the detail), linking order documents to their currencies.
• OP_PRSL_HDR and OP_PRSL_DTL — reference BILLING_CURRENCY for proposals.
• OP_PRCE_MST — references CURRENCY_CODE for pricing definitions.
• PO_ORDR_HDR, PO_DIST_DTL, and PO_RECV_HDR — reference BILLING_CURRENCY, CURRENCY_BASE, CURRENCY_TRANS, and DEMURRAGE_CURRENCY across purchasing and receiving documents.
• PO_VEND_MST — references DEFAULT_CURRENCY, establishing the vendor's default currency.

These relationships confirm the hub-leaning classification: a single key table (GL_CURR_MST) feeds currency context to a wide circumference of transactional and master objects across Process Manufacturing Financials.