Search Results ap_other_period_types




Overview
Explore in AI Chat

Overview

AP_OTHER_PERIOD_TYPES is a Payables-owned reference table in the AP schema that stores period type definitions used by Oracle EBS Payables for recurring invoices, key indicators, and withholding tax processing. It defines the cadence and module context under which periodic Payables activities are scheduled, independent of the general ledger period calendar. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the AP schema with the object name AP.AP_OTHER_PERIOD_TYPES and carries a VALID status.

The documented primary key is AP_OTHER_PERIOD_TYPES_PK, defined over the columns PERIOD_TYPE and MODULE. The same two columns form the unique index AP_OTHER_PERIOD_TYPES_U1, making them the business-key candidates that distinguish one row from another. Heuristic Data Vault classification, mined from the foreign-key structure, identifies this object as standalone. In Data Vault modeling terms, AP_OTHER_PERIOD_TYPES is therefore best treated as a reference or hub-style entity rather than a link or satellite: it holds its own natural key (PERIOD_TYPE plus MODULE) and does not participate in an associative relationship with other hubs at the schema level.

Key Information Stored

The table contains 26 documented columns in the 12.2.2 physical schema. The most significant are:

  • PERIOD_TYPE — the period type identifier (for example, recurring invoice or withholding tax cadence); part of the composite primary key.
  • MODULE — the Payables sub-module or usage context that the period type belongs to; the second component of the primary key.
  • PERIODS_PER_YEAR — the number of periods this type generates in a year, governing scheduling frequency.
  • DESCRIPTION — the user-facing name or explanation of the period type.
  • CREATION_DATE, CREATED_BY — standard audit columns recording when and by whom the definition row was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield (DFF) columns that allow installations to extend the period type definition with site-specific attributes.
  • CONTEXT — the DFF context field that identifies which attribute structure is populated.

The surrogate primary key AP_OTHER_PERIOD_TYPES_PK is composite rather than a single sequence-generated identifier, and it collapses to precisely the two business-key columns PERIOD_TYPE and MODULE. No separate numeric surrogate is documented for this table.

Common Use Cases and Queries

Typical uses include validating which period types are available before creating recurring invoice templates, resolving withholding tax period definitions during payment processing, and building reporting models that join Payables periodic data back to its type definition. A representative lookup query follows:

SELECT period_type, module, periods_per_year, description
FROM   ap.ap_other_period_types
WHERE  module = :p_module
ORDER BY period_type;

Reporting extracts commonly join this table to recurring invoice and withholding tax source tables on the PERIOD_TYPE and MODULE composite key, using the PERIODS_PER_YEAR value to derive expected invoice counts per cycle. DFF attribute columns can be queried where installations have enabled a context, and audit columns support change-tracking extracts.

Related Objects

The metadata classifies AP_OTHER_PERIOD_TYPES as standalone, meaning no foreign keys are documented pointing out of or into it from the mined relationship data. Related objects are therefore engaged through the shared business key rather than enforced referential constraints:

  • AP_RECURRING_INVOICES and related recurring invoice definition tables — reference PERIOD_TYPE and MODULE to schedule invoice generation.
  • AP_WITHHOLDING_TAX_GROUPS and withholding tax period configuration — consume period type definitions for tax periodicity.
  • AP_KEY_INDICATORS — key indicator definitions that rely on the same period type vocabulary.
  • AP_OTHER_PERIOD_TYPES_PK / AP_OTHER_PERIOD_TYPES_U1 — the primary key and unique index that enforce uniqueness on PERIOD_TYPE and MODULE.
  • Payables concurrent programs that generate recurring invoices or withholding tax entries read this table at run time to resolve scheduling behavior.

Because the object is seeded and reference-oriented, changes should be limited to controlled setup or migration scripts, and any DFF context usage should be reviewed before upgrading between 12.1.1 and 12.2.2.