Results for “ap_currency_group”

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

Overview

AP_CURRENCY_GROUP is a Payables module table owned by the AP schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It records the set of payment currencies associated with either a Payment Process Request Template or a specific Payment Process Request. Because a single template or request may be scoped to one or more disbursement currencies, this table acts as the child store that enumerates those currencies and ties each row back to its parent template or selection criteria record.

Functionally, AP_CURRENCY_GROUP defines the currency filter applied during payment processing. When a Payment Process Request is submitted with currency restrictions, the selected currencies are persisted here and later consumed by the payment build and formatting programs to determine which invoices are eligible for payment and how payments are grouped.

Following the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link table. It sits between the payment template and the invoice selection criteria, carrying the currency dimension that relates those entities. Analysts building a dimensional or Data Vault representation should treat this as a relationship/associative structure rather than a hub or satellite.

Key Information Stored

The documented physical schema contains nine columns. The most significant include:

• CURRENCY_GROUP_ID — the surrogate primary key, enforced by AP_CURRENCY_GROUP_PK and also defined by unique index AP_CURRENCY_GROUP_U1. This is the single documented business-key candidate and the primary identifier for each currency grouping row.
• CURRENCY_CODE — the ISO currency code specifying one payment currency included in the group.
• TEMPLATE_ID — foreign key to AP_PAYMENT_TEMPLATES; populated when the currency group belongs to a Payment Process Request Template.
• CHECKRUN_ID — foreign key to AP_INV_SELECTION_CRITERIA_ALL; populated when the currency group belongs to a specific Payment Process Request.
• CREATION_DATE, CREATED_BY — standard WHO audit columns capturing row creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the most recent change.

Because either TEMPLATE_ID or CHECKRUN_ID is populated depending on context, the table supports both the template-driven and request-driven payment flows from a single structure.

Common Use Cases and Queries

Typical usage centers on determining which currencies are configured for a given payment template or active payment request, and auditing currency selections over time.

• List currencies for a template:

  SELECT CURRENCY_CODE FROM AP.AP_CURRENCY_GROUP WHERE TEMPLATE_ID = :template_id;

• List currencies for an active payment request:

  SELECT CURRENCY_CODE FROM AP.AP_CURRENCY_GROUP WHERE CHECKRUN_ID = :checkrun_id;

• Join to the template to review configuration:

  SELECT t.TEMPLATE_NAME, c.CURRENCY_CODE FROM AP.AP_CURRENCY_GROUP c JOIN AP.AP_PAYMENT_TEMPLATES t ON c.TEMPLATE_ID = t.TEMPLATE_ID;

• Join to selection criteria for request-level reporting:

  SELECT s.CHECKRUN_NAME, c.CURRENCY_CODE FROM AP.AP_CURRENCY_GROUP c JOIN AP.AP_INV_SELECTION_CRITERIA_ALL s ON c.CHECKRUN_ID = s.CHECKRUN_ID;

Reporting scenarios include currency distribution analysis across payment runs, validating that templates carry the expected currency sets, and reconciling payment requests against their intended disbursement currencies.

Related Objects

The following objects are most closely related through the documented key structure:

• AP_PAYMENT_TEMPLATES — parent for template-based currency groups, joined on TEMPLATE_ID.
• AP_INV_SELECTION_CRITERIA_ALL — parent for request-based currency groups, joined on CHECKRUN_ID.
• AP_CURRENCY_GROUP_PK / AP_CURRENCY_GROUP_U1 — primary key and unique index on CURRENCY_GROUP_ID.
• Payment Process Request submission and payment build programs, which consume the currency set recorded here.

Together these relationships establish AP_CURRENCY_GROUP as the associative link between payment configuration and the currencies used during disbursement.