Search Results ap_awt_groups_pk

Overview

The AP_AWT_GROUPS table is a core master data table within the Oracle E-Business Suite Payables (AP) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for defining withholding tax groups. An Automatic Withholding Tax (AWT) group is a logical collection of one or more withholding tax codes, allowing users to apply multiple tax rates to a single invoice or expense report line efficiently. This table is fundamental for configuring and managing the complex withholding tax requirements that organizations must adhere to in various global jurisdictions.

Key Information Stored

The primary identifier for a withholding tax group is the GROUP_ID, which is the table's primary key (AP_AWT_GROUPS_PK). While the provided metadata does not list all columns, based on standard EBS functionality, this table typically stores descriptive and control information for each group. Common columns include the group's name (e.g., GROUP_NAME), a description, the associated legal entity or operating unit (ORG_ID), and flags to control its active status and default behavior. The GROUP_ID is the critical foreign key column referenced extensively throughout the Payables schema to link transactions and master data to a specific tax group.

Common Use Cases and Queries

The primary use case is the setup and assignment of withholding tax groups to suppliers, invoices, and expense reports. Administrators create groups via the "Withholding Tax Groups" form, which writes records to this table. Common reporting and validation queries involve joining AP_AWT_GROUPS to related transaction tables. For instance, to list all invoices with their assigned withholding tax groups, a query would join AP_INVOICES_ALL to AP_AWT_GROUPS on INVOICES_ALL.AWT_GROUP_ID = GROUPS.GROUP_ID. Another typical query audits the default AWT group assigned at the system level by joining AP_SYSTEM_PARAMETERS_ALL to this table on DEFAULT_AWT_GROUP_ID = GROUP_ID. Troubleshooting often involves verifying if a specific GROUP_ID is active and correctly linked in supplier sites.

Related Objects

As indicated by the foreign key relationships, AP_AWT_GROUPS is a pivotal table referenced by numerous key Payables objects. Its GROUP_ID column is linked to:

• Transaction Headers and Lines: AP_INVOICES_ALL, AP_EXPENSE_REPORT_HEADERS_ALL, AP_EXPENSE_REPORT_LINES_ALL, and AP_RECURRING_PAYMENTS_ALL.
• Transaction Distributions: AP_INVOICE_DISTRIBUTIONS_ALL (for both current and origin group).
• Master Data: AP_SUPPLIERS for assigning a default group to a supplier.
• Tax Definitions and Temporary Data: AP_AWT_GROUP_TAXES_ALL (which defines the specific tax codes within the group) and AP_AWT_TEMP_DISTRIBUTIONS_ALL.
• System Configuration: AP_SYSTEM_PARAMETERS_ALL, which holds a default group for the operating unit.

This extensive integration underscores the table's critical role in the AWT processing flow.