Results for “okl_ae_headers_all”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_AE_HEADERS_ALL is the accounting entry header table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the header-level records that group the journal-style accounting entries generated by the lease accounting engine. Each row represents a single accounting entry event for a contract or transaction, serving as the parent record for the individual debit and credit lines held in OKL_AE_LINES_ALL. The table therefore sits at the centre of the OKL subledger accounting flow, capturing the event, the ledger, the accounting period, and the transfer status to General Ledger.
From a Data Vault modelling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table is anchored to OKL_ACC_EVENTS_ALL through ACCOUNTING_EVENT_ID, indicating a dependent, descriptive role relative to the accounting event rather than an independent hub. Modelers should treat it as a descriptive satellite of the accounting event, with the AE_HEADER_ID acting as its local surrogate key.
Key Information Stored
Of the 27 documented columns, the following are the most significant:
- AE_HEADER_ID — the surrogate primary key (OKL_AE_HEADERS_ALL_PK) and the sole documented business-key candidate via unique index OKL_AE_HEADERS_ALL_U1. It is referenced by OKL_AE_LINES_ALL.AE_HEADER_ID.
- ACCOUNTING_EVENT_ID — foreign key to OKL_ACC_EVENTS_ALL; identifies the originating accounting event.
- AE_CATEGORY — classifies the type of accounting entry header.
- SET_OF_BOOKS_ID — the ledger to which the entry belongs.
- PERIOD_NAME and ACCOUNTING_DATE — the accounting period and effective date of the entry.
- POST_TO_GL_FLAG and GL_TRANSFER_FLAG — control whether and how the entry is transferred to General Ledger.
- GL_TRANSFER_RUN_ID and GL_TRANSFER_ERROR_CODE — identify the GL transfer run and any transfer failure.
- ACCOUNTING_ERROR_CODE — captures accounting generation errors.
- GL_REVERSAL_FLAG — indicates reversal entries.
- CROSS_CURRENCY_FLAG — flags cross-currency accounting.
- SEQUENCE_ID and SEQUENCE_VALUE — ordering attributes for entry generation.
- ORG_ID — the operating unit, supporting multi-org security.
- OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF framework.
- PROGRAM_ID, REQUEST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit and concurrent request columns.
Common Use Cases and Queries
Typical reporting scenarios include reconciling OKL accounting entries to GL, investigating transfer failures, and auditing period activity. A common join links headers to their lines and events:
- Reconciliation by period: select headers where PERIOD_NAME equals the target period and POST_TO_GL_FLAG is set, joining to OKL_AE_LINES_ALL on AE_HEADER_ID to sum debits and credits.
- Error investigation: query rows where ACCOUNTING_ERROR_CODE or GL_TRANSFER_ERROR_CODE is not null, joined to OKL_ACC_EVENTS_ALL via ACCOUNTING_EVENT_ID to trace the source event.
- GL transfer tracking: filter by GL_TRANSFER_RUN_ID to review all entries produced by a specific transfer run.
- Multi-org compliance: restrict by ORG_ID to satisfy operating unit data security.
Because the header-to-line relationship is one-to-many, aggregate queries should group by AE_HEADER_ID or SET_OF_BOOKS_ID and PERIOD_NAME to avoid line-level duplication.
Related Objects
- OKL_ACC_EVENTS_ALL — parent object referenced via ACCOUNTING_EVENT_ID.
- OKL_AE_LINES_ALL — child table holding entry lines, referenced through AE_HEADER_ID.
- OKL_AE_HEADERS_ALL_PK and OKL_AE_HEADERS_ALL_U1 — primary key and unique index enforcing AE_HEADER_ID integrity.
- GL_JE_HEADERS / GL_JE_LINES — General Ledger targets receiving transferred entries.
- GL_SETS_OF_BOOKS — ledger definition referenced through SET_OF_BOOKS_ID.
- FND_CONCURRENT_REQUESTS — concurrent program context referenced through REQUEST_ID.
-
Accounting entry headers
-
Accounting entry headers
-
View: OKL_AEL_GL_AST_V 12.1.1
This view contains all the asset related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under 'Asset Disposition' journal cate
APPS.OKL_AEL_GL_AST_V·↳ FA_ADDITIONS_B·↳ FA_BOOKS·↳ GL_DAILY_CONVERSION_TYPES·Explore OKL module →
-
SYNONYM: APPS.OKL_AE_HEADERS 12.1.1
-
SYNONYM: APPS.OKL_AE_HEADERS 12.2.2
-
View: OKL_AEL_GL_CTR_V 12.2.2
This view contains all the contract related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Booking, Rebook, Renewal, Rel
APPS.OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore OKL module →
-
View: OKL_AEL_GL_QTE_V 12.1.1
APPS.OKL_AEL_GL_QTE_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
View: OKL_AEL_GL_QTE_V 12.2.2
APPS.OKL_AEL_GL_QTE_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
View: OKL_AEL_GL_TRX_V 12.1.1
This view contains the transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Loss Provision, Accrual, Miscellaneous and Adjust
APPS.OKL_AEL_GL_TRX_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
View: OKL_AEL_GL_CTR_V 12.1.1
This view contains all the contract related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Booking, Rebook, Renewal, Rel
APPS.OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore OKL module →
-
View: OKL_AEL_GL_TRX_V 12.2.2
This view contains the transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Loss Provision, Accrual, Miscellaneous and Adjust
APPS.OKL_AEL_GL_TRX_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
VIEW: APPS.OKL_AEL_GL_TRX_V 12.2.2
-
VIEW: APPS.OKL_AEL_GL_CTR_V 12.1.1
-
View: OKL_AEL_GL_AST_V 12.2.2
This view contains all the asset related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under 'Asset Disposition' journal cate
APPS.OKL_AEL_GL_AST_V·↳ FA_ADDITIONS_B·↳ FA_BOOKS·↳ GL_DAILY_CONVERSION_TYPES·Explore OKL module →
-
VIEW: APPS.OKL_AEL_GL_QTE_V 12.2.2
-
VIEW: APPS.OKL_AEL_GL_TRX_V 12.1.1
-
VIEW: APPS.OKL_AEL_GL_CTR_V 12.2.2
-
VIEW: APPS.OKL_AEL_GL_AST_V 12.1.1
-
VIEW: APPS.OKL_AEL_GL_QTE_V 12.1.1
-
VIEW: APPS.OKL_AEL_GL_AST_V 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.OKL_AEL_GL_TRX_V 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.OKL_AEL_GL_TRX_V 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
VIEW: APPS.OKL_AEL_GL_CTR_V 12.2.2
-
Accounting Entry lines
-
VIEW: APPS.OKL_AEL_GL_CTR_V 12.1.1
-
VIEW: APPS.OKL_AEL_GL_AST_V 12.2.2
-
VIEW: APPS.OKL_AEL_GL_QTE_V 12.1.1
-
VIEW: APPS.OKL_AEL_GL_QTE_V 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
VIEW: APPS.OKL_AEL_GL_AST_V 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Accounting Entry lines
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
12.2.2 DBA Data 12.2.2
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards