Search Results bne_stylesheets_b_uk1

Overview

BNE.BNE_STYLESHEETS_B is the foundational definition table for Oracle EBS style sheets, which are hierarchical sets of style definitions used for formatting rendered content (HTML, OA Framework pages, and related presentation layers). The table conforms to CSS (Cascading Style Sheet) standards and is owned by the BNE schema, an Oracle EBS product family that has historically supplied the style sheet infrastructure used by OA Framework and web-based EBS pages. Each row represents one style sheet definition, identified by an application context and a style sheet code. The object is registered as VALID and carries FND design data BNE.BNE_STYLESHEETS_B, meaning it participates in the standard EBS data model conventions (who columns, object versioning, and editioning support in 12.2.x).

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. It does not reference any other database object through foreign keys on the business side; the implied relationship to FND_APPLICATIONS on APPLICATION_ID is a soft/functional reference rather than an enforced FK. A standalone classification suggests the table is best modeled as a hub (with natural business key) with one satellite for descriptive attributes, rather than as a link between pre-existing hubs.

Key Information Stored

The table's physical schema documents 12 columns. The most functionally significant are described below.

• APPLICATION_ID (NUMBER, 15, mandatory) – Application identifier that scopes the style sheet to a specific Oracle EBS application. Functionally a foreign key to FND_APPLICATIONS.APPLICATION_ID.
• STYLESHEET_CODE (VARCHAR2, 30, mandatory) – Unique code identifying the style sheet within an application. Together with APPLICATION_ID this forms the primary key.
• OBJECT_VERSION_NUMBER (NUMBER, 15) – Standard optimistic locking column used by OA Framework to detect concurrent modification.
• DEFAULT_FLAG (VARCHAR2) – Indicates whether this style sheet is the default for its application.
• READ_ONLY_FLAG (VARCHAR2) – Indicates whether the style sheet is protected from modification.
• IMAGE_FILE_NAME (VARCHAR2, 40) – Associated image file used by the style sheet.
• ZD_EDITION_NAME (VARCHAR2, 30) – Online patching (edition-based redefinition) column present in EBS 12.2.x.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN – Standard Who columns capturing row audit information.

The primary key is BNE_STYLESHEETS_B_PK (APPLICATION_ID, STYLESHEET_CODE). The unique index BNE_STYLESHEETS_B_UK1 (APPLICATION_ID, STYLESHEET_CODE, ZD_EDITION_NAME) is the business-key candidate surfaced by the user's search term. In 12.2.x this composite unique key must include ZD_EDITION_NAME to remain unique across editions during online patching; in 12.1.1 the edition column is absent and the effective unique key is the two-column PK. Data is stored in tablespace APPS_TS_TX_DATA with PCTFREE 10; indexes reside in APPS_TS_TX_IDX.

Common Use Cases and Queries

Typical uses include retrieving the default style sheet for an application, listing all read-only style sheets, and auditing style sheet definitions inherited from seed data.

Retrieve the default style sheet(s) for a given application:

SELECT stylesheet_code, image_file_name
FROM bne.bne_stylesheets_b
WHERE application_id = :app_id
  AND default_flag = 'Y';

List read-only style sheets by application:

SELECT application_id, stylesheet_code
FROM bne.bne_stylesheets_b
WHERE read_only_flag = 'Y';

In 12.2.2, when querying through the editioned view, you generally interact with the non-edition view (BNE_STYLESHEETS) rather than the base table directly, so that edition filtering is applied automatically. Direct queries against _B should include ZD_EDITION_NAME only when inspecting run-time vs. patch editions.

Related Objects

The following objects are most likely to reference or be referenced by BNE_STYLESHEETS_B:

• FND_APPLICATIONS – joined via bne_stylesheets_b.application_id = fnd_applications.application_id to resolve application names.
• BNE_STYLESHEETS_TL – translation table for style sheet name/description, joined on APPLICATION_ID and STYLESHEET_CODE.
• BNE_STYLESHEETS – the editioned/friendly view that exposes BNE_STYLESHEETS_B rows in 12.2.x.
• BNE_STYLESHEET_DEFNS_B (and its _TL counterpart) – stores the individual style definitions belonging to each style sheet, linked via the same composite key.
• FND_USER – joined via CREATED_BY and LAST_UPDATED_BY.
• FND_LOGINS – joined via LAST_UPDATE_LOGIN.