Search Results req_enc_ael_gl_v




Overview
Explore in AI Chat

Overview

REQ_ENC_AEL_GL_V is an Oracle E-Business Suite dictionary view owned by the APPS schema and classified under the Purchasing (PO) product family. It is a Subledger Accounting (SLA) related view, part of the "Encumbrance AEL GL" (Accounting Event Line – General Ledger) family of views used by the Subledger Accounting and Encumbrance Accounting reporting infrastructure. The view presents requisition encumbrance accounting distributions joined with their corresponding General Ledger journal entries, providing a unified, query-ready representation of requisition encumbrances and the GL impact they generate.

Its primary purpose is to support drill-down and reconciliation reporting that links requisition document information (header segment, org, item, quantity, price) with the accounting entries recorded in GL (entered and accounted debits/credits, currency conversion details, and journal identifiers). The view is validated and available in both 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The view is defined over eleven base objects, all referenced either directly or through synonyms owned by APPS. The core Purchasing tables are PO_REQUISITION_HEADERS_ALL (joined as PRH), PO_REQUISITION_LINES_ALL (PRL), and PO_REQ_DISTRIBUTIONS_ALL (PRD) — these supply requisition, line, and distribution-level attributes. PO_LOOKUP_CODES (PL1) supplies the requisition type display value via LOOKUP_TYPE = 'REQUISITION TYPE' and the SYSDATE of the document context.

The accounting side is sourced from GL_JE_HEADERS (JEH) and GL_JE_LINES (JEL). The join to GL is driven by reference columns on the GL line: JEL.REFERENCE_2 = PRL.REQUISITION_HEADER_ID, JEL.REFERENCE_3 = PRD.DISTRIBUTION_ID, and JEL.REFERENCE_4 = PRH.SEGMENT1. Currency conversion information is joined from GL_DAILY_CONVERSION_TYPES (GLCT, outer-joined on CONVERSION_TYPE) and from conversion fields on JEH. ORG_ORGANIZATION_DEFINITIONS (OOD) supplies the organization code and set of books, joining OOD.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID and OOD.SET_OF_BOOKS_ID = PRD.SET_OF_BOOKS_ID.

The documented metadata also references FND_GLOBAL, HR_GENERAL, and HR_SECURITY packages, which provide multi-org and security context applied at runtime by the view definition, consistent with the standard EBS org-security pattern.

Key Columns

Common Use Cases and Queries

Typical uses include encumbrance-to-GL reconciliation, drill-down from requisition accounting to the GL journal, conversion-rate verification, and org-level spend analysis. A representative query is:

SELECT ORG_ID, SEGMENT1, LINE_NUM, ITEM_DESCRIPTION, CURRENCY_CODE, ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR, JE_HEADER_ID, JE_LINE_NUM FROM APPS.REQ_ENC_AEL_GL_V WHERE JE_HEADER_ID = :p_je_header_id AND ORG_ID = :p_org_id;

Because the view exposes both the requisition document identifiers and the GL journal identifiers, it is frequently joined to GL_JE_HEADERS, GL_CODE_COMBINATIONS, and PO_REQUISITION_HEADERS_ALL to produce detailed drill-downs or to validate that encumbrance entries posted to GL reference the correct requisition. Use it in custom reports and PL/SQL where requisition encumbrance and GL journal data must be correlated in a single result set, subject to standard EBS org-security and MOAC constraints.