Search Results calibrate_last_dist_quantity

Overview

PO_AUTO_DIST_PROCESS_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that supports Oracle Purchasing's automatic distribution processing logic. Its role is to derive, default, create, and calibrate distribution records associated with purchase order headers, lines, and shipments during document creation and maintenance. It is a supporting utility package invoked internally by higher-level Purchasing APIs rather than a public integration interface.

The package is documented as VALID in ETRM for 12.1.1 and 12.2.2. It references APPS.PO_AUTOCREATE_TYPES and SYS.STANDARD, and is referenced by APPS.PO_AUTOCREATE_MAINPROC_PVT, APPS.PO_LINK_REQ_DIST_PVT, and itself. These references confirm its position in the Automatic Document Creation (Autocreate) flow and in the requisition-to-PO distribution linkage path.

Key Procedures and Functions

• DERIVE_AND_DEFAULT_DISTS — Derives and defaults distribution records for a purchasing document, applying the applicable sourcing and accounting rules to populate PO_DISTRIBUTIONS_ALL.
• CREATE_PAYITEM_DISTS — Creates distribution rows associated with pay items, linking purchasing documents to the corresponding accounting distributions.
• DEFAULT_ACRN_VALUES — Populates ACRN (Accounting Classification Reference Number) values on distributions, supporting U.S. federal ACRN reporting requirements.
• UPDATE_AWARD_DISTRIBUTIONS — Updates award-related distributions, maintaining consistency between award references and purchasing distribution records.
• CALIBRATE_LAST_DIST_AMOUNT — Reconciles the amount on the final distribution line so the distribution total equals the document, line, or shipment amount.
• CALIBRATE_LAST_DIST_QUANTITY — Reconciles the quantity on the final distribution line so the distribution total matches the ordered or received quantity.

No parameter signatures are published in the ETRM metadata; callers should treat these as internal routines.

Tables Accessed

The package operates primarily against purchasing distribution and document tables. PO_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_DRAFT_ALL, PO_DISTRIBUTIONS_S, and PO_DISTRIBUTIONS_INTERFACE cover the base, draft, sequence, and interface representations of distributions. PO_HEADERS_ALL, PO_HEADERS_DRAFT_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_LINE_LOCATIONS, and PO_LINE_LOCATIONS_DRAFT_ALL supply the document hierarchy against which distributions are derived. The corresponding interface tables PO_LINES_INTERFACE and PO_LINE_LOCATIONS_INTERFACE support inbound processing. Supporting reference tables include FINANCIALS_SYSTEM_PARAMS_ALL (system-level defaults such as ACRN and accounting options), FND_APPLICATION, and MTL_UOM_CONVERSIONS (unit-of-measure conversion for quantity calibration).

Usage Notes

PO_AUTO_DIST_PROCESS_PVT is a private package and is not intended for direct invocation by customers or third-party code. It is called from within Purchasing's Autocreate and requisition-to-PO linkage code, notably PO_AUTOCREATE_MAINPROC_PVT and PO_LINK_REQ_DIST_PVT. In 12.1.1 and 12.2.2 the internal logic and callers are essentially consistent; the principal difference between releases lies in the surrounding table and view definitions rather than this package's interface. Because its procedures lack published signatures, custom code should call documented public APIs such as PO_DISTRIBUTIONS_PUB or the appropriate Autocreate APIs instead of invoking this package directly. When troubleshooting distribution errors—particularly imbalance errors or ACRN defaults—the routines above are the relevant internal entry points to trace.