Results for “bne_graphs_vl”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BNE_GRAPHS_VL is a VALID database view owned by the APPS schema within the BNE — Web Applications Desktop Integrator product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix _VL follows the standard EBS convention for a "validated, translated" view: it joins the base transactional definition table to its translation table and restricts the translation join to the session's language through USERENV('LANG'). In this way the view presents a single, language-appropriate row per graph definition without requiring calling code to manage the multi-language structure manually.
BNE_GRAPHS_VL exposes the definition of graphs that Web Applications Desktop Integrator (Web ADI) uses to render charts from integrator data. Each row describes a graph's layout binding, its dimensional and type characteristics, and the display labels (chart title and axis labels) resolved to the user's current language. Because graph definitions are configuration-level metadata rather than high-volume transaction data, the view is typically read by Web ADI form and page logic, by graph rendering components, and by administrators and developers who need to inspect or report on configured graph objects. The "graph v1.0 down" search context that leads users to this object relates to graph rendering and definition troubleshooting; queries against this view are the primary means of confirming whether a graph definition exists, is correctly bound to a layout, and carries the expected translated labels.
Underlying Base Objects
The view text documents a two-table join:
- BNE_GRAPHS_B — the base (non-translated) table holding application, integrator, sequence, layout binding, graph dimension/type, auto-graph flag, object version, and standard WHO audit columns.
- BNE_GRAPHS_TL — the translation table supplying the language-dependent CHART_TITLE, X_AXIS_LABEL, Y_AXIS_LABEL, and Z_AXIS_LABEL values.
The two objects are joined on the composite key (APPLICATION_ID, INTEGRATOR_CODE, SEQUENCE_NUM), and the TL side is further filtered by T.LANGUAGE = USERENV('LANG'). Both base objects are referenced in the documented metadata as synonyms. Because BNE_GRAPHS_B is the driving table, the view returns one row per graph definition in the current-language translation, provided a matching translation row exists; missing translations cause the definition to be absent from the result set. The view is read-only and carries the ROWID of the base table (BNE_GRAPHS_B) as ROW_ID.
Key Columns
- ROW_ID — ROWID of the underlying BNE_GRAPHS_B row; used for identifying and locking the base record.
- APPLICATION_ID — the application owning the integrator to which the graph belongs; part of the primary composite key.
- INTEGRATOR_CODE — identifies the Web ADI integrator associated with the graph; part of the composite key.
- SEQUENCE_NUM — ordering/identification number of the graph within the integrator; part of the composite key.
- OBJECT_VERSION_NUMBER — optimistic locking column used by the framework to detect concurrent modifications.
- LAYOUT_APP_ID, LAYOUT_CODE — application and code identifying the layout the graph is bound to.
- GRAPH_DIMENSION_CODE, GRAPH_TYPE_CODE — control the dimensionality and rendering type of the chart.
- AUTO_GRAPH_FLAG — indicates whether the graph is generated automatically by the integrator.
- CHART_TITLE, X_AXIS_LABEL, Y_AXIS_LABEL, Z_AXIS_LABEL — the translated display strings rendered on the graph.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard EBS WHO audit columns inherited from BNE_GRAPHS_B.
Common Use Cases and Queries
The view is used to inspect graph configuration for a given integrator, to verify that translated labels exist for a user's language, and to correlate graph definitions with their layouts. A representative query lists all graphs for an integrator in the session language:
SELECT integrator_code, sequence_num, chart_title, graph_type_code, graph_dimension_code, auto_graph_flag FROM bne_graphs_vl WHERE application_id = :app_id AND integrator_code = :integrator ORDER BY sequence_num;SELECT layout_app_id, layout_code, COUNT(*) FROM bne_graphs_vl GROUP BY layout_app_id, layout_code;SELECT sequence_num, x_axis_label, y_axis_label, z_axis_label FROM bne_graphs_vl WHERE application_id = :app_id AND integrator_code = :integrator AND auto_graph_flag = 'Y';
Because the language predicate is fixed to USERENV('LANG'), results vary with the session's NLS_LANG setting; troubleshooting a "graph not appearing" issue should therefore include verifying that a translation row exists in BNE_GRAPHS_TL for the affected language. For full multi-language auditing, query the base tables directly rather than the view.
-
View: BNE_GRAPHS_VL 12.2.2
APPS.BNE_GRAPHS_VL·↳ BNE_GRAPHS_B·↳ BNE_GRAPHS_TL·Explore BNE module →
-
VIEW: APPS.BNE_GRAPHS_VL 12.2.2
-
VIEW: APPS.BNE_GRAPHS_VL 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
SYNONYM: APPS.BNE_GRAPHS_TL 12.1.1
-
SYNONYM: APPS.BNE_GRAPHS_TL 12.2.2
-
SYNONYM: APPS.BNE_GRAPHS_B 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.BNE_GRAPHS_B 12.2.2
-
eTRM - BNE Tables and Views 12.2.2
Translations for BNE_VIEWERS_B
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - BNE Tables and Views 12.2.2
Translations for BNE_VIEWERS_B