Search Results rg_dss_system_seg_order




Overview
Explore in AI Chat

Overview

The RG_DSS_SYSTEM_SEG_ORDER table resides in the RG schema and belongs to the Application Report Generator (RG) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the segment sort order configuration for Financial Analyzer financial data sets. Each row defines how a specific accounting key flexfield segment (or, more broadly, an application column) is ordered within a given reporting system definition. This makes the table a configuration repository that governs the presentation sequence of segments when Financial Analyzer builds and displays financial data sets.

From a Data Vault modeling perspective, the mined foreign key structure suggests this object is satellite-leaning. It describes attributes that qualify and order a parent entity (the reporting system in RG_DSS_SYSTEMS) rather than acting as an independent hub or a many-to-many link between distinct business concepts. The table is fully registered and valid in the EBS data dictionary.

Key Information Stored

  • SYSTEM_ID — Foreign key to RG_DSS_SYSTEMS; identifies the Financial Analyzer system or data set to which the segment ordering belongs. Part of the composite primary key.
  • SEQUENCE — The ordinal position of the segment within the sort order. Part of the composite primary key, so a system cannot have two segments assigned the same sequence number.
  • APPLICATION_COLUMN_NAME — The application column representing the segment being ordered. Constrained with SYSTEM_ID by unique index RG_DSS_SYSTEM_SEG_ORDER_U2, preventing duplicate ordering entries for the same column within a system.
  • ID_FLEX_CODE — Identifies the key flexfield (for example, the Accounting Flexfield) to which the segment belongs.
  • ID_FLEX_NUM — The specific flexfield structure number, narrowing the ordering rule to a particular chart of accounts or flexfield instance.
  • CONTEXT — Descriptive flexfield context value, allowing context-sensitive segment ordering.
  • ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield attribute columns used for extensible, customer-defined configuration of the segment order records.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified each ordering definition, and when.

The surrogate primary key is RG_DSS_SYSTEM_SEG_ORDER_PK (SYSTEM_ID, SEQUENCE). Two unique indexes serve as business-key candidates: U1 (SYSTEM_ID, SEQUENCE) and U2 (SYSTEM_ID, APPLICATION_COLUMN_NAME). Together these enforce that each system has an unambiguous, gap-free ordering of its segments with no duplicate columns.

Common Use Cases and Queries

Typical usage centers on retrieving or validating the segment presentation order for a given Financial Analyzer system. Reporting developers query the table to reproduce the same column sequence in custom extracts, while support analysts inspect it to diagnose mis-ordered or duplicated segments.

  • Retrieve the ordered segment list for a system: SELECT sequence, application_column_name, id_flex_code, id_flex_num FROM rg_dss_system_seg_order WHERE system_id = :p_system_id ORDER BY sequence;
  • Detect ordering gaps or duplicate sequences within a system to validate configuration integrity.
  • Join to RG_DSS_SYSTEMS to produce a report of systems and their segment layouts.
  • Confirm that a given application column is registered for ordering before building a Financial Analyzer data set.

Related Objects

  • RG_DSS_SYSTEMS — Parent table referenced by RG_DSS_SYSTEM_SEG_ORDER.SYSTEM_ID; the primary dependency governing this table's rows.
  • RG_DSS_SYSTEM_SEG_ORDER_PK — Primary key constraint (SYSTEM_ID, SEQUENCE).
  • RG_DSS_SYSTEM_SEG_ORDER_U1 — Unique index on (SYSTEM_ID, SEQUENCE).
  • RG_DSS_SYSTEM_SEG_ORDER_U2 — Unique index on (SYSTEM_ID, APPLICATION_COLUMN_NAME).
  • FND_ID_FLEX_STRUCTURES — Referenced conceptually via ID_FLEX_CODE and ID_FLEX_NUM to resolve the key flexfield definition.