Search Results region_short_name

Overview

AP_INCOME_TAX_REGIONS is a Payables (AP) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores income tax region information used for supplier tax reporting. The table defines the set of regions that can be assigned to invoices and system-level Payables configurations so that taxable payments to suppliers are aggregated and reported against the correct regional tax authority. It is one of the supporting setup tables that underpin 1099-style and other income tax reporting processes within Payables, and it is owned by the AP schema with a status of VALID.

From a Data Vault modeling perspective, the mined foreign key structure classifies this object as hub-leaning. This is a modeling suggestion rather than a physical property: the table behaves as a durable list of business entities (regions), keyed by a stable business identifier, with the dependent descriptive and control attributes that would conventionally be split into a satellite. In the delivered EBS schema it is a conventional relational table with both a primary key and multiple unique indexes.

Key Information Stored

The table contains 28 documented columns. The most significant are the identifying and control attributes used by reporting and by downstream invoice processing.

• REGION_SHORT_NAME — the primary key column (AP_INCOME_TAX_REGIONS_PK) and the value carried into transaction and setup tables. It is also the leading column of unique index AP_INCOME_TAX_REGIONS_U1 and the trailing column of AP_INCOME_TAX_REGIONS_U2 (REGION_CODE, REGION_SHORT_NAME).
• REGION_CODE — the code associated with the region; paired with REGION_SHORT_NAME in unique index U2, making the pair a business-key candidate.
• REGION_LONG_NAME — the descriptive name of the region as presented to users.
• REPORTING_LIMIT and REPORTING_LIMIT_METHOD_CODE — the threshold amount and the method used to apply it when determining reportable payments.
• NUM_OF_PAYEES — the number of payees associated with the region for reporting purposes.
• CONTROL_TOTAL1 through CONTROL_TOTAL10, CONTROL_TOTAL13, CONTROL_TOTAL13E, CONTROL_TOTAL14, CONTROL_TOTAL15A, CONTROL_TOTAL15B — a set of reporting control total columns used to accumulate and reconcile regional tax reporting figures.
• ACTIVE_DATE and INACTIVE_DATE — effective dating that governs when a region is valid for use.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard EBS WHO-column audit attributes.

The primary key is the surrogate/business identifier REGION_SHORT_NAME; the unique indexes U1 and U2 identify REGION_SHORT_NAME and the REGION_CODE/REGION_SHORT_NAME combination as business-key candidates.

Common Use Cases and Queries

Typical uses include validating the region assigned to an invoice distribution, populating region selection lists in Payables setup, and aggregating supplier payments by region for tax reporting.

• Resolving a region description for invoice distributions: SELECT d.invoice_id, d.income_tax_region, r.region_long_name FROM ap_invoice_distributions_all d, ap_income_tax_regions r WHERE d.income_tax_region = r.region_short_name;
• Listing active regions effective on a given date: SELECT region_short_name, region_code, region_long_name FROM ap_income_tax_regions WHERE active_date <= SYSDATE AND (inactive_date IS NULL OR inactive_date > SYSDATE);
• Checking the default region configured at the system level via AP_SYSTEM_PARAMETERS_ALL.INCOME_TAX_REGION.
• Reconciling reporting control totals and reporting limits for a region before period-end tax filing.
• Identifying orphaned or invalid region values on distributions by outer-joining to AP_INCOME_TAX_REGIONS.

Related Objects

The following objects reference or depend on AP_INCOME_TAX_REGIONS through documented foreign keys or shared key columns.

• AP_INVOICE_DISTRIBUTIONS_ALL — references AP_INCOME_TAX_REGIONS via the column INCOME_TAX_REGION (joined to REGION_SHORT_NAME).
• AP_SYSTEM_PARAMETERS_ALL — references AP_INCOME_TAX_REGIONS via the column INCOME_TAX_REGION (joined to REGION_SHORT_NAME).
• AP_INCOME_TAX_REGIONS_PK — the primary key constraint on REGION_SHORT_NAME.
• AP_INCOME_TAX_REGIONS_U1 — unique index on REGION_SHORT_NAME.
• AP_INCOME_TAX_REGIONS_U2 — unique index on REGION_CODE and REGION_SHORT_NAME.
• Payables supplier and invoice reporting processes that read the control total columns and reporting limits to produce regional tax output.