Search Results item_flex




Overview
Explore in AI Chat

Overview

APPS.ONT_OEXOHOHS_XMLP_PKG is the packaged PL/SQL body behind the Oracle Order Management seeded report commonly titled "Order Holds Report" (report short name OEXOHOHS). It belongs to the XML Publisher (BI Publisher) report family, in which a database package acts as the report's data source and constructs the XML document consumed by the report template. The package resolves order hold information from OE_ORDER_HOLDS and enriches each held line with inventory and customer item description data.

A central responsibility of the package is resolving and displaying the inventory item flexfield (the "Item" key flexfield in the INV application). The user search term item_flex maps directly to the generated-flexfield call inside the ITEM_DSPFORMULA function, which invokes FND_FLEX_XML_PUBLISHER_APIS.PROCESS_KFF_COMBINATION_1 against the INV key flexfield structure to produce a concatenated, formatted flexfield value. When a customer item identifier is requested instead, the package joins MTL_CUSTOMER_ITEMS and MTL_CUSTOMER_ITEM_XREFS to return the customer item number and description.

The package is self-contained: it is referenced by no other packages, and its entry points are designed to be called by the concurrent-program execution engine and by the XML Publisher data template.

Key Procedures and Functions

The documented package exposes fourteen procedures and functions:

  • BEFOREREPORT / AFTERREPORT — Standard XML Publisher report lifecycle hooks. BEFOREREPORT initializes package-level state and report parameters before data extraction; AFTERREPORT performs post-processing and cleanup after the XML document is generated.
  • AFTERPFORM — Post-parameter-form trigger used to establish parameter context (such as the master organization) once the user has entered report parameters.
  • ITEM_DSPFORMULA — The core item display routine. It determines whether to display the inventory item flexfield, a system item description, or a customer item number, based on the item identifier type and the parameter controlling flex/description display. It calls the FND flexfield XML Publisher API to build the formatted flexfield value.
  • ITEM_DISPLAY_MEANINGFORMULA — Derives the display meaning (the label presented alongside the item value), reflecting whether the output represents an internal item, a description, or a customer item.
  • C_MASTER_ORGFORMULA — Returns the master organization used to constrain item lookups, ensuring only master-level item definitions are retrieved.
  • C_CUSTOMER_WHERE — Supplies the dynamic WHERE clause fragment that filters the report to a selected customer.
  • C_HOLD_WHERE — Supplies the dynamic WHERE clause fragment that filters held orders and lines by hold criteria.
  • C_LINE_OR_ORDERFORMULA — Determines whether the report output is scoped at the order header level or the order line level.
  • C_SHOW_AMOUNTFORMULA / C_AMOUNTFORMULA — Control whether monetary amounts are displayed and compute the formatted amount value shown on the report.
  • C_FORMATTED_FLEX_VALUE_P / RP_ITEM_FLEX_ALL_SEG_P — Auxiliary flexfield-related routines that format the item flexfield value and expose all flexfield segments for display purposes.
  • SOB_NAMEFORMULA — Returns the name of the set of books (ledger) associated with the reporting context.

Tables Accessed

The package reads from the following APPS synonyms:

  • OE_ORDER_HOLDS — Primary source of order hold records, providing the held orders and lines around which the report is built.
  • MTL_SYSTEM_ITEMS_VL (through Item lookups) and MTL_CUSTOMER_ITEMS, MTL_CUSTOMER_ITEM_XREFS — Joined to resolve item descriptions and customer item numbers for each held line. MTL_CUSTOMER_ITEM_XREFS links a customer item to its internal inventory item.
  • MTL_CROSS_REFERENCES and MTL_CROSS_REFERENCE_TYPES — Used to resolve cross-reference item numbers (for example, customer part numbers or substitute identifiers) associated with inventory items.
  • DUAL — Used for single-row computations and parameter defaults.

Usage Notes

ONT_OEXOHOHS_XMLP_PKG is invoked indirectly. It is registered as the data source for the Order Holds XML Publisher concurrent program, and Oracle EBS calls BEFOREREPORT when the program is run from the Submit Requests form or the Concurrent Programs interface. Report parameters entered on the concurrent program parameter form drive the C_* filter functions, and the remaining formula functions are evaluated row by row while the XML data structure is populated.

Because the package is not referenced by other PL/SQL units, customizations are normally confined to the report template (RTF or eText) or to the packaged functions themselves when a client requires additional item identification logic. When item flexfield values appear incorrectly, the ITEM_DSPFORMULA function and the p_item_flex_code and p_item_structure_num parameters are the correct diagnostic starting point, since these values drive the FND flexfield API call. In EBS 12.1.1 and 12.2.2 the package source is held under the OEXOHOHSB.pls file and is shipped as a "noship" object, indicating it is not a standalone customer-deployable entity but a component of the seeded report.