Search Results ra_account_default_segments_pk

Overview

RA_ACCOUNT_DEFAULT_SEGMENTS is a Receivables (AR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores AutoAccounting segment information. AutoAccounting is the rule engine through which Oracle Receivables derives the individual General Ledger account segment values that are used to build complete accounting flexfield combinations for subledger transactions — invoices, credit memos, debit memos, receipts, adjustments, chargebacks, and revenue recognition entries. Where RA_ACCOUNT_DEFAULTS_ALL defines the AutoAccounting rule header (the source from which a given segment should be derived, such as a salesperson, a product, a standard memo line, or a constant), RA_ACCOUNT_DEFAULT_SEGMENTS holds the per-segment detail rows that implement that rule. Each row associates one GL account segment, identified by SEGMENT_NUM and SEGMENT, with a derivation source represented by TABLE_NAME, CONSTANT, and the descriptive flexfield attribute columns.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. It behaves as a dependent detail satellite attached to the RA_ACCOUNT_DEFAULTS_ALL rule hub, carrying the descriptive, time-stamped segment-level attributes of each AutoAccounting rule rather than acting as an independent business entity.

Key Information Stored

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

• GL_DEFAULT_SEGMENT_ID — the surrogate primary key, enforced by RA_ACCOUNT_DEFAULT_SEGMENTS_PK and by the unique index RA_ACCOUNT_DEFAULT_SEGMENTS_U1. It uniquely identifies each segment-level AutoAccounting rule row.
• GL_DEFAULT_ID — foreign key to RA_ACCOUNT_DEFAULTS_ALL, linking the segment row back to its parent AutoAccounting rule. Together with SEGMENT_NUM and SEGMENT, this forms the documented business key RA_ACCOUNT_DEFAULT_SEGMENTS_UK.
• SEGMENT_NUM — the ordinal position of the accounting flexfield segment being defined.
• SEGMENT — the segment identifier or qualifier associated with the rule.
• TABLE_NAME — the source table from which the segment value is derived, defining the AutoAccounting source object.
• CONSTANT — a fixed value assigned to the segment when the derivation source is a constant rather than a table-driven lookup.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle descriptive flexfield (DFF) columns, used to capture implementation-specific derivation context or additional mapping criteria.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns that record creation and modification history for each rule row.

Common Use Cases and Queries

The primary use case is AutoAccounting diagnostics: determining why a particular account was or was not derived for a transaction. A typical query joins the segment detail to its rule header:

• Retrieve all segment rules for a given AutoAccounting definition: SELECT s.segment_num, s.segment, s.table_name, s.constant FROM ra_account_default_segments s WHERE s.gl_default_id = :gl_default_id ORDER BY s.segment_num;
• List constant-driven segments across all rules: SELECT d.gl_default_id, s.segment_num, s.constant FROM ra_account_defaults_all d, ra_account_default_segments s WHERE d.gl_default_id = s.gl_default_id AND s.constant IS NOT NULL;
• Audit recent configuration changes using the WHO columns and LAST_UPDATE_DATE.
• Reporting and migration validation: extracting AutoAccounting setups for comparison between environments or during upgrades from 12.1.1 to 12.2.2.

Related Objects

The most significant related objects are:

• RA_ACCOUNT_DEFAULTS_ALL — the parent AutoAccounting rule table, joined on GL_DEFAULT_ID (the sole documented foreign key).
• RA_ACCOUNT_DEFAULT_SEGMENTS_PK and RA_ACCOUNT_DEFAULT_SEGMENTS_U1 — the primary key and unique index that enforce row identity on GL_DEFAULT_SEGMENT_ID.
• RA_ACCOUNT_DEFAULT_SEGMENTS_UK — the unique constraint on GL_DEFAULT_ID, SEGMENT, and SEGMENT_NUM that guarantees one rule row per segment position.
• AutoAccounting configuration forms and the Receivables accounting engine, which consume these rows at transaction accounting time.
• GL accounting flexfield segment definitions, referenced through SEGMENT_NUM and SEGMENT.