Results for “pay_monetary_units”

50+ results




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

Overview

PAY_MONETARY_UNITS is a Payroll (PAY) module reference table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the valid denominations — coins and monetary units — associated with currencies, allowing payroll and coin analysis processes to break down amounts into physical or logical monetary components. Each row defines a specific denomination for a currency within a given business group and legislation context, along with its relative value against the currency's base unit.

The table is classified as VALID and participates in the standard EBS audit column pattern (WHO columns such as LAST_UPDATE_DATE, CREATED_BY). Its primary key, PAY_MONETARY_UNITS_PK, is defined on MONETARY_UNIT_ID and, in the 12.2.2 schema, also includes ZD_EDITION_NAME, reflecting the editioning infrastructure introduced in later EBS releases.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification: MONETARY_UNIT_ID acts as a stable business key referenced by dependent tables, while the descriptive attributes (names, values, comments) behave as satellite-like properties. This is a modeling suggestion, not a documented classification.

Key Information Stored

The table contains 13 documented columns. The most significant are:

  • MONETARY_UNIT_ID — surrogate primary key and business key candidate (PAY_MONETARY_UNITS_PK); referenced by downstream tables.
  • CURRENCY_CODE — the currency to which the denomination belongs.
  • BUSINESS_GROUP_ID — the business group owning the denomination, supporting multi-tenant partitioning of reference data within the HR schema.
  • LEGISLATION_CODE — the legislative context governing the denomination's validity.
  • MONETARY_UNIT_NAME — the descriptive label for the denomination.
  • RELATIVE_VALUE — the numeric value of the denomination relative to the currency's base unit; essential for coin analysis and cash breakdown.
  • COMMENTS — free-text annotations.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
  • ZD_EDITION_NAME — editioning column present in the 12.2.2 physical schema, part of the unique key.

The unique index PAY_MONETARY_UNITS_PK on (MONETARY_UNIT_ID, ZD_EDITION_NAME) is the documented business-key candidate; SYS_IL0000042894C00012$$ is a system-managed LOB index, not a business key.

Common Use Cases and Queries

Payroll and coin analysis reporting is the principal consumer of this table. Typical scenarios include enumerating valid denominations per currency for cash-requisition reporting, and joining to coin analysis element definitions to validate monetary breakdowns.

A standard lookup pattern:

SELECT mu.monetary_unit_id, mu.monetary_unit_name, mu.relative_value
FROM   pay_monetary_units mu
WHERE  mu.currency_code = :p_currency
AND    mu.business_group_id = :p_bg_id
ORDER BY mu.relative_value;

Joining to coin analysis elements for validation:

SELECT cae.coin_anal_element_id, mu.monetary_unit_name, mu.relative_value
FROM   pay_coin_anal_elements cae
JOIN   pay_monetary_units   mu
       ON mu.monetary_unit_id = cae.monetary_unit_id;

Reporting use cases include currency-denomination catalogs, legislative denomination audits, and reconciliation of amounts into available denominations using RELATIVE_VALUE.

Related Objects

  • PAY_COIN_ANAL_ELEMENTS — references PAY_MONETARY_UNITS via MONETARY_UNIT_ID; primary dependent object for coin analysis.
  • HR_S_MONETARY_UNITS — secondary referencing table via MONETARY_UNIT_ID, likely a secure/denormalized view or shadow object.
  • PAY_MONETARY_UNITS_PK — the primary key index, driving unique lookups.
  • AP/AR and GL currency reference tables (e.g., FND_CURRENCIES) — logically related through CURRENCY_CODE for currency attributes.

Because the metadata documents only these explicit relationships, integrators should treat PAY_MONETARY_UNITS as an upstream reference hub with PAY_COIN_ANAL_ELEMENTS as its dominant child table in payroll coin analysis logic.