Search Results bne_stylesheets_b




Overview
Explore in AI Chat

Overview

BNE_STYLESHEETS_B is a core configuration table within the BNE schema (Web Applications Desktop Integrator, commonly known as Web ADI or ADI) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of a collection of stylesheets — logical groupings of layout and formatting attributes used by Desktop Integrator to render spreadsheet-based integrators, journals, and upload templates consistently. Each row represents one stylesheet definition, scoped by application, and serves as the header record for the broader stylesheet configuration model.

Under a heuristic Data Vault classification mined from the foreign key structure, this object is assessed as standalone. No dependent FK relationships were identified, which suggests the table operates as an independent reference of style definitions rather than as a transactional hub or link. Practically, this means it is best treated as a reference/definition table that other BNE objects consume by code value rather than through enforced referential integrity.

Key Information Stored

The table carries 12 documented columns. The most operationally significant are:

The surrogate 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, adding the edition name to the PK columns.

Common Use Cases and Queries

Typical scenarios include auditing which stylesheets are configured per application, identifying the default stylesheet, and validating that codes are unique within an application. A reporting query to list active definitions:

  • SELECT application_id, stylesheet_code, default_flag, read_only_flag, image_file_name FROM bne.bne_stylesheets_b WHERE default_flag = 'Y';
  • SELECT a.application_name, s.stylesheet_code, s.default_flag FROM bne.bne_stylesheets_b s, fnd_application_vl a WHERE s.application_id = a.application_id ORDER BY a.application_name, s.stylesheet_code;
  • SELECT stylesheet_code, COUNT(*) FROM bne.bne_stylesheets_b GROUP BY stylesheet_code HAVING COUNT(*) > 1; — used to detect cross-application duplicate codes.

Because the object is standalone, joins to related BNE stylesheet attribute tables are driven by APPLICATION_ID and STYLESHEET_CODE rather than enforced FK constraints.

Related Objects

The following objects are most relevant to BNE_STYLESHEETS_B, joined on the composite key columns APPLICATION_ID and STYLESHEET_CODE:

These relationships are logical rather than FK-enforced, consistent with the standalone classification.