Search Results flm_receipt_pub




Overview
Explore in AI Chat

Overview

FLM_RECEIPT_PUB is a public PL/SQL API within the Oracle E-Business Suite Flow Manufacturing (FLM) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its principal business function is to record the receipt of goods against kanban cards used in a pull-based (kanban) replenishment environment. In Flow Manufacturing, kanban cards represent replenishment signals for material at a specific point of use. When material physically arrives, the receipt of that material must be recorded so that inventory balances, purchase order quantities, and the kanban replenishment cycle are all updated consistently. FLM_RECEIPT_PUB kanban_receive encapsulates this transaction logic, providing a single entry point through which callers can drive a kanban receipt without directly manipulating the underlying purchasing, receiving, and inventory tables. The package carries the version header FLMKRCVS.pls 120.0, dated 2011/02/09, which is consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes a single documented public procedure:

  • kanban_receive — Records a kanban receipt for a specified kanban card. The procedure accepts a kanban card identifier and a receipt quantity, with an optional process flag governing execution behavior. On completion it returns an out parameter containing the generated receipt number, together with standard return status and error message out parameters for exception handling. The procedure returns no value and is invoked as a standalone transactional call. Callers must inspect the return status and error message outputs to determine whether the receipt succeeded.

No additional public procedures or functions are documented in the package specification, indicating that kanban_receive is the sole supported entry point of this API.

Tables Accessed

FLM_RECEIPT_PUB reads and writes across the purchasing, receiving, inventory, and kanban data model through APPS synonyms. Key tables include:

Usage Notes

FLM_RECEIPT_PUB is a public API intended for invocation by Oracle EBS application code, including Flow Manufacturing forms, concurrent programs, and custom extensions that need to record kanban receipts programmatically. Because the procedure posts through the standard receiving interface infrastructure, callers should ensure the receiving parameters and interface groups are correctly configured before invocation. The return status and error message out parameters should always be checked; a successful call yields a receipt number that can be used for subsequent inquiry or reconciliation. The package is referenced by one other package in the EBS codebase, confirming its role as a shared service rather than a standalone utility. Customizations should call kanban_receive rather than writing directly to the underlying receiving or kanban tables, in order to preserve data integrity and compatibility across 12.1.1 and 12.2.2 releases.