Search Results inv_abc_assignments_pvt




Overview
Explore in AI Chat

Overview

INV_ABC_ASSIGNMENTS_PVT is a private PL/SQL package in the APPS schema that encapsulates the core logic for managing ABC assignment data in Oracle Inventory. ABC assignments support ABC analysis, a classification technique that ranks inventory items by their relative value or consumption so that planners can apply differentiated controls — tighter cycle counting, closer monitoring, and more frequent review — to the items that matter most to the business. Within the Oracle EBS architecture, this package is the private implementation layer behind the public API INV_ABC_ASSIGNMENTS_PUB. It is classified as a PVT (private) API, meaning it is intended to be called by other Oracle EBS code rather than invoked directly by customers or custom integrators.

The package exists to isolate the procedural logic for compiling and persisting ABC assignments: determining which items belong to which ABC class, inserting new assignment rows, and updating existing ones when compilation reclassifies an item. Because the package carries a PVT classification, it follows the standard Oracle API layering convention in which the public package performs validation, defaults handling, and caller-facing error messaging, then delegates the actual data manipulation to the private package.

Key Procedures and Functions

ETRM documents three procedures or functions in this package. The documented entry points are:

  • CREATE_ABC_ASSIGNMENTS — The primary compilation entry point. It drives the creation of ABC assignment data for a given assignment group, orchestrating the comparison of existing assignments against newly compiled classes.
  • INSERT_ABC_ASSIGNMENTS — Handles the insertion of new ABC assignment records into the assignment tables, typically for items that received a class assignment for the first time or when new assignment group data is introduced.
  • UPDATE_ABC_ASSIGNMENTS — Handles updates to existing assignment records, such as when an item's compiled ABC class changes between compilation runs or when assignment attributes are adjusted.

The metadata does not expose parameter lists for these procedures; consistent with private API conventions, exact signatures should be validated against the deployed package specification in the environment.

Tables Accessed

The package operates against three Inventory base tables, accessed through APPS synonyms:

  • MTL_ABC_ASSIGNMENT_GROUPS — Defines the ABC assignment groups that scope a compilation run. The package reads group definitions to determine which assignments to process.
  • MTL_ABC_ASSGN_GROUP_CLASSES — Stores class-level definitions associated with an ABC assignment group, providing the classification framework the procedures use when evaluating items.
  • MTL_ABC_ASSIGNMENTS — The principal transaction table, holding the item-to-ABC-class assignment records. INSERT_ABC_ASSIGNMENTS writes new rows here and UPDATE_ABC_ASSIGNMENTS modifies existing rows.

Usage Notes

Because INV_ABC_ASSIGNMENTS_PVT is a private package, it is normally invoked indirectly. The standard path is through the public API INV_ABC_ASSIGNMENTS_PUB, which ETRM documents as the sole referencing package. The Oracle Inventory ABC compile functionality — whether driven from an Oracle Forms interface or from the concurrent program used to compile ABC assignments — ultimately calls into this layer to persist results.

For custom development, direct calls to INV_ABC_ASSIGNMENTS_PVT are not recommended. Oracle deliberately separates public and private APIs so that validation, error handling, and concurrent processing semantics are respected; bypassing the public API risks unvalidated data and unsupported behavior. Integration and extension code should call INV_ABC_ASSIGNMENTS_PUB, letting it manage the transaction and delegate to this package. When troubleshooting ABC compile issues, the procedures here are relevant because they contain the actual insert and update logic affecting MTL_ABC_ASSIGNMENTS.