Search Results page_width

Overview

AR_BPA_PAGE_SETUPS_VL is a read-only, language-translated reporting view owned by the APPS schema in Oracle E-Business Suite Receivables. It exposes the configurable page layout definitions used by Oracle Receivables' Business Process Architecture (BPA) publishing and document-generation framework, where each record describes a named page setup controlling paper dimensions, print margins, numbering position, and font characteristics for generated documents. The "_VL" suffix denotes a "view with language" that joins a base (_B) table to its translation (_TL) table, returning only the rows matching the session's language. In the 12.1.1 and 12.2.2 code lines, this view functions as the supported read interface for reporting, integration, and inquiry against page setup metadata, insulating consumers from the physical data model and presenting the descriptive name and description in the user's own language.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is defined over two synonyms: AR_BPA_PAGE_SETUPS_B (the base table holding language-independent page setup attributes) and AR_BPA_PAGE_SETUPS_TL (the translation table holding PAGE_SETUP_NAME and PAGE_SETUP_DESC). The view text confirms this:

• FROM AR_BPA_PAGE_SETUPS_TL T, AR_BPA_PAGE_SETUPS_B B
• WHERE B.PAGE_SETUP_ID = T.PAGE_SETUP_ID AND T.LANGUAGE = USERENV('LANG')

The join is on PAGE_SETUP_ID, and the USERENV('LANG') predicate restricts translation rows to the current session language. For each _B row the join returns one row per matching _TL row, so effectively one row per session language. All non-translated attributes (dimensions, margins, flags, audit columns, print font) originate in the _B table. The ETRM excerpt lists ROW_ID (derived from B.ROWID) first, followed by the identifier, translated text, dimensional, and audit attributes. No INSTEAD-OF triggers or DML capability are documented; the object is a query view.

Key Columns

• PAGE_SETUP_ID — Primary identifier joining base and translation rows.
• PAGE_SETUP_NAME / PAGE_SETUP_DESC — Language-specific name and description sourced from the _TL table.
• PAGE_WIDTH / PAGE_HEIGHT — Physical page dimensions (the attribute most associated with "page_width" searches) and the corresponding height.
• TOP_MARGIN, BOTTOM_MARGIN, LEFT_MARGIN, RIGHT_MARGIN — Printable-area margins applied during document rendering.
• PAGE_NUMBER_LOC — Placement of the page number on the rendered page.
• PAGE_UNIT_OF_MEASURE — Unit (for example inch, cm, or point) in which width, height, and margins are expressed.
• PRINT_FONT_FAMILY / PRINT_FONT_SIZE — Font attributes used when printing.
• SEEDED_FLAG — Indicates whether the row is Oracle-seeded or user-defined.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, plus ROW_ID.

Common Use Cases and Queries

Typical uses include inventorying page setups, checking dimensions and units before printing, and feeding layout parameters into external document-generation tools.

List all page setups with their dimensions:

SELECT page_setup_id, page_setup_name, page_width, page_height, page_unit_of_measure, seeded_flag FROM apps.ar_bpa_page_setups_vl ORDER BY page_setup_name;

Find setups by width, accommodating unit differences:

SELECT page_setup_name, page_width, page_height, page_unit_of_measure FROM apps.ar_bpa_page_setups_vl WHERE page_width = 8.5 AND page_unit_of_measure = 'IN';

Review seeded versus user-defined setups:

SELECT page_setup_name, page_width, page_height, print_font_family, print_font_size FROM apps.ar_bpa_page_setups_vl WHERE seeded_flag = 'Y';

Because the view filters on USERENV('LANG'), results are returned only in the language of the connecting session; querying in a different language yields the translated name and description for that language if a _TL row exists.