Results for “subledger_doc_sequence_value”

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

Overview

OZF_AE_LINES_ALL is a Trade Management (OZF) subledger table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the individual accounting lines belonging to an accounting event header. It functions as the line-level detail table for the Trade Management accounting engine, capturing the debit, credit, and tax distribution entries that are ultimately transferred to the General Ledger. Every row represents one accounting distribution and is anchored to a parent header record through the AE_HEADER_ID foreign key to OZF_AE_HEADERS_ALL.

The table is owned by the OZF schema and is documented as VALID in the ETRM 12.2.2 physical schema, which describes 74 columns. The primary key is defined by the OZF_AE_LINES_ALL_PK constraint on the AE_LINE_ID column. A unique index, OZF_AE_LINES_ALL_U1, also exists on AE_LINE_ID, making AE_LINE_ID the only documented business-key candidate. Based on the foreign key structure, the heuristic Data Vault classification for this table is satellite-leaning, since it carries descriptive and transactional measures attached to a parent header entity.

Key Information Stored

The most significant columns fall into identity, reference, amount, tax, and audit groups:

• AE_LINE_ID — Surrogate primary key and unique-index column; the single-row identifier used in joins, APIs, and corrective SQL.
• AE_HEADER_ID — Foreign key to OZF_AE_HEADERS_ALL; ties each line to its accounting header.
• AE_LINE_NUMBER and AE_LINE_TYPE_CODE — Line sequencing and classification for the distribution entry.
• ACCOUNTED_DR / ACCOUNTED_CR — Accounted debit and credit amounts in the ledger functional currency.
• ENTERED_DR / ENTERED_CR — Entered debit and credit amounts in the transaction currency.
• CODE_COMBINATION_ID — The Accounting Flexfield combination used to post the line.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, and CURRENCY_CONVERSION_TYPE — Currency and conversion attributes supporting foreign-currency accounting.
• TAXABLE_ACCOUNTED_DR, TAXABLE_ACCOUNTED_CR, TAXABLE_ENTERED_DR, TAXABLE_ENTERED_CR, TAX_CODE_ID, and TAX_LINK_ID — Taxable amounts and tax configuration references.
• GL_SL_LINK_ID and GL_TRANSFER_ERROR_CODE — Subledger-to-GL linkage and transfer status indicators.
• SOURCE_ID / SOURCE_TABLE and APPLIED_FROM_TRX_HDR_ID / APPLIED_TO_TRX_HDR_ID — Origin and applied-transaction tracking.
• ORG_ID and SECURITY_GROUP_ID — Multi-org and security-group partitioning columns.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, CREATION_DATE, and REQUEST_ID — Concurrency control and audit trail fields consistent with OZF table conventions.

Common Use Cases and Queries

Typical scenarios include reconciling Trade Management accounting entries before or after transfer to GL, tracing the origin of accrual or settlement distributions, and diagnosing GL_TRANSFER_ERROR_CODE exceptions. Because AE_LINE_ID is indexed and unique, it is the preferred predicate for direct row retrieval and for joining to line-level extension objects. A join to the header is the most frequent pattern:

• Retrieve all lines for a single accounting event: SELECT * FROM OZF.OZF_AE_LINES_ALL WHERE AE_HEADER_ID = :p_header_id ORDER BY AE_LINE_NUMBER;
• Fetch a single distribution by primary key: SELECT * FROM OZF.OZF_AE_LINES_ALL WHERE AE_LINE_ID = :p_ae_line_id;
• Reconcile debit/credit balances per header: SELECT AE_HEADER_ID, SUM(ACCOUNTED_DR), SUM(ACCOUNTED_CR) FROM OZF.OZF_AE_LINES_ALL GROUP BY AE_HEADER_ID;
• Identify failed GL transfers: SELECT AE_LINE_ID, AE_HEADER_ID, GL_TRANSFER_ERROR_CODE FROM OZF.OZF_AE_LINES_ALL WHERE GL_TRANSFER_ERROR_CODE IS NOT NULL;

Related Objects

The following objects are most directly involved with OZF_AE_LINES_ALL:

• OZF_AE_HEADERS_ALL — Parent header table; joined on OZF_AE_LINES_ALL.AE_HEADER_ID = OZF_AE_HEADERS_ALL.AE_HEADER_ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for security-group assignment.
• OZF_AE_LINES_ALL_PK — Primary key constraint on AE_LINE_ID.
• OZF_AE_LINES_ALL_U1 — Unique index on AE_LINE_ID.
• GL_JE_LINES / GL_IMPORT_REFERENCES — General Ledger posting targets linked through GL_SL_LINK_ID.
• Subledger Accounting (XLA) interfaces — Consume OZF distribution lines during transfer to GL, keyed by the link identifier.