Results for “ax_ap_ae_lines_all_v”

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

Overview

AX_AP_AE_LINES_ALL_V is a compatibility view in the Oracle E-Business Suite Global Accounting Engine (AX) module. Its documented purpose, per the ETRM metadata, is to serve as a replacement for the Payables table AP_AE_LINES_ALL when the AX accounting engine is used instead of the standard Subledger Accounting (SLA) engine. In 12.1.1 and 12.2.2 environments, the AX Global Accounting Engine was retained for certain country localizations and legacy configurations, where transactions must be transformed into the AX accounting model. This view abstracts that transformation, allowing external reports, integrations, and downstream processes that were written against AP_AE_LINES_ALL to continue functioning without modification of their SQL, mapping the underlying AX subledger lines (AXSL) into the AP_AE_LINES_ALL column shape.

Because the view presents accounting event lines in the familiar Payables accounting-entry structure, it is consumed by reporting tools, custom extensions, and reconciliation processes that expect the AP_AE_LINES_ALL interface rather than the internal AX schema.

Underlying Base Objects

The ETRM metadata lists no documented referenced base objects for this view. However, the view text reveals that it is defined over AX subledger line data and associated AX event data. The primary aliases are AXSL (the AX subledger lines source) and AXE (the AX event source), joined to supply journal and header information. Key source attributes include JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, SLE_LINE_NUM, CODE_COMBINATION_ID, CURRENCY_CODE, and the entered/accounted debit and credit amounts. Event-level attributes such as DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE, and EVENT_TYPE are drawn from AXE.

Note the metadata states the view is "Not implemented in this database," meaning in the queried environment the object was not instantiated — behavior that occurs when the AX accounting engine is not active, so the view may exist only conditionally. Where the view is deployed, its definition is inert until the AX engine populates the underlying AX subledger tables.

Key Columns

• AE_LINE_ID — Hard-coded to -1 in the view text, indicating the AX model does not expose a native AP line identifier at this layer.
• AE_HEADER_ID — Mapped from SLE_HEADER_ID; identifies the accounting header.
• AE_LINE_NUMBER / JOURNAL_SEQUENCE_ID — Line ordering and journal sequence from the AX subledger line.
• CODE_COMBINATION_ID — The accounting flexfield combination for the distribution line.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — Currency and conversion attributes for the entry.
• ENTERED_DR / ENTERED_CR / ACCOUNTED_DR / ACCOUNTED_CR — Entered and accounted debit/credit amounts, central to any ledger reporting.
• VENDOR_ID / VENDOR_SITE_ID — Sourced from THIRD_PARTY_ID and SUB_ID, identifying the supplier and site.
• DESCRIPTION / USSGL_TRANSACTION_CODE — Derived via AX_PAYABLES_PKG functions using EVENT_TYPE and reference values.
• SOURCE_TABLE / SOURCE_ID / GL_SL_LINK_ID — Traceability back to the originating transaction and GL link.
• ORG_ID, CREATION_DATE, audit columns, PROGRAM_* and REQUEST_ID — Multi-org security and concurrent program audit context.

Common Use Cases and Queries

Typical uses include reconciling AX-generated accounting entries against Payables invoices, extracting distribution lines for GL transfer validation, and feeding custom accounting reports that were originally built on AP_AE_LINES_ALL.

SELECT ae_header_id, ae_line_number, code_combination_id,
       entered_dr, entered_cr, accounted_dr, accounted_cr,
       currency_code, vendor_id, org_id
FROM   ax_ap_ae_lines_all_v
WHERE  org_id = :p_org_id
  AND  creation_date >= :p_start_date;

Because the object is engine-dependent and may be unimplemented, production queries should first confirm the AX engine is active. Where it is not, standard AP_AE_LINES_ALL or the SLA tables (XLA_AE_LINES) should be queried instead. When available, this view remains the most direct path for preserving legacy AP accounting-line reporting under the Global Accounting Engine.