Search Results ar_bpa_area_items_u2

Overview

The AR.AR_BPA_AREA_ITEMS table is a transactional data object within the Oracle E-Business Suite Receivables (AR) module. It stores the selected content items for each template defined in Bill Presentment Architecture (BPA). Content items are chosen by users through the shuttle boxes on the Select Content and Layout and Select Content pages, and this table persists those choices by linking each content item to its corresponding template. In effect, the table materializes the layout composition of a BPA template: which items appear, where they are placed, and in what order they are rendered.

From a Data Vault modeling perspective, the table is heuristically classified as standalone — it is not a pure hub, link, or satellite, but behaves as an associative detail table that records template-to-item assignments with ordering and placement attributes. The presence of standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) confirms it is maintained transactionally, while the ZD_EDITION_NAME column in the 12.2.2 physical schema reflects the edition-based redefinition (EBR) architecture introduced with Online Patching. The storage details identify APPS_TS_TX_DATA as the tablespace, with unique indexes residing in APPS_TS_TX_IDX.

Key Information Stored

Each row in AR_BPA_AREA_ITEMS represents one content item assigned to a BPA template. The most significant columns are:

• AREA_ITEM_ID — the surrogate primary key (NUMBER(15)), uniquely identifying each area item row and backing the AR_BPA_AREA_ITEMS_PK constraint.
• TEMPLATE_ID — foreign key to AR_BPA_TEMPLATES_B, identifying the template to which the content item belongs.
• ITEM_ID — foreign key to AR_BPA_ITEMS_B, identifying the specific content item displayed.
• PARENT_AREA_CODE — indicates which content area was split to form the new content area, supporting hierarchical layout definitions.
• DISPLAY_LEVEL — identifies the page level at which the data is displayed.
• DISPLAY_SEQUENCE — the order in which contents are rendered within the template.
• SECONDARY_APP_ID — supplementary application identifier for the data source.
• DATA_SOURCE_ID — identifies the data source of the area item.
• FLEXFIELD_ITEM_FLAG — indicates whether the item is a flexfield item.
• ZD_EDITION_NAME — the edition name supporting Online Patching in 12.2.2.

Two unique indexes document business-key candidates. AR_BPA_AREA_ITEMS_U1 covers (TEMPLATE_ID, PARENT_AREA_CODE, DISPLAY_LEVEL, ITEM_ID, ZD_EDITION_NAME), enforcing that a given item appears only once per template, area split, and display level. AR_BPA_AREA_ITEMS_U2 covers (AREA_ITEM_ID, ZD_EDITION_NAME), which corresponds to the surrogate key extended for editioning. The user's search term "ar_bpa_area_items_u2" refers precisely to this unique index.

Common Use Cases and Queries

The table is primarily queried when diagnosing BPA template layouts, reproducing the exact content composition a customer sees on a bill, or migrating template definitions between environments. A typical query lists all items for a template in display order:

• SELECT area_item_id, template_id, item_id, display_sequence, display_level FROM ar.ar_bpa_area_items WHERE template_id = :template_id ORDER BY display_sequence;
• Joining to AR_BPA_ITEMS_B to resolve item names for reporting: SELECT a.area_item_id, i.item_name FROM ar.ar_bpa_area_items a, ar.ar_bpa_items_b i WHERE a.item_id = i.item_id AND a.template_id = :template_id;
• Detecting duplicate or conflicting assignments by grouping on template_id, parent_area_code, display_level, and item_id.
• Validating editioned data in 12.2.2 by filtering on ZD_EDITION_NAME.

Because the table is transactional, reporting should account for WHO columns when auditing changes or preparing migrations between development, test, and production instances.

Related Objects

The most significant objects related to AR_BPA_AREA_ITEMS, based on documented foreign key and key relationships, include:

• AR_BPA_TEMPLATES_B — joined on TEMPLATE_ID to identify the owning template.
• AR_BPA_ITEMS_B — joined on ITEM_ID to resolve the content item definition.
• AR_BPA_ITEMS_TL — provides translated item names and descriptions.
• AR_BPA_TEMPLATES_TL — provides translated template names.
• AR_BPA_AREAS_B — describes content areas referenced by PARENT_AREA_CODE and DISPLAY_LEVEL.
• AR_BPA_RULES — defines conditional rules that govern template presentation.
• AR_BPA_TEMPLATE_ASSIGNMENTS — links templates to customers or transaction types, determining when a layout is applied.

Together these objects form the Bill Presentment Architecture data model, in which AR_BPA_AREA_ITEMS mediates the template-to-item relationship and defines the rendered layout.