Results for “program_type”

50+ results




Overview
Explore in AI Chat

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

Overview

AP_PAYMENT_PROGRAMS is a Payables-owned reference table that stores the payment programs available for defining payment formats in Oracle E-Business Suite 12.1.1 and 12.2.2. Although it is created and maintained by the Payables (AP) product, the table functions as a shared cross-product registry: Receivables, Banks, and the Brazilian localizations (JL_BR) all point to the same rows to designate the concurrent programs that print, transmit, build, or format payment and receipt output. Each row identifies a specific program and classifies the program type, allowing Oracle EBS to resolve the correct executable when a payment format, receipt method, or bank branch is used.

From a Data Vault modeling perspective, the mined foreign-key structure classifies AP_PAYMENT_PROGRAMS as a hub. This is a modeling suggestion rather than a physical design: the table supplies a stable, unique business key (the program) that numerous other tables reference. In practice, it behaves as a low-volume, slowly-changing reference/lookup table rather than a transactional entity.

Key Information Stored

The documented physical schema contains 11 columns. The columns of greatest operational importance are:

The surrogate primary key is PROGRAM_ID; the business-key candidates are PROGRAM_ID/FRIENDLY_NAME qualified by ZD_EDITION_NAME. Note that in 12.2, any query against this table should generally be edition-aware.

Common Use Cases and Queries

Typical use cases include identifying which program is assigned to a payment format or receipt method, listing all transmission-capable programs, and resolving a foreign key back to a friendly name for reporting. A representative lookup is:

  • Resolving a bank branch's printing or transmission program:
    SELECT p.friendly_name, p.program_name, p.program_type FROM ap.ap_payment_programs p, ap.ap_bank_branches b WHERE b.printing_program_id = p.program_id AND b.branch_id = :branch;
  • Listing transmission-enabled programs:
    SELECT program_id, friendly_name FROM ap.ap_payment_programs WHERE transmissions_enabled = 'Y';
  • Finding the format program referenced by a Brazilian receipt-method account extension:
    SELECT p.friendly_name FROM ap.ap_payment_programs p, jl_br_ar_rec_met_accts_ext_all j WHERE j.factor_format_pgm_id = p.program_id;

Related Objects

The most significant dependents, joined on the documented foreign key columns, are:

Because AP_PAYMENT_PROGRAMS is a hub, its PROGRAM_ID is the single join column that provisions program resolution across all of these Payables, Receivables, Bank, and localization objects.