Search Results pos_excelasn_error_table

Overview

POS_EXCELASN_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Purchasing module's Excel-based Advance Shipment Notice (ASN) integration. Its principal business function is to transform ASN data submitted through spreadsheet templates into Oracle purchasing and receiving transactions, validating headers, lines, and license plate/serial (LLS) information before committing records. In EBS 12.1.1 and 12.2.2, this package acts as the underlying engine invoked by the public wrapper POS_EXCELASN_GRP, which is the only documented object that references it. Because it is classified as a PVT (private) API, it is not intended for direct customer invocation; Oracle exposes it internally to the Excel ASN concurrent flow. The package is listed with VALID status and carries no public interface contract, meaning any custom coding against it risks breakage on patching or upgrade. Its responsibility set spans header creation, line creation, LLS (lot, serial, and license plate) record creation, quantity conversion, supplier pay site resolution, and error logging into a dedicated error table.

Key Procedures and Functions

The package exposes 17 documented subprograms, grouped by purpose:

• PROCESSEXCELASN — the main driver that orchestrates the end-to-end processing of uploaded Excel ASN data.
• CREATENEWHEADER / CREATENEWLINE — create ASN header and line records during processing.
• CREATERTI4LOT, CREATERTI4LPN, CREATERTI4SER — create receiving transaction interface (RTI) rows for lot-controlled, LPN (license plate) controlled, and serial-controlled items respectively.
• VALIDATEHEADERS, VALIDATELINES, VALIDATELLS — validation routines for headers, lines, and LLS data prior to insertion.
• FIXHEADERSANDLINES, UPDATELINESANDLLS — correction and update routines that reconcile or amend header, line, and LLS data during processing.
• INSERTINTOLLS — inserts license plate, lot, and serial records into the appropriate receiving structures.
• GETCONVERTEDQUANTITY — converts quantities between units of measure.
• CHECKLLSCONTROL — determines the LLS control attributes governing an item.
• GETVENDORPAYSITEID — resolves the supplier pay site identifier for a vendor.
• INSERTERROR / GET_STATUS — record error conditions in the error table and return processing status.

Tables Accessed

The package reads and writes the following documented tables (via APPS synonyms):

• POS_EXCELASN_ERROR_TABLE — stores validation and processing errors surfaced during Excel ASN loads.
• PO_VENDOR_SITES_ALL — provides supplier site information used to resolve pay sites and validate header data.
• MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE_TL — supply item attributes and UOM definitions for quantity conversion and LLS control determination.
• AP_SUPPLIERS, HZ_LOCATIONS, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HR_LOCATIONS_ALL_TL — resolve supplier, party site, and location details for header creation.
• IBY_EXTERNAL_PAYEES_ALL, IBY_EXT_BANK_ACCOUNTS, IBY_EXT_PARTY_PMT_MTHDS, IBY_PMT_INSTR_USES_ALL — payment-related supplier data for pay site resolution.
• AK_RESP_SECURITY_ATTRIBUTES, AK_RESP_SECURITY_ATTR_VALUES, AK_WEB_USER_SEC_ATTR_VALUES — support responsibility-based security attribute checks during validation.
• ORG_FREIGHT — used in freight and shipping context resolution.

Usage Notes

POS_EXCELASN_PVT is invoked indirectly through the public package POS_EXCELASN_GRP as part of the Excel ASN upload and validation cycle in the Purchasing module. It is not exposed to end users, Forms, or concurrent program parameters directly; Oracle calls it from the wrapper when processing uploaded spreadsheet ASN files. Administrators troubleshooting Excel ASN failures should examine the POS_EXCELASN_ERROR_TABLE, which the package populates via INSERTERROR. Because the package has a PVT classification, custom code should never call it directly — any enhancement should target the supported POS_EXCELASN_GRP interface or the documented Excel ASN flow instead.