Search Results flm_kanban_workbench_util




Overview
Explore in AI Chat

Overview

The APPS.FLM_KANBAN_WORKBENCH_UTIL package body is a utility package within the Oracle E-Business Suite Flow Manufacturing (FLM) module. It supports the Kanban Workbench, the transactional and inquiry interface used by planners and shop-floor personnel to manage kanban cards and their replenishment cycle. Kanban in Flow Manufacturing governs pull-based replenishment: cards signal demand, trigger replenishment of specific quantities, and drive material movement across the supply chain. The workbench provides the operational surface for these activities, and this utility package consolidates the underlying PL/SQL logic that the workbench relies upon.

The package resides in the APPS schema and is classified as a utility (UTIL) API, meaning it is intended for internal consumption by the Flow Manufacturing application rather than as a public, general-purpose interface. It is validated and active in both Oracle EBS 12.1.1 and 12.2.2. Because it is a package body, the corresponding specification FLM_KANBAN_WORKBENCH_UTIL defines the callable surface; the body contains the implementation.

Key Procedures and Functions

The documented callable interface of this package contains a single procedure or function:

  • GET_CATEGORY_ID — Returns the category identifier associated with the kanban workbench context. This routine resolves an item or kanban record to its corresponding category, which is used by the workbench to group, filter, or default kanban data during inquiry and maintenance operations.

No additional parameters or overloads are documented in the ETRM metadata for this object, and none should be assumed. The single documented entry confirms that the package's responsibility is narrow and focused: supplying category resolution logic to the workbench rather than performing transactional kanban processing itself.

Tables Accessed

The package references one documented table through APPS synonyms:

  • MRP_LOW_LEVEL_CODES — The low-level code table used by Oracle Planning and Manufacturing applications. It stores the low-level code assignment for each item, which reflects the deepest position an item occupies in the product structure across all bills of material. Reading this table allows the package to derive or validate structural item relationships needed when determining category context for kanban records.

No insert, update, or delete operations on this table are documented; the reference appears to be read-oriented. No other application tables are listed among the documented dependencies for this package body.

Usage Notes

This package is an internal utility of the Flow Manufacturing Kanban Workbench. It is typically invoked indirectly—by the Kanban Workbench form or by other FLM packages that need to resolve a category identifier—rather than being called directly from custom code. The ETRM metadata records that it is referenced by three other database objects, confirming its role as a shared helper for dependent FLM components.

Because the package body is not referenced by any external database object beyond those dependent packages, direct invocation from customer extensions is discouraged. Customizations that require category resolution for kanban data should use supported public APIs where available, or call GET_CATEGORY_ID only after validating its signature against the package specification in the target instance, since undocumented parameters may exist in releases beyond the documented metadata.

Deployment considerations: the package depends on the STANDARD package supplied by the SYS schema for standard PL/SQL constructs. Any compilation or invalidation event affecting STANDARD or MRP_LOW_LEVEL_CODES will mark this package invalid until it is recompiled. Standard Oracle EBS patching and online compilation processes handle this automatically in supported releases.