Search Results ap_currency_group




Overview
Explore in AI Chat

Overview

The AP_CURRENCY_GROUP table is a core data object within the Oracle E-Business Suite Payables (AP) module, specifically for releases 12.1.1 and 12.2.2. It serves as a configuration and runtime table that defines the set of payment currencies associated with either a Payment Process Request Template or a specific Payment Process Request (Check Run). This table is fundamental to the Payment Process Manager, which automates the creation of payments. By storing permitted currency groupings, it enables organizations to process payments in multiple currencies from a single, controlled template or request, ensuring that payment batches adhere to predefined financial and operational rules.

Key Information Stored

The table's primary function is to link a currency group identifier to either a template or a payment process request. While the full column list is not detailed in the provided metadata, the structure can be inferred from the primary and foreign key relationships. The critical columns include CURRENCY_GROUP_ID, which serves as the primary key for the table. The TEMPLATE_ID column is a foreign key linking to the AP_PAYMENT_TEMPLATES table, identifying the template that owns this currency group. The CHECKRUN_ID column is a foreign key linking to the AP_INV_SELECTION_CRITERIA_ALL table, associating the currency group with a specific Payment Process Request. Additional columns, typical for such a table, would store the actual currency code (e.g., CURRENCY_CODE) and potentially sequence or control information.

Common Use Cases and Queries

The primary use case is configuring and auditing multi-currency payment setups. An accounts payable manager can query which currencies are enabled for a specific payment template to validate setup before submission. During troubleshooting, a support analyst might trace the currencies used in a completed payment batch. Common SQL patterns include joining to related template or request tables. For example, to list all currencies for a specific template named 'US_DISBURSEMENTS':

  • SELECT acg.currency_code, apt.template_name FROM ap_currency_group acg, ap_payment_templates apt WHERE acg.template_id = apt.template_id AND apt.template_name = 'US_DISBURSEMENTS';

Another critical query identifies the currency configuration for a specific payment process request ID to understand the payment batch's scope.

Related Objects

The AP_CURRENCY_GROUP table has integral relationships with other key Payables tables, as defined by its foreign keys. Its primary relationship is with AP_PAYMENT_TEMPLATES via the TEMPLATE_ID column, which stores the master definition of reusable payment processing rules. It also links to AP_INV_SELECTION_CRITERIA_ALL via the CHECKRUN_ID column; this table holds the specific parameters and runtime data for an individual Payment Process Request. The table AP_CURRENCY_GROUP is central to the payment setup workflow, sitting between the template definition and the execution of a payment batch. Direct programmatic interaction is typically managed through the Payment Process Manager's standard user interface and underlying APIs rather than direct DML.