Results for “gl_rate_typ”

50+ results




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

Overview

GL_RATE_TYP is a reference (lookup) table owned by the GMF schema and delivered as part of the Oracle Process Manufacturing Financials module. It stores exchange rate classifications — the business categories such as daily, average, and balance sheet — that determine how currency conversion rates are selected, applied, and interpreted during foreign currency translation and revaluation in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row defines a distinct rate type that downstream transactions, tax regimes, and accounting programs can reference by code.

The table is not transactional in nature; it is a low-volume, stable classification list. From a Data Vault modeling perspective, the mined relationship structure classifies GL_RATE_TYP as hub-leaning: it holds a durable, unique business key (the rate type code) that is referenced by multiple dependent objects, which is the classic profile of a hub rather than a link or satellite. This classification is a heuristic modeling suggestion, not a physical attribute of the EBS table itself.

Key Information Stored

The physical schema documents 15 columns. The most significant are:

Note that RATE_TYPE_CODE serves both as the surrogate primary key (per GL_RATE_TYP_PK) and as the business key; no separate numeric surrogate is documented.

Common Use Cases and Queries

Report and interface development against GL_RATE_TYP is typically limited to lookup and validation. A representative pattern joins the table to tax setup objects to describe the conversion basis applied to a tax regime or tax line:

  • Enumerating available rate types for a value-set or LOV: SELECT RATE_TYPE_CODE, RATE_TYPE_DESC FROM GMF.GL_RATE_TYP WHERE DELETE_MARK = 0 ORDER BY RATE_TYPE_CODE;
  • Resolving the description for tax regimes: SELECT r.REGIME_CODE, t.RATE_TYPE_DESC FROM ZX_REGIMES_B r, GMF.GL_RATE_TYP t WHERE r.EXCHANGE_RATE_TYPE = t.RATE_TYPE_CODE;
  • Resolving the description for tax definitions: SELECT t.TAX_ID, g.RATE_TYPE_DESC FROM ZX_TAXES_B t, GMF.GL_RATE_TYP g WHERE t.EXCHANGE_RATE_TYPE = g.RATE_TYPE_CODE;

Filtering on DELETE_MARK = 0 is essential in any production query, since obsolete classifications are retained in the table and excluded only through this flag. Analysts performing currency translation reconciliations also use this table as the reference list of valid rate-type classifications when comparing general ledger translation results against expected daily, average, or balance-sheet methods.

Related Objects

GL_RATE_TYP is referenced through foreign keys by tax-related setup entities, which treat the rate type code as a descriptive classification attribute:

  • ZX_REGIMES_B — join on ZX_REGIMES_B.EXCHANGE_RATE_TYPE = GL_RATE_TYP.RATE_TYPE_CODE; identifies the exchange rate classification associated with a tax regime.
  • ZX_TAXES_B — join on ZX_TAXES_B.EXCHANGE_RATE_TYPE = GL_RATE_TYP.RATE_TYPE_CODE; identifies the rate classification applied to a tax definition.

Indirectly, reporting on these relationships reaches the corresponding translation and revaluation programs that consume exchange rate types, and value sets drawn from RATE_TYPE_CODE. Any custom extension that stores a rate type should preserve referential integrity against GL_RATE_TYP_PK to remain consistent with the seeded tax configuration data.