Search Results inv_invirdis_xmlp_pkg




Overview
Explore in AI Chat

Overview

INV_INVIRDIS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. The naming convention identifies it as the generated support package for an Oracle Reports (XML Publisher) report — specifically the Inventory Item Category Listing / item-category descriptive report executed within the Oracle Inventory module. The XMLP suffix confirms that the report uses the BI Publisher (XML Publisher) engine, and the _PKG suffix confirms that the package encapsulates the report's PL/SQL constructs: the before-report and after-report triggers, the parameter/formula columns, and the dynamic WHERE clause builders that assemble the report's query at runtime.

Rather than exposing a business API, this package exists to support the concurrent-program execution of the report. Its primary role is to construct the SQL statement and parameter bindings that filter inventory item data by category set, category, status, effective dates, and organization, then return the resulting data set to the XML Publisher template. In Oracle EBS 12.1.1 and 12.2.2, packages of this type are automatically generated when a report is registered and are maintained through the EBS internal report definition. Users typically encounter it only indirectly, when the concurrent program runs or when reporting errors surface in the log.

Key Procedures and Functions

The documented package exposes eleven procedures and functions. Their names reflect the standard Oracle Reports PL/SQL structure:

  • BEFOREREPORT — the before-report trigger, used to initialize package state, parameters, and any session-level setup prior to query execution.
  • AFTERREPORT — the after-report trigger, used to perform cleanup or post-processing once the report has completed.
  • AFTERPFORM — the after-parameter-form trigger, invoked after the report's parameter form has been submitted, typically to derive or validate parameter values before the main query.
  • WHERE_STAT_EFF and WHERE_STATUS — dynamic WHERE clause builders that append status and effective-date predicates to the report's query based on user-selected parameters.
  • C_CAT_FROMFORMULA, C_CAT_WHEREFORMULA, and C_CAT_PADFORMULA — formula columns returning the category "from," the category WHERE fragment, and the padded category value used in the selection criteria.
  • C_CAT_SET_NAMEFORMULA and C_ITEM_PADFORMULA — formula columns for the category set name and the padded item value.
  • C_MORG_IDFORMULA — formula column supplying the inventory organization identifier to the report.

These names follow the report builder convention where C_ prefixes formula columns and WHERE_ prefixes dynamic predicates.

Tables Accessed

The package references three APPS-synonym tables:

  • MTL_CATEGORY_SETS — supplies the category set definitions used to validate and resolve the category set name parameter.
  • MTL_ITEM_ATTRIBUTES — the primary source of item attribute values used in the report's item listing and filtering.
  • MTL_PARAMETERS — provides organization-level Inventory parameters, including organization defaults used to drive the report's organization context.

All access is read-only; the package does not write to transactional or setup tables.

Usage Notes

INV_INVIRDIS_XMLP_PKG is invoked automatically when its associated concurrent program is submitted from the Oracle Inventory responsibility. It is not called directly by forms or by customer-written code. Because it is generated and regenerated by the EBS report-definition process, modifications should never be applied directly to the package; changes must be made through the report definition or a supported patch. In 12.2.2, the package remains schema-resident in APPS and is referenced only by itself, as confirmed by the dependency record. Troubleshooting typically centers on concurrent program log output, where errors from BEFOREREPORT or the WHERE builders indicate invalid parameter combinations, missing category set definitions, or organization context problems.