Search Results derive_packet_values

Overview

APPS.PO_ENCUMBRANCE_PREPROCESSING is a PL/SQL package in the Oracle E-Business Suite Purchasing (PO) module that supports the encumbrance accounting process. Encumbrance accounting provides budgetary control by reserving, or "encumbering," funds at the time a purchase requisition, purchase order, or release is created, and subsequently relieving or liquidating those encumbrances when the corresponding actual accounting entries are generated. Because the encumbrance subledger for Purchasing involves large volumes of distributions and complex derivation logic, Oracle separates the preparatory work into this package. Its core responsibility is to assemble, validate, and stage the data required by the downstream posting engine, primarily PO_DOCUMENT_FUNDS_PVT, before journal entries are written to the General Ledger interface.

Key Procedures and Functions

The package exposes nine documented program units:

• GET_ALL_DISTRIBUTIONS — collects purchase order and release distributions relevant to the encumbrance run for further processing.
• DO_ENCUMBRANCE_VALIDATIONS — performs the eligibility and consistency checks that determine whether encumbrance entries may be generated for the selected documents.
• DERIVE_PACKET_VALUES — derives the aggregate or header-level values used to build the encumbrance "packet" processed downstream.
• DERIVE_DIST_FROM_DOC_TYPES — determines distribution-level encumbrance behavior from the applicable document types.
• DERIVE_DOC_TYPES_FROM_DIST — the inverse operation, inferring document type context from the distributions.
• CHECK_ENC_ACTION_POSSIBLE — evaluates whether a given encumbrance action is permitted, typically based on document type and period status.
• DELETE_ENCUMBRANCE_GT — clears the PO_ENCUMBRANCE_GT staging table of prior data.
• UPDATE_CLM_INTIAL_AMOUNTS — writes the initial encumbrance amounts used for commitment (CLM) accounting.
• UPDATE_CLM_FINAL_AMOUNTS — writes the final encumbrance amounts after processing.

Tables Accessed

The package reads core Purchasing entities and stages results in the encumbrance global temporary table. It queries PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS and PO_DISTRIBUTIONS_ALL, PO_RELEASES_ALL, PO_REQUISITION_LINES_ALL, PO_DOCUMENT_TYPES and PO_DOCUMENT_TYPES_ALL, and PO_LINE_TYPES_B to resolve document and distribution context. It uses FND_CURRENCIES for currency validation, GL_PERIOD_STATUSES to confirm the accounting period is open for encumbrance, and FND_NEW_MESSAGES plus PO_ONLINE_REPORT_TEXT for message and report output. PO_ENCUMBRANCE_GT (and its sequence PO_ENCUMBRANCE_GT_S) is the primary staging table written and cleared during the run.

Usage Notes

PO_ENCUMBRANCE_PREPROCESSING is not intended for direct end-user invocation. It is referenced by the two packages PO_DOCUMENT_FUNDS_PVT and PO_CLM_COLS_SUB_CHECK, which orchestrate the funds-check and encumbrance posting flow, and is also self-referenced. It is typically exercised indirectly through Purchasing's period-close and encumbrance-creation concurrent programs and through forms that trigger funds reservation. Custom code should not modify or bypass this package; extensions should instead invoke the supported funds-check APIs in PO_DOCUMENT_FUNDS_PVT. The package is present and VALID in both 12.1.1 and 12.2.2 schemas.