Search Results bne_graphs_b_uk1




Overview
Explore in AI Chat

Overview

BNE.BNE_GRAPHS_B is the base table for graph information within the Oracle E-Business Suite (EBS) BNE (Business Intelligence/Graphing) schema. It stores the definitional metadata that drives the presentation of analytical graphs associated with integrators and layouts. In EBS 12.1.1 and 12.2.2, this table functions as the master (header) record set for graph configurations, holding the graph's dimensional and type characteristics, linkage to an integrator, and linkage to a layout. Each row represents the graph-level definition, while dependent child tables such as BNE_GRAPH_COLUMNS hold the detailed column-level mappings that resolve into the visual graph.

From a Data Vault modeling perspective, the structure is classified heuristically as satellite-leaning. This suggests the table is best modeled as a descriptor/satellite around a central hub of integrators and layouts, rather than as an independent hub or a pure link. The presence of standard "Who" columns and an OBJECT_VERSION_NUMBER with no child business key beyond its own composite business key reinforces this interpretation.

Key Information Stored

The table is identified by the primary key BNE_GRAPHS_B_PK on the combination of APPLICATION_ID, INTEGRATOR_CODE, and SEQUENCE_NUM. The documented unique index BNE_GRAPHS_B_UK1 covers APPLICATION_ID, INTEGRATOR_CODE, and SEQUENCE_NUM, with the ETRM 12.2.2 physical schema listing an additional ZD_EDITION_NAME column in the uniqueness set. These carry the business-key semantics of the row.

  • APPLICATION_ID — Application identifier; foreign key to FND_APPLICATIONS.APPLICATION_ID. Part of the primary key.
  • INTEGRATOR_CODE — Unique code identifying this entity for the given APPLICATION_ID. Part of the primary key and a foreign key to BNE_INTEGRATORS_B.
  • SEQUENCE_NUM — Sequencing column differentiating multiple graphs within the same integrator context. Part of the primary key.
  • OBJECT_VERSION_NUMBER — Optimistic locking/versioning column used by the framework.
  • LAYOUT_APP_ID — Foreign key to BNE_LAYOUTS_B, identifying the layout application context the graph belongs to.
  • LAYOUT_CODE — Layout code associated with the graph definition.
  • GRAPH_DIMENSION_CODE — Dimension identifier controlling how the graph is rendered.
  • GRAPH_TYPE_CODE — Classifies the graph type (for example, bar, line, pie).
  • AUTO_GRAPH_FLAG — Flag indicating whether the graph is generated automatically.
  • CREATED_BY / CREATION_DATE — Standard audit columns recording the creating user (FK to FND_USER) and timestamp.
  • LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard audit columns recording the last modifying user, timestamp, and OS login (FK to FND_LOGINS).

Common Use Cases and Queries

Typical usage includes reporting on configured graphs per integrator, auditing graph layout assignments, and driving graph rendering engines that resolve graph headers into column-level definitions. A common query pattern joins BNE_GRAPHS_B to its integrator and layout parents:

  • List all graphs for an integrator: SELECT g.* FROM BNE.BNE_GRAPHS_B g WHERE g.APPLICATION_ID = :app AND g.INTEGRATOR_CODE = :code ORDER BY g.SEQUENCE_NUM;
  • Join to layouts: SELECT g.INTEGRATOR_CODE, g.SEQUENCE_NUM, l.LAYOUT_CODE FROM BNE.BNE_GRAPHS_B g JOIN BNE.BNE_LAYOUTS_B l ON l.APP_ID = g.LAYOUT_APP_ID AND l.CODE = g.LAYOUT_CODE;
  • Resolve columns: SELECT g.*, c.* FROM BNE.BNE_GRAPHS_B g JOIN BNE.BNE_GRAPH_COLUMNS c ON c.APPLICATION_ID = g.APPLICATION_ID AND c.INTEGRATOR_CODE = g.INTEGRATOR_CODE;

Related Objects

The most significant related objects, based on the documented FK relationships, are:

  • BNE.BNE_INTEGRATORS_B — referenced by APPLICATION_ID; defines the integrator owning the graph.
  • BNE.BNE_LAYOUTS_B — referenced by LAYOUT_APP_ID; defines the layout the graph belongs to.
  • BNE.BNE_GRAPH_COLUMNS — child table referencing this table via APPLICATION_ID; holds the graph's column definitions.
  • FND_APPLICATIONS — upstream source of APPLICATION_ID.
  • FND_USER and FND_LOGINS — referenced by the standard who columns for audit resolution.