Search Results ap_income_tax_regions_u2

Overview

AP.AP_INCOME_TAX_REGIONS is a reference (seed) table in the Oracle Payables module that stores the income tax regions used to record payment information for 1099 suppliers when an organization participates in the Internal Revenue Service Combined Filing Program (CFP). Each region represents a U.S. state, the District of Columbia, or certain U.S. territories, and carries the region code, reporting limit, and reporting limit method that Payables uses to determine whether cumulative payments to a 1099 supplier have exceeded that region's reporting threshold. Payables predefines all U.S. states, territories, and the CFP region codes, but customers may define additional regions or assign codes to existing ones. The table corresponds to the Income Tax Regions window and resides in the APPS_TS_SEED tablespace, reflecting its role as seeded, low-volatility reference data.

From a dimensional modeling perspective, the mined relationship classification is hub-leaning: AP_INCOME_TAX_REGIONS behaves as a durable business entity whose primary key is referenced by transactional and configuration tables rather than being an event or association record. This suggests it is best modeled as a hub in a Data Vault design, with descriptive attributes (reporting limits, control totals, region names) carried on an attached satellite.

Key Information Stored

The table's primary key is AP_INCOME_TAX_REGIONS_PK on REGION_SHORT_NAME, a 10-character column that serves as the abbreviated region identifier used on 1099 supplier sites and defaulted onto invoice distributions. Two unique indexes act as business-key candidates: AP_INCOME_TAX_REGIONS_U1 on REGION_SHORT_NAME and AP_INCOME_TAX_REGIONS_U2 on (REGION_CODE, REGION_SHORT_NAME), which enforces uniqueness of the Combined Filing Program region code within each region. The most significant columns include:

• REGION_SHORT_NAME — abbreviated region name; primary key and supplier-site reference.
• REGION_LONG_NAME — descriptive name of the income tax region.
• REGION_CODE — numeric CFP region code for participating regions.
• REPORTING_LIMIT — minimum payment amount that triggers reporting for the region.
• REPORTING_LIMIT_METHOD_CODE — method used to evaluate whether payments exceed the limit.
• NUM_OF_PAYEES — count of payees associated with the region.
• CONTROL_TOTAL1 through CONTROL_TOTAL10, CONTROL_TOTAL13, CONTROL_TOTAL13E, CONTROL_TOTAL14, CONTROL_TOTAL15A, CONTROL_TOTAL15B — accumulated control totals used for 1099 CFP reporting balancing.
• ACTIVE_DATE / INACTIVE_DATE — effective dating for the region record.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard EBS audit columns.

Common Use Cases and Queries

Typical usage includes validating 1099 supplier site addresses, resolving the default region assigned to invoice distribution lines, and reporting on CFP reporting limits and accumulated control totals. A common lookup joins the region to distributions to confirm classification:

• Region lookup: SELECT region_short_name, region_long_name, region_code, reporting_limit FROM ap.ap_income_tax_regions WHERE region_short_name = :region;
• Distribution-to-region join: SELECT d.invoice_id, d.income_tax_region, r.region_long_name FROM ap.ap_invoice_distributions_all d, ap.ap_income_tax_regions r WHERE d.income_tax_region = r.region_short_name;
• Default region check: query AP_SYSTEM_PARAMETERS_ALL for the system-level INCOME_TAX_REGION and validate it against this table.
• CFP reporting exception: list regions where accumulated control totals exceed REPORTING_LIMIT.

Because the table is seed data, queries against it are typically read-only lookup joins rather than transactional writes.

Related Objects

The foreign-key relationships define the principal dependents of this table, with INCOME_TAX_REGION columns joining to REGION_SHORT_NAME:

• AP.AP_INVOICE_DISTRIBUTIONS_ALL — INCOME_TAX_REGION references AP_INCOME_TAX_REGIONS.REGION_SHORT_NAME; assigns a region to each invoice distribution line.
• AP.AP_SYSTEM_PARAMETERS_ALL — INCOME_TAX_REGION holds the system-level default region.
• AP.AP_SUPPLIER_SITES_ALL — supplier site addresses carry the region used to derive distribution defaults.
• AP.AP_SUPPLIERS — 1099 supplier records whose reporting depends on region limits.
• Payables Income Tax Regions window (form) — the maintenance UI mapped to this table via FND Design Data SQLAP.AP_INCOME_TAX_REGIONS.
• 1099 Combined Filing Program reports and standard Payables reporting concurrent programs that read region codes and control totals.

Together these objects govern how 1099 payment data is classified, thresholded, and reported under the Combined Filing Program.