Results for “aet_id”

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

Overview

OKL_TRNS_ACC_DSTRS_ALL is the accounting distributions table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It stores the individual debit and credit distribution lines generated when an accounting event is processed and posted to the General Ledger. Each row represents a single accounting line — its code combination, amount, currency, and posting status — and is tied both to a parent accounting event and to the accounting template that drove the line's creation. The table therefore sits at the heart of the OKL subledger accounting flow, bridging event definitions, template rules, and Oracle General Ledger balances.

From a Data Vault modeling perspective, the FK structure suggests this object behaves primarily as a link. It connects two business entities — OKL_ACC_EVENTS_ALL via AET_ID and OKL_AE_TEMPLATES_ALL via TEMPLATE_ID — while carrying descriptive attributes (amounts, dates, posting flags) that would normally reside in an adjacent satellite. Analysts designing a vault layer should treat OKL_TRNS_ACC_DSTRS_ALL as the relationship hub between accounting events and templates, with its descriptive columns split into one or more satellite tables.

Key Information Stored

The primary key is a surrogate identifier, ID, enforced by OKL_TRNS_ACC_DSTRS_ALL_PK and reinforced by the unique index OKL_TRNS_ACC_DSTRS_ALL_U1. Business-key candidates are limited to ID itself; no natural composite key is documented. The most operationally significant columns include:

• AET_ID — foreign key to OKL_ACC_EVENTS_ALL, identifying the accounting event that generated the distribution.
• TEMPLATE_ID — foreign key to OKL_AE_TEMPLATES_ALL, identifying the accounting template applied.
• CODE_COMBINATION_ID — the GL account combination for the line.
• CR_DR_FLAG — indicates whether the line is a debit or credit.
• AMOUNT and ACCOUNTED_AMOUNT — entered and functional-currency amounts.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, and CURRENCY_CONVERSION_RATE — the FX detail applied to the line.
• GL_DATE — the accounting date passed to the GL.
• SET_OF_BOOKS_ID — the ledger the distribution belongs to.
• POSTED_YN, POST_TO_GL, POST_REQUEST_ID — posting status and control identifiers.
• DRAFT_YN, DRAFT_VERSION, ORIGINAL_DIST_ID — draft and reversal tracking.
• AE_CREATION_ERROR and GL_REVERSAL_FLAG — error state and reversal indication.
• ORG_ID — the operating unit (multi-org security).

Common Use Cases and Queries

The table is most often queried to reconcile OKL subledger activity with GL balances, to investigate posting failures, and to report on distributions by event or template. A representative query lists distributions for a given event:

SELECT d.id, d.code_combination_id, d.cr_dr_flag,
       d.amount, d.accounted_amount, d.gl_date, d.posted_yn
FROM   okl.okl_trns_acc_dstrs_all d
WHERE  d.aet_id = :event_id
ORDER  BY d.id;

Failed postings are identified by filtering on AE_CREATION_ERROR or POSTED_YN = 'N'. Period-close and audit reports typically aggregate amounts by SET_OF_BOOKS_ID and GL_DATE.

Related Objects

• OKL_ACC_EVENTS_ALL — parent accounting events; join on OKL_TRNS_ACC_DSTRS_ALL.AET_ID = OKL_ACC_EVENTS_ALL.AET_ID (or its PK).
• OKL_AE_TEMPLATES_ALL — accounting templates; join on TEMPLATE_ID.
• GL_CODE_COMBINATIONS — resolves CODE_COMBINATION_ID to account segments.
• GL_JE_LINES / GL_JE_HEADERS — downstream journal entries created after posting.
• GL_SETS_OF_BOOKS — ledger definition for SET_OF_BOOKS_ID.
• FND_CURRENCIES — currency validation for CURRENCY_CODE.

These relationships make OKL_TRNS_ACC_DSTRS_ALL the central link between OKL accounting events and Oracle General Ledger.