Search Results reference_6

Overview

AX_SLE_LINES_V is a database view within the Oracle E-Business Suite Global Accounting Engine (AX) module. It exposes the entry line detail associated with Subledger Accounting (SLA) event processing, presenting journal entry lines in a denormalized form suitable for reporting and reconciliation. The view is defined primarily over the AX_SLE_LINES table (aliased L) and joins to additional header and supplier-related objects to enrich each line with application context, third-party, and site-level attributes.

In the context of Oracle EBS 12.1.1 and 12.2.2, this view serves as a read-only reference for the Global Accounting Engine's accounting line data. Because it consolidates posting status, accounted and entered amounts, account code combinations, and a large set of reference flexfields, it is well suited to audit, reconciliation, and downstream integration reporting where detailed journal line context is required. As documented in the ETRM metadata, the view is described simply as "Entry lines," and it is not implemented as a physical object in the source database — it is a view definition only.

Underlying Base Objects

The view text demonstrates that AX_SLE_LINES_V is defined over the following objects and aliases:

• AX_SLE_LINES (L) — the principal source, contributing all line-level columns including journal sequence, accounting amounts, references, posting flags, and currency information.
• AX_SLE_HEADERS (H) — joined to supply header context, notably the APPLICATION_ID that identifies the originating application.
• Supplier/Vendor tables (V and VS) — used to resolve THIRD_PARTY_NAME from VENDOR_NAME and SUB_NAME from VENDOR_SITE_CODE.

Per the ETRM metadata, no referenced base objects are individually documented for this view, and the view is listed as "Not implemented in this database." The relationships above are inferred directly from the SELECT statement rather than from separately documented foreign keys.

Key Columns

• JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, SLE_LINE_NUM — identify the line and its position within the accounting entry.
• ACCOUNTED_DR / ACCOUNTED_CR, ENTERED_DR / ENTERED_CR — accounted and entered debit/credit amounts.
• CODE_COMBINATION_ID — the accounting flexfield combination assigned to the line.
• GL_POSTED_FLAG, GL_POSTED_DATE — indicate whether and when the line was transferred to the General Ledger.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency and conversion attributes for foreign-currency entries.
• THIRD_PARTY_ID, THIRD_PARTY_NAME, SUB_ID, SUB_NAME — supplier and supplier site identification.
• REFERENCE_1 … REFERENCE_60, REFERENCE_NUM1 … REFERENCE_NUM9 — the extended reference flexfield set carrying source document context.
• ORG_ID — the operating unit, enabling multi-org secured reporting.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID) — standard EBS concurrency and audit tracking.

Common Use Cases and Queries

Typical scenarios include reconciling subledger entries to GL, auditing unposted lines, and exporting line-level detail with supplier context.

• Review lines awaiting GL transfer:
  SELECT SLE_HEADER_ID, SLE_LINE_NUM, ACCOUNTED_DR, ACCOUNTED_CR FROM AX_SLE_LINES_V WHERE GL_POSTED_FLAG = 'N';
• Reconcile by account and operating unit:
  SELECT CODE_COMBINATION_ID, SUM(ACCOUNTED_DR), SUM(ACCOUNTED_CR) FROM AX_SLE_LINES_V WHERE ORG_ID = :org GROUP BY CODE_COMBINATION_ID;
• Extract supplier-context detail:
  SELECT THIRD_PARTY_NAME, SUB_NAME, CURRENCY_CODE, ENTERED_DR FROM AX_SLE_LINES_V WHERE THIRD_PARTY_ID IS NOT NULL;

Consumers should treat the view as read-only and apply ORG_ID filtering to respect multi-org security.