Search Results cost_group_summaries

Overview

INVTVTUS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API taxonomy as OTHER rather than as a public or open interface API. Its name and declaration — PACKAGE INVTVTUS AUTHID CURRENT_USER — indicate that it is an internal, invoker-rights utility package belonging to the Oracle Inventory (INV) module. The package has been present in the EBS codebase since at least the 11.5.x release series, as evidenced by the header revision string that references a 2002 ship date, and it remains documented in the 12.2.2 ETRM repository unchanged in purpose.

The business function performed by INVTVTUS is the generation of summarized inventory transaction activity. It aggregates material transaction data — quantities, values, and related attributes — into a temporary summary structure, filtered by item, subinventory, location, cost group, and date range. These summaries underpin Inventory period-close reporting, transaction register reporting, and materialized views used by Oracle Inventory and Oracle Cost Management reports. The package is designed to be invoked by other internal Inventory programs rather than by end users directly.

Key Procedures and Functions

ETRM documents four procedures in the package. Their described purposes are as follows:

• ITEM_ONLY_SUMMARIES — Produces summary transaction activity scoped to a specific inventory item. It accepts a session identifier, an organization identifier and organization location type, the inventory item identifier, revision, primary and purchasing unit of measure, a start and end date, and a cost group identifier. It is the item-centric entry point for summary generation.
• SUB_ONLY_SUMMARIES — Produces summary transaction activity scoped to a subinventory. It accepts a session identifier, organization identifier, subinventory name, inventory location identifier, category set and category identifiers, a date range, and a cost group identifier.
• BOTH_SUMMARIES — Produces combined summaries covering both item and subinventory dimensions in a single invocation. Its parameter list is the union of the item-oriented and subinventory-oriented parameters, again including a session identifier, date range, and cost group identifier.
• SUB_COST_GROUP_SUMMARIES — Produces summary activity scoped to a subinventory and cost group combination, allowing cost-group-level aggregation across the transaction date range.

The common parameter pattern — session identifier, organization, date range, and cost group — confirms that the procedures populate a session-scoped temporary table, which is subsequently read by the calling report or concurrent program. A commented-out COST_GROUP_SUMMARIES declaration also appears in the source, indicating earlier design iterations.

Tables Accessed

The package reads from and writes to the following tables via APPS synonyms:

• MTL_MATERIAL_TRANSACTIONS — the primary source of transaction activity being summarized; the date range parameters filter this table.
• MTL_SUMMARY_TEMP — the session-scoped target table into which summary rows are written and from which callers read results.
• MTL_SYSTEM_ITEMS and MTL_ITEM_REVISIONS — item and revision validation and attribute lookup.
• MTL_SECONDARY_INVENTORIES, MTL_ITEM_LOCATIONS, and MTL_PARAMETERS — subinventory, locator, organization, and cost group context.
• MTL_CATEGORY_SETS, MTL_CATEGORIES, and MTL_ITEM_CATEGORIES — category-based filtering and classification.
• MTL_TRANSACTION_TYPES and MTL_TXN_SOURCE_TYPES — transaction classification and type description lookup.
• FND_CURRENCIES — currency conversion context for monetary summarization.

Usage Notes

INVTVTUS is an internal utility package. ETRM records zero other packages referencing it, so it is not a shared dependency in the public API sense; nevertheless, it is invoked by Oracle Inventory concurrent programs and forms that produce summarized transaction activity, including transaction register and period-close report generation. Because the procedures take an explicit session identifier, they are classically called from a concurrent program that first creates a session context, invokes the appropriate summary procedure, and then reads MTL_SUMMARY_TEMP to format output.

Custom code should avoid calling INVTVTUS directly. Oracle does not document it as a supported integration point, and its signature may change between patch levels. The absence of any documented functions, and the presence of a commented-out procedure in the source, further indicate that the package is maintained solely for Oracle's internal reporting requirements in 12.1.1 and 12.2.2. The search term "ULTRAVIWER FOR SMART TV" has no relation to this package; it appears to be an unrelated query, and no functionality within INVTVTUS pertains to television, ultravioliet, or viewer applications.