Search Results graph_seq_num

Overview

BNE_GRAPH_COLUMNS is the base table that stores graph information for Oracle EBS Web Applications Desktop Integrator (BNE), the product that enables desktop-based integration with E-Business Suite data through spreadsheet and document interfaces. The table resides in the BNE schema and holds a status of VALID in both 12.1.1 and 12.2.2. It defines the column-level structure of graphs configured through Desktop Integrator, linking each graph definition to the interface columns from which its data is drawn.

The physical schema documents 15 columns. Under the heuristic Data Vault classification mined from the foreign key structure, BNE_GRAPH_COLUMNS is best modeled as a link table: it connects graph definitions in BNE_GRAPHS_B to interface column definitions in BNE_INTERFACE_COLS_B, adding descriptive attributes such as location code and audit columns. This classification is a modeling suggestion rather than a documented constraint.

Key Information Stored

The primary key is BNE_GRAPH_COLUMNS_PK, defined on the composite of APPLICATION_ID, INTEGRATOR_CODE, GRAPH_SEQ_NUM, and SEQUENCE_NUM. This composite acts as the surrogate identifier for each graph column row. A unique index, BNE_GRAPH_COLUMNS_UK1, covers the same four columns plus ZD_EDITION_NAME, marking it as the business-key candidate and supporting edition-based redefinition in 12.2.x.

• APPLICATION_ID — identifies the application owning the graph definition; part of the primary key and of the foreign key to BNE_GRAPHS_B.
• INTEGRATOR_CODE — the integrator (interface) code qualifying the graph; part of the primary key and the BNE_GRAPHS_B foreign key.
• GRAPH_SEQ_NUM — the sequence number of the parent graph; this is the column most directly associated with the user search term and the third component of the primary key.
• SEQUENCE_NUM — orders the individual columns within a graph; fourth component of the primary key.
• INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM — the composite foreign key to BNE_INTERFACE_COLS_B, identifying the interface column from which the graph column derives its source data.
• LOCATION_CODE — describes the position or placement of the column within the graph layout.
• OBJECT_VERSION_NUMBER — supports optimistic locking during concurrent updates.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE capture row lifecycle information.
• ZD_EDITION_NAME — participates in the unique index and supports editioning of the table.

Common Use Cases and Queries

BNE_GRAPH_COLUMNS is principally queried when diagnosing Desktop Integrator graph layouts, reconciling a graph's columns against its interface definitions, or extracting configuration metadata for migration and documentation. A typical pattern joins the table to its parent graph and interface column tables:

• List all columns for a specific graph: SELECT g.GRAPH_SEQ_NUM, c.SEQUENCE_NUM, c.LOCATION_CODE FROM BNE_GRAPH_COLUMNS c, BNE_GRAPHS_B g WHERE c.APPLICATION_ID = g.APPLICATION_ID AND c.INTEGRATOR_CODE = g.INTEGRATOR_CODE AND c.GRAPH_SEQ_NUM = g.GRAPH_SEQ_NUM.
• Trace a graph column to its interface column: join INTERFACE_APP_ID, INTERFACE_CODE, and INTERFACE_SEQ_NUM to BNE_INTERFACE_COLS_B.
• Locate a specific graph by sequence: SELECT * FROM BNE_GRAPH_COLUMNS WHERE GRAPH_SEQ_NUM = :graph_seq_num.
• Audit recent configuration changes using CREATION_DATE or LAST_UPDATE_DATE filters.

Related Objects

The foreign key relationships documented in the ETRM metadata identify the primary dependent objects:

• BNE_GRAPHS_B — parent table for graph definitions; joined on APPLICATION_ID, INTEGRATOR_CODE, and GRAPH_SEQ_NUM.
• BNE_INTERFACE_COLS_B — source of interface column definitions; joined on INTERFACE_APP_ID, INTERFACE_CODE, and INTERFACE_SEQ_NUM.
• BNE_GRAPH_COLUMNS_UK1 — unique index enforcing the business key including ZD_EDITION_NAME.

These relationships make BNE_GRAPH_COLUMNS the linkage point between graph-level metadata and interface column metadata within the BNE schema.