Search Results inv_attribute_control_pvt




Overview
Explore in AI Chat

Overview

INV_ATTRIBUTE_CONTROL_PVT is a private PL/SQL package in the APPS schema that centralizes the item-attribute validation logic used throughout Oracle Inventory and its dependent modules. Its stated responsibility is to evaluate whether an item, at a given organization and for a given set of transactional circumstances, is permitted to be reserved, transacted, shipped, or processed. Rather than embedding these rules in a form or a public API, Oracle isolated them in a private (PVT-classified) package so that numerous callers — public inventory APIs, the transaction processors, order management, and shipping — can all enforce identical attribute control behavior.

The package belongs to the same internal family as INV_ATTRIBUTE_CONTROL and INVENTORY_ATTRIBUTE_CONTROL style helpers, and the ETRM record shows it is VALID in the APPS schema. The object is documented as being referenced by three other packages, which confirms its role as a shared implementation layer rather than a top-level entry point invoked directly by end users.

Key Procedures and Functions

Ten procedures and functions are documented, organized around paired "check" and "uncheck" operations:

  • GET_ATTRIBUTE_CONTROL — the single accessor that reads the relevant attribute-control settings (for example, whether attribute control is enabled at the inventory parameter level) and returns them to the caller. It is the entry point used by the other procedures.
  • CHECK_PENDING_ADJUSTMENTS — verifies whether there are pending physical adjustment entries affecting the item before allowing a controlled operation.
  • CHECK_PENDING_INTERFACE — verifies whether open rows exist in the transactions interface for the item, so that a transaction is not issued while an unresolved interface record is outstanding.
  • RESERVABLE_CHECK / RESERVABLE_UNCHECK — evaluates whether the item may be reserved, and reverses or clears that evaluation when a reservation is released.
  • TRANSACTABLE_CHECK / TRANSACTABLE_UNCHECK — evaluates whether the item is transactable in the current context, and reverses the assessment.
  • SERIAL_CHECK — validates serial-number attribute conditions for the item before a serialized operation proceeds.
  • SHIPPABLE_CHECK — evaluates shipping-related attribute controls so that order and delivery processing does not release an item that is not permitted to ship.
  • ATO_UNCHECK — reverses attribute checks for Assemble-to-Order related processing.

The check/uncheck pairing reflects a symmetric design: callers invoke the check before acting and the corresponding uncheck when the action is cancelled or completed, keeping attribute state consistent with the underlying transaction.

Tables Accessed

The package reads and writes the following objects through APPS synonyms, each serving a specific control decision:

Usage Notes

INV_ATTRIBUTE_CONTROL_PVT is a private package and is not intended to be called directly from custom code. It is invoked internally by the public inventory APIs, by the transaction manager, and by order management and shipping logic that must honor item attribute control. Because the check procedures depend on MTL_PARAMETERS settings, behavior varies by organization.

For customers extending Oracle EBS, the package is most useful as a reference for the exact attribute conditions Oracle enforces; custom logic that must mirror standard behavior should query the same MTL_ITEM_ATTRIBUTES and MTL_PARAMETERS columns rather than calling this private package, since Oracle may change private code without notice. When attribute control is disabled at the inventory parameter level, the checks generally pass through without blocking the transaction.