Search Results pos_excelasn_header_table




Overview
Explore in AI Chat

Overview

POS_EXCELASN_GRP is a group-type PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Advance Shipment Notice (ASN) inbound process driven by Microsoft Excel spreadsheets. It is part of the Purchasing / iProcurement / Receiving family of "POS" packages and is closely associated with the Oracle iSupplier Portal and the Supplier Network capabilities that allow suppliers to communicate shipment details to a buying organization electronically.

The package name indicates its purpose: it processes Excel-based ASN data (the "EXCELASN" segment) and passes validated records into the standard Oracle Receiving Open Interface (ROI) tables. It declares AUTHID CURRENT_USER so that any executing user operates with their own privileges rather than the definer's privileges. The header comment dates the file to 2003, placing it within the EBS 11i/12.x lineage and confirming its use in R12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The documented metadata lists a single procedure: VALIDATEANDSAVE_RECORDS. As the name implies, this procedure performs two functions. First it validates the incoming Excel-derived ASN data — headers, lines, lots, serials, and LPNs — against the corresponding staging tables. Second it saves (commits) the validated records into the appropriate interface and base tables, returning a group identifier, a return status, a return code, and a return message. Errors encountered during validation are collected into an error table structure passed as an OUT parameter so the caller can report them back to the supplier or user.

The procedure exposes a wide API signature: it accepts a header table, a line table, an in-out lot table, an in-out serial table, an in-out LPN (license plate number) table, and returns group/status/error information. The in-out nature of the lot, serial, and LPN tables suggests that the procedure may populate or augment these structures during processing, for example by generating LPN identifiers or by defaulting lot and serial attributes.

Tables Accessed

The package references a mix of staging, interface, and base tables. Staging and staging-style tables include POS_ASN_LOAD, POS_EXASN_HEADERS, POS_EXASN_LINES, POS_EXASN_LOTS, POS_EXASN_LPNS, and POS_EXASN_SERIALS — these hold the raw Excel data parsed into relational form before validation. PO_DOC_STYLE_HEADERS, PO_HEADERS_ALL, and PO_LINES_ALL are Purchasing base tables used to resolve document styles and to look up purchase order header and line information that the ASN must reference. The Receiving Open Interface tables RCV_HEADERS_INTERFACE_S, RCV_INTERFACE_GROUPS_S, and RCV_TRANSACTIONS_INTERFACE_S are the destination structures into which validated ASNs are typically written so that the standard Receiving Open Interface concurrent program can process them. DUAL is referenced for trivial lookups and the PLITBLM is a PL/SQL internal helper table.

Usage Notes

This package is intended to be invoked by a concurrent program or a custom PL/SQL driver that parses an Excel ASN file and populates the POS_EXASN_* staging tables, then calls ValidateAndSave_Records to validate and forward the data into the Receiving Open Interface. It is not typically called directly from a form, though a custom form or iSupplier Portal flow could invoke it. The procedure returns a group ID that corresponds to the interface group in RCV_INTERFACE_GROUPS_S, allowing the caller to submit ROI processing for that specific group. Errors returned in the error table must be surfaced to the user or supplier so the Excel file can be corrected and resubmitted. Because the package was last modified in 2003 and references APPS synonyms for all tables, it relies on the standard EBS synonym conventions and should be watermarked unsupported for direct modification; customizations should instead wrap or supplement the documented API.