Search Results icx_item




Overview
Explore in AI Chat

Overview

ICX_ITEM is a utility PL/SQL package in the APPS schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its classification in the E-Business Suite Technical Reference Manual (ETRM) is "OTHER," indicating that it is not part of a formal public API family and is instead intended for internal or diagnostic use. The package is defined with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, which is consistent with an internal helper routine rather than a secured, externally exposed API. The single documented procedure, XLS, accepts a WHERE clause and appears designed to produce spreadsheet-oriented (Excel/XLS) output from query results, using Oracle's Web Toolkit (OWA) utilities to render that output. The package carries a header marker dated 1999, reflecting an early-generation component that has persisted largely unchanged through successive EBS releases.

Key Procedures and Functions

  • XLS — The only documented procedure in the package. Its purpose is to generate spreadsheet-format output, driven by an input WHERE clause that supplies the filtering condition for the underlying data selection. No parameter list beyond the WHERE clause is documented in the ETRM metadata; the internal logic for row retrieval, column formatting, and MIME/HTTP rendering is not exposed. The procedure is not a public integration API and should not be treated as a supported interface for external systems.

Tables Accessed

The ETRM metadata lists three objects as referenced via APPS synonyms rather than base application tables:

  • HTP — the Oracle Web Toolkit PL/SQL package used to emit HTML/HTTP content, which in this context supports the packaging and delivery of the XLS result set.
  • OWA_UTIL — the Oracle Web Agent utility package, commonly used to manage HTTP output, headers, and page-level rendering; likely invoked to control content type and output stream for the spreadsheet download.
  • PLITBLM — a PL/SQL table manipulation/utility object, typically employed for in-memory collections and row buffering during result assembly.

No base application tables are documented as directly referenced. The actual data query is presumably constructed dynamically from the WHERE clause passed into XLS, which is why the metadata does not record a fixed table list.

Usage Notes

ICX_ITEM is not referenced by any other package, per the documented dependency count of zero. This strongly suggests it is invoked directly rather than through call chains — most plausibly from diagnostic or reporting code, a form-level trigger, or a small custom concurrent program used to export query results in spreadsheet form. Because the package is flagged as AUTHID CURRENT_USER and classified OTHER, it is not a supported, documented public API. Developers should avoid building dependent custom interfaces on ICX_ITEM and should treat it as an internal EBS utility. Where spreadsheet export is required in a supported manner, Oracle's documented XML Publisher or FND_FILE-based concurrent output should be preferred. Given that the header dates to 1999, the package is legacy in origin, and any use in 12.1.1 or 12.2.2 should be validated for compatibility with current OWA/HTP rendering and file-download behavior.