Search Results bne_graphs_b




Overview
Explore in AI Chat

Overview

BNE_GRAPHS_B is the foundational base table within the BNE (Web Applications Desktop Integrator) module of Oracle E-Business Suite, holding configuration definitions for the graphical elements rendered against Web ADI integrators. In EBS releases 12.1.1 and 12.2.2, Web ADI uses this object to persist the metadata that governs how data charts and graphs are presented to end users when they interact with integrator-based spreadsheet and web interfaces. Each row describes a single graph definition associated with a given integrator and layout, providing the structural blueprint consumed at runtime to render visualizations.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table's identity is anchored through its composite primary key to parent business entities (integrators and layouts) rather than acting as an independent hub or a pure many-to-many link. This heuristic reflects its descriptive, attribute-bearing role relative to those parent keys.

Key Information Stored

The table is keyed by BNE_GRAPHS_B_PK, a composite surrogate-free natural key of (APPLICATION_ID, INTEGRATOR_CODE, SEQUENCE_NUM). A second unique index, BNE_GRAPHS_B_UK1, extends this with ZD_EDITION_NAME, reflecting the editioning support introduced in 12.2.x. The most significant columns include:

Common Use Cases and Queries

Consultants and developers query BNE_GRAPHS_B to inventory graph definitions for a given integrator, to troubleshoot rendering issues, and to migrate configuration between environments. A typical diagnostic query enumerates graphs and their layout associations:

  • SELECT SEQUENCE_NUM, LAYOUT_CODE, GRAPH_TYPE_CODE, GRAPH_DIMENSION_CODE, AUTO_GRAPH_FLAG FROM BNE_GRAPHS_B WHERE APPLICATION_ID = :app_id AND INTEGRATOR_CODE = :code;
  • Joining to parent tables to confirm integrity: ... JOIN BNE_LAYOUTS_B l ON g.LAYOUT_APP_ID = l.APPLICATION_ID AND g.LAYOUT_CODE = l.LAYOUT_CODE;
  • Audit reporting using CREATION_DATE / LAST_UPDATE_DATE to identify recently modified graph configurations.

Reporting against AUTO_GRAPH_FLAG helps administrators identify which visualizations are system-generated versus user-authored.

Related Objects

The following objects participate in the documented foreign key relationships:

  • BNE_INTEGRATORS_B — parent integrator definition, joined on APPLICATION_ID and INTEGRATOR_CODE.
  • BNE_LAYOUTS_B — parent layout definition, joined on LAYOUT_APP_ID and LAYOUT_CODE.
  • BNE_GRAPH_COLUMNS — child table referencing APPLICATION_ID, INTEGRATOR_CODE, and GRAPH_SEQ_NUM, holding the column bindings for each graph.

Together these objects form the graph configuration hierarchy within Web ADI, with BNE_GRAPHS_B acting as the central descriptor between integrators, layouts, and their constituent graph columns.