Results for “ap_vendor_key_ind_all”

28 results




Overview
Explore in AI Chat

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

Overview

AP_VENDOR_KEY_IND_ALL is a Payables (AP) module table in Oracle E-Business Suite, owned by the AP schema. As documented in the ETRM 12.2.2 physical schema, it stores compiled supplier information for the Key Indicators Report. Rather than acting as a transactional or master data table, it functions as a pre-aggregated reporting staging table: supplier attributes are summarized over a given accounting period and organization, allowing the Key Indicators Report to present vendor statistics without repeatedly scanning the large supplier and supplier site base tables.

The table carries 23 documented columns and is keyed by AP_VENDOR_KEY_IND_PK on PERIOD_NAME. A second unique index, AP_VENDOR_KEY_IND_U1, is defined on (PERIOD_NAME, ORG_ID), which is the true business-key candidate because it includes the operating unit context. From a Data Vault modeling perspective, the heuristic classification mined from the FK structure is standalone. AP_VENDOR_KEY_IND_ALL therefore exhibits no foreign-key dependencies in the documented metadata and behaves as a self-contained reporting summary rather than a hub, link, or satellite. This classification should be treated as a modeling suggestion rather than a formally declared constraint.

Key Information Stored

The most significant columns fall into three groups: period and organization context, vendor and site counts, and generic report buckets.

  • PERIOD_NAME — the accounting period label for which vendor indicators were compiled; part of the primary key and the unique business key.
  • ORG_ID — the operating unit (organization) identifier; combined with PERIOD_NAME in AP_VENDOR_KEY_IND_U1, it scopes each summary row to a specific operating unit.
  • NUM_VENDORS — total supplier count for the period and organization.
  • NUM_VENDOR_SITES and NUM_SITES — counts of supplier sites and related site records.
  • NUM_INACTIVE_VENDORS — suppliers flagged as inactive, useful for data hygiene and supplier-base monitoring.
  • NUM_ONE_TIME_VENDORS — one-time suppliers, a common metric for expense and compliance analysis.
  • NUM_1099_VENDORS — suppliers designated for 1099 reporting, relevant for US tax reporting.
  • NUM_VENDORS_HELD — suppliers on payment hold, supporting risk and control reporting.
  • NUM_VENDORS_UPDATED and NUM_SITES_UPDATED — counts of suppliers and sites changed during the period, indicating maintenance activity volume.
  • VALUE1 through VALUE10 — ten generic, report-defined columns reserved for additional key-indicator metrics or groupings not covered by the named numeric columns.
  • LAST_UPDATE_DATE and LAST_UPDATED_BY — standard Oracle EBS audit columns recording when and by whom the summary row was last refreshed or inserted.

The surrogate primary key PERIOD_NAME identified in the metadata is better understood as a period identifier in practice; the composite unique key on PERIOD_NAME and ORG_ID is the business key that determines row uniqueness.

Common Use Cases and Queries

The primary use case is the Payables Key Indicators Report, which reads compiled rows rather than live supplier data. Common queries include period-over-period trends, operating-unit comparisons, and audit checks on update activity.

  • Trend analysis of vendor population size and churn by period: SELECT PERIOD_NAME, ORG_ID, NUM_VENDORS, NUM_INACTIVE_VENDORS FROM AP.AP_VENDOR_KEY_IND_ALL ORDER BY ORG_ID, PERIOD_NAME;
  • 1099 and one-time vendor exposure for a given period: SELECT PERIOD_NAME, NUM_1099_VENDORS, NUM_ONE_TIME_VENDORS FROM AP.AP_VENDOR_KEY_IND_ALL WHERE ORG_ID = :org_id;
  • Detection of periods with heavy supplier maintenance: SELECT PERIOD_NAME, NUM_VENDORS_UPDATED, NUM_SITES_UPDATED FROM AP.AP_VENDOR_KEY_IND_ALL;
  • Inspection of generic metric columns: SELECT VALUE1, VALUE2, ... VALUE10 FROM AP.AP_VENDOR_KEY_IND_ALL WHERE PERIOD_NAME = :period_name AND ORG_ID = :org_id;
  • Freshness check: SELECT MAX(LAST_UPDATE_DATE), MAX(LAST_UPDATED_BY) FROM AP.AP_VENDOR_KEY_IND_ALL.

Because the table is a compiled summary, it is typically populated by the Key Indicators concurrent program rather than through direct DML. Analysts should join to period and operating unit reference views only when labels are required, since ORG_ID and PERIOD_NAME are already denormalized into the table.

Related Objects

The documented metadata classifies AP_VENDOR_KEY_IND_ALL as standalone with no foreign-key relationships. The most significant related objects are therefore logical rather than referential.

  • AP_SUPPLIERS — source of the core supplier population counted by NUM_VENDORS, NUM_INACTIVE_VENDORS, and NUM_ONE_TIME_VENDORS.
  • AP_SUPPLIER_SITES_ALL — source of site-level counts (NUM_VENDOR_SITES, NUM_SITES, NUM_SITES_UPDATED); correlates to AP_VENDOR_KEY_IND_ALL on ORG_ID.
  • AP_SUPPLIER_SITES_ALL_M — site distribution and assignment data used when computing site-derived indicators.
  • AP_CHECKS_ALL — payment activity underlying hold and 1099 metrics.
  • HR_OPERATING_UNITS — resolves ORG_ID to an operating unit name for report labels.
  • GL_PERIODS / AP_PERIODS — resolve PERIOD_NAME to period start and end dates for time-series reporting.
  • FND_USER — resolves LAST_UPDATED_BY to a user name for audit reporting.
  • AP_VENDOR_KEY_IND_PK and AP_VENDOR_KEY_IND_U1 — the primary key and unique index objects that enforce row identity on (PERIOD_NAME) and (PERIOD_NAME, ORG_ID) respectively.

These relationships are logical rather than enforced by database constraints, consistent with the standalone classification reported in the ETRM metadata.