Search Results gl_ussgl_transaction_codes_pk

Overview

The GL.GL_USSGL_TRANSACTION_CODES table is a General Ledger reference table that stores USSGL (United States Standard General Ledger) transaction codes for federal government accounting within Oracle E-Business Suite 12.1.1 and 12.2.2. The USSGL provides a uniform chart of accounts and posting logic for federal agencies, and transaction codes are the four-digit identifiers that pair with USSGL accounts to define self-balancing debit/credit relationships. This table defines the valid transaction codes per chart of accounts, acting as the validation and descriptive source that drives the USSGL posting model used by federal deployments.

Under a heuristic Data Vault classification, the table exhibits hub-leaning characteristics: its primary key (CHART_OF_ACCOUNTS_ID, USSGL_TRANSACTION_CODE) forms a stable, unique business key, while descriptive attributes such as activation dates and description text sit on the same row. In strict Data Vault terms this would suggest splitting the business key into a hub and moving descriptive attributes to a satellite; the mined FK structure shows this table serving as the referenced parent of GL_USSGL_ACCOUNT_PAIRS.

Key Information Stored

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

• CHART_OF_ACCOUNTS_ID — part of the composite primary key; scopes each transaction code to a specific chart of accounts.
• USSGL_TRANSACTION_CODE — part of the composite primary key; the alphanumeric transaction code itself.
• DESCRIPTION — the human-readable name or explanation of the transaction code.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the date range during which the code is active and available for selection.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT — the standard EBS descriptive flexfield (DFF) columns enabling site-specific extensions.
• ASSOC_INTEREST_USSGL_CODE and ASSOC_DISCOUNT_USSGL_CODE — associated USSGL codes for interest and discount handling.

The surrogate primary key is GL_USSGL_TRANSACTION_CODES_PK over (CHART_OF_ACCOUNTS_ID, USSGL_TRANSACTION_CODE). The unique index GL_USSGL_TRANSACTION_CODES_U1 covers the same two columns, confirming this pair as the business-key candidate.

Common Use Cases and Queries

Typical scenarios include validating transaction codes during USSGL setup, listing active codes for a given ledger's chart of accounts, and reporting on how codes pair with USSGL accounts. A representative query retrieves active codes:

• SELECT ussgl_transaction_code, description FROM gl_ussgl_transaction_codes WHERE chart_of_accounts_id = :coa_id AND NVL(end_date_active, SYSDATE) >= SYSDATE ORDER BY ussgl_transaction_code;
• Join to account pairs: SELECT a.ussgl_transaction_code, a.description FROM gl_ussgl_transaction_codes a, gl_ussgl_account_pairs p WHERE a.chart_of_accounts_id = p.chart_of_accounts_id AND a.ussgl_transaction_code = p.ussgl_transaction_code;
• Audit query filtering on last_update_date and last_updated_by to track maintenance.

These patterns support federal financial reporting, USSGL compliance checks, and setup verification during implementations or upgrades.

Related Objects

The documented foreign key links this table to the following dependent object:

• GL_USSGL_ACCOUNT_PAIRS — references GL_USSGL_TRANSACTION_CODES via CHART_OF_ACCOUNTS_ID and USSGL_TRANSACTION_CODE; this child table records the debit/credit account pairings that give each transaction code its posting meaning.

Beyond the documented relationship, related General Ledger objects include the General Ledger USSGL account definitions and the federal accounting setup forms that consume these codes. The table is maintained through the USSGL setup UI rather than a public API, and its WHO/DFF columns integrate with standard EBS concurrency and flexfield frameworks.