Search Results show_sequence_flag




Overview
Explore in AI Chat

Overview

AR_BPA_TEMPLATES_B is a Receivables (AR) base table that stores the template definitions used by the Oracle Bill Presentment Architecture (BPA). Introduced in Release 11i and still valid in Oracle EBS 12.1.1 and 12.2.2, the table defines the presentment templates that control how customer transactions, invoices, and credit memos are rendered for online and printed bill viewing. Each row represents a single bill presentment template, including its layout geometry, display behavior flags, tax presentation rules, and print characteristics.

In Data Vault modeling terms, the FK structure classifies this table as hub-leaning. It is the central reference point for template identity: downstream child tables (AR_BPA_TEMPLATE_FIELDS, AR_BPA_TEMPLATE_FILES) and the transaction table RA_CUSTOMER_TRX_ALL all point back to it through TEMPLATE_ID, and it in turn references AR_BPA_PAGE_SETUPS_B and PQH_REF_TEMPLATES. This makes it a natural hub candidate for template identity, with the descriptive attributes behaving as satellite payload.

Key Information Stored

The surrogate primary key is TEMPLATE_ID (enforced by AR_BPA_TEMPLATES_B_PK, with a supporting unique index SYS_C0098705). The business-key candidate documented for 12.2.2 is the composite unique index AR_BPA_TEMPLATES_B_U1 on (TEMPLATE_ID, ZD_EDITION_NAME), reflecting the edition-aware data model. The most operationally significant columns include:

Common Use Cases and Queries

Typical usage centers on resolving which template applies to a transaction, auditing template configuration, and reporting on layout attributes. A common join pattern links a transaction to its template:

  • Resolving templates per transaction: SELECT t.trx_number, t.bill_template_id, b.template_type FROM ra_customer_trx_all t JOIN ar_bpa_templates_b b ON b.template_id = t.bill_template_id.
  • Identifying seeded versus user-defined templates: SELECT template_id, template_type, seeded_flag FROM ar_bpa_templates_b WHERE seeded_flag = 'Y'.
  • Listing field composition per template by joining AR_BPA_TEMPLATE_FIELDS on TEMPLATE_ID.
  • Determining page geometry for print layouts via join to AR_BPA_PAGE_SETUPS_B on PAGE_SETUP_ID.

These queries support bill presentment troubleshooting, template migration between environments, and configuration audits during upgrades.

Related Objects

The following objects have the most significant documented relationships with AR_BPA_TEMPLATES_B:

  • AR_BPA_PAGE_SETUPS_B — referenced via AR_BPA_TEMPLATES_B.PAGE_SETUP_ID.
  • PQH_REF_TEMPLATES — referenced via AR_BPA_TEMPLATES_B.REF_TEMPLATE_ID.
  • AR_BPA_TEMPLATE_FIELDS — references this table via TEMPLATE_ID, holding field-level template content.
  • AR_BPA_TEMPLATE_FILES — references this table via TEMPLATE_ID, storing associated template files.
  • RA_CUSTOMER_TRX_ALL — references this table via BILL_TEMPLATE_ID, tying transactions to their presentment template.

Together these objects form the BPA template subsystem within Receivables.