Search Results gl_default_segment_id

Overview

The JA_AU_ACCT_DEFAULT_SEGS table resides in the JA schema and belongs to the Asia/Pacific Localizations product family within Oracle E-Business Suite. It stores AutoAccounting segment setup information — specifically, the individual segment-level rules that determine how accounting flexfield segments are derived when transactions are processed under the Australian localization. In Oracle EBS, this table acts as the detail layer beneath a parent AutoAccounting rule, holding the mapping of each accounting segment to its source (a table, a constant value, or a derived source) and the ordinal position of the segment within the accounting flexfield structure.

Based on the foreign key structure, the table exhibits a satellite-leaning characteristic in Data Vault modeling terms: it is dependent on a parent entity (JA_AU_ACCOUNT_DEFAULTS) and captures descriptive, attribute-level detail about segment definitions. The primary key, JA_AU_ACCT_DEFAULT_SEGS_PK, is defined on the GL_DEFAULT_SEGMENT_ID column, which is the surrogate identifier for each segment rule row. A unique index, JA_AU_ACCT_DEFAULT_SEGS_U1, is also documented on GL_DEFAULT_SEGMENT_ID, confirming its role as the business-key candidate for uniquely identifying a segment definition record.

Key Information Stored

The table contains eleven documented columns. The most significant are:

• GL_DEFAULT_SEGMENT_ID — Surrogate primary key and business-key candidate; uniquely identifies each AutoAccounting segment rule row.
• GL_DEFAULT_ID — Foreign key to JA_AU_ACCOUNT_DEFAULTS; links the segment rule to its parent AutoAccounting default definition.
• SEGMENT — Identifies the target accounting flexfield segment to which the rule applies (e.g., Company, Cost Center, Account).
• TABLE_NAME — Specifies the source table from which the segment value is retrieved when the rule is evaluated.
• CONSTANT — Holds a fixed or literal value assigned to the segment when the rule is defined as a constant-based default.
• SEGMENT_NUM — Numeric ordinal indicating the position of the segment within the accounting flexfield structure, used to order segment rules during processing.
• CREATION_DATE, CREATED_BY — Standard audit columns capturing row insert metadata.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification details.

The parent–child relationship between GL_DEFAULT_ID and JA_AU_ACCOUNT_DEFAULTS is the defining structural characteristic: each default definition may have multiple segment rules, one per accounting flexfield segment, ordered by SEGMENT_NUM.

Common Use Cases and Queries

Typical use cases include auditing AutoAccounting configurations, troubleshooting segment derivation failures, and migrating localization setups between environments. A common retrieval pattern joins the segment rules to their parent default definition:

• Retrieving all segment rules for a given AutoAccounting default: SELECT segment, table_name, constant, segment_num FROM ja.ja_au_acct_default_segs WHERE gl_default_id = :p_default_id ORDER BY segment_num;
• Identifying constant-based segment assignments: SELECT * FROM ja.ja_au_acct_default_segs WHERE constant IS NOT NULL;
• Locating rules that source values from a specific table: SELECT * FROM ja.ja_au_acct_default_segs WHERE table_name = 'RA_CUSTOMER_TRX_ALL';
• Auditing recent changes: SELECT gl_default_segment_id, last_updated_by, last_update_date FROM ja.ja_au_acct_default_segs WHERE last_update_date > SYSDATE - 30;

Reporting on this table is valuable during localization implementations to verify that every accounting segment in the flexfield has a corresponding AutoAccounting rule and that the ordering in SEGMENT_NUM aligns with the chart of accounts structure.

Related Objects

• JA_AU_ACCOUNT_DEFAULTS — Parent table referenced through JA_AU_ACCT_DEFAULT_SEGS.GL_DEFAULT_ID → JA_AU_ACCOUNT_DEFAULTS. Provides the header-level AutoAccounting definition.
• GL_CODE_COMBINATIONS — Consumes the derived segment values produced by the rules defined here.
• FND_FLEX_VALUES / FND_ID_FLEX_SEGMENTS — Define the segment structure and valid values that SEGMENT and SEGMENT_NUM reference.
• JA_AU_ACCOUNT_DEFAULTS_PK — Parent primary key relating to the GL_DEFAULT_ID foreign key column.