Search Results pos_exasn_lots

Overview

POS_EXCELASN_GRP is an Advanced Supply Chain Planning and Purchasing (POS) group package in the APPS schema that supports the Excel-based Advanced Shipment Notice (ASN) upload feature in Oracle E-Business Suite. Its central role is to validate and persist ASN records that external suppliers or internal users submit through a spreadsheet-driven interface rather than through the standard Receiving Open Interface. The package operates as the orchestration layer between incoming staging data and the receiving interface tables, coordinating header, line, lot, LPN, and serial level detail before the ASN is handed off to Oracle Receiving for processing.

Consistent with the ETRM classification as a GRP package, POS_EXCELASN_GRP is designed to be invoked as a top-level entry point rather than as a subordinate utility. It calls the FND_API error and message stack, FND_GLOBAL session context, and the POS_EXCELASN_PVT package for the underlying validation logic. The "pos_exasn_lots" search term maps directly to the POS_EXASN_LOTS staging table consumed by this package.

Key Procedures and Functions

• VALIDATEANDSAVE_RECORDS — This is the sole documented procedure in the package and functions as the primary entry point. It validates an incoming collection of Excel-uploaded ASN records, applies business rules across headers, lines, lots, LPNs, and serials, and then saves the validated set to the persistent ASN tables. It uses the FND_API framework for error accumulation and returns errors into POS_EXCELASN_ERROR_TABLE for display back to the user.

No other public procedures or functions are documented in the ETRM metadata. Validation and persistence logic distributed across the ASN hierarchy is delegated to POS_EXCELASN_PVT and the underlying DML against POS_EXASN_* tables.

Tables Accessed

The package reads and writes a set of staging tables that mirror the ASN hierarchy:

• POS_EXASN_HEADERS — ASN shipment header records.
• POS_EXASN_LINES — ASN line level detail tied to the header.
• POS_EXASN_LOTS — Lot and batch information for items under lot control; this is the object matching the user search term.
• POS_EXASN_LPNS — License Plate Number (LPN) containers associated with the ASN.
• POS_EXASN_SERIALS — Serialized item detail for serial-controlled inventory.
• POS_EXCELASN_HEADER_TABLE, _LINE_TABLE, _LOT_TABLE, _LPN_TABLE, _SERIAL_TABLE, _ERROR_TABLE — PL/SQL collection types (the _TABLE variants) used to hold in-memory record sets and error messages during validation.
• POS_ASN_LOAD — The staging/load table that supplies the raw ASN data for validation.
• RCV_HEADERS_INTERFACE_S, RCV_INTERFACE_GROUPS_S, RCV_TRANSACTIONS_INTERFACE_S — Receiving Open Interface tables into which validated ASNs are ultimately pushed for processing by the Receiving transaction processor.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_DOC_STYLE_HEADERS — Purchasing tables referenced for document and line verification.
• DUAL, PLITBLM — Utility objects for scalar evaluation and PL/SQL index-by table operations.

Usage Notes

POS_EXCELASN_GRP is typically invoked from the Excel ASN upload workflow in Oracle iSupplier Portal or from a concurrent program that processes uploaded spreadsheet content. VALIDATEANDSAVE_RECORDS is called once per uploaded batch, and errors are surfaced back to the submitting user through the Excel ASN error table and the FND_API message stack. Because the package is not referenced by any other database object, it is not intended as an internal building block; customer extensions should treat it as a self-contained processing API. In 12.1.1 and 12.2.2 the interface tables and PL/SQL collection types remain consistent, so custom code invoking VALIDATEANDSAVE_RECORDS should wrap calls in explicit commit or rollback control and be prepared to read POS_EXCELASN_ERROR_TABLE on failure.