Results for “adjustment_offset_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_IAC_ADJUSTMENTS is a table in the IGI (Public Sector Financials International) product schema within Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is part of the IGI Intragovernmental Accounting (IAC) subsystem, which supports U.S. federal and public sector accounting requirements such as trading partner balancing and Treasury reporting. The table holds accounting information and functions as a driver table for creating journals, meaning rows in this table are consumed by the journal generation process to produce General Ledger postings. It captures adjustment-level detail tied to transaction headers, providing the granular debit/credit entries, code combinations, and amounts required to move IAC activity into the general ledger.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as satellite-leaning. Its single documented foreign key — ADJUSTMENT_ID referencing IGI_IAC_TRANSACTION_HEADERS — indicates it hangs off a parent transaction entity and records descriptive, attributable detail rather than acting as an independent hub or a pure many-to-many link. This suggests modeling it as a satellite attached to the transaction header hub, with its own descriptive and transactional attributes.

Key Information Stored

The table contains 20 documented columns. The most significant include:

• ADJUSTMENT_ID — the foreign key to IGI_IAC_TRANSACTION_HEADERS and the primary linking attribute; effectively the surrogate/business key that associates an adjustment with its parent transaction.
• BOOK_TYPE_CODE and SET_OF_BOOKS_ID — identify the ledger/books context for the adjustment.
• CODE_COMBINATION_ID and REPORT_CCID — reference the accounting flexfield combinations (the posting account and the reporting account, respectively).
• DR_CR_FLAG and AMOUNT — define the debit/credit direction and monetary value of the adjustment line.
• ADJUSTMENT_TYPE and ADJUSTMENT_OFFSET_TYPE — classify the nature of the adjustment and its offsetting entry.
• TRANSFER_TO_GL_FLAG — indicates whether the row has been transferred to the General Ledger.
• UNITS_ASSIGNED, ASSET_ID, DISTRIBUTION_ID — tie the adjustment to quantity and asset/distribution detail.
• PERIOD_COUNTER — identifies the accounting period.
• EVENT_ID — links to the underlying business event (Subledger Accounting context).
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The metadata does not document a separate single-column primary key or unique index distinct from ADJUSTMENT_ID, so ADJUSTMENT_ID serves as the principal identifying and referencing column.

Common Use Cases and Queries

Typical use cases center on journal creation, transfer-to-GL reconciliation, and federal trading-partner reporting. Common query patterns include:

• Retrieving all adjustments for a given transaction: SELECT * FROM IGI.IAC_ADJUSTMENTS WHERE ADJUSTMENT_ID = :id;
• Finding adjustments pending transfer to GL: SELECT ADJUSTMENT_ID, AMOUNT, DR_CR_FLAG FROM IGI.IAC_ADJUSTMENTS WHERE TRANSFER_TO_GL_FLAG = 'N';
• Summarizing by account combination and period: SELECT CODE_COMBINATION_ID, PERIOD_COUNTER, SUM(AMOUNT) FROM IGI.IAC_ADJUSTMENTS GROUP BY CODE_COMBINATION_ID, PERIOD_COUNTER;
• Balancing debits and credits for a ledger: comparing DR_CR_FLAG totals per SET_OF_BOOKS_ID and BOOK_TYPE_CODE.

Reporting scenarios include reconciliation of IAC adjustments to posted GL journals and audit trails tracing adjustments back to their source event via EVENT_ID.

Related Objects

• IGI_IAC_TRANSACTION_HEADERS — parent table; joined on IGI_IAC_ADJUSTMENTS.ADJUSTMENT_ID = IGI_IAC_TRANSACTION_HEADERS.ADJUSTMENT_ID (documented FK).
• GL_CODE_COMBINATIONS — resolved via CODE_COMBINATION_ID and REPORT_CCID for account validation and reporting.
• GL_JE_HEADERS / GL_JE_LINES — target journals created from adjustment driver rows.
• GL_SETS_OF_BOOKS — resolved via SET_OF_BOOKS_ID for ledger context.
• GL_PERIODS / FA_PERIODS — resolved via PERIOD_COUNTER for period identification.
• XLA_EVENTS — linked via EVENT_ID for Subledger Accounting event context.

These relationships make IGI_IAC_ADJUSTMENTS a pivotal bridge between IAC transaction processing and General Ledger journal creation.