Search Results po_distributions_interface_s




Overview
Explore in AI Chat

Overview

APPS.JMF_SHIKYU_PO_PVT is a private PL/SQL package body in Oracle E-Business Suite (12.1.1 and 12.2.2) that supports the Shop Floor Manufacturing (JMF) Shikyu replenishment process. "Shikyu" refers to the pull-based, replenishment-driven material supply model used in discrete manufacturing environments, where component demand at the shop floor triggers the creation of purchase orders for externally sourced items. This package encapsulates the business logic required to build and submit replenishment purchase orders through the Oracle Purchasing open interface, rather than inserting directly into the purchasing base tables.

The package is classified as a Private (PVT) API, meaning it is intended for internal use by other JMF Shikyu packages and concurrent programs rather than as a public integration surface. It has no direct database dependents, but it is referenced by another package and depends heavily on the standard Oracle APIs, including FND_API, FND_MSG_PUB, PO_PDOI_UTL, and MO_GLOBAL.

Key Procedures and Functions

The documented package exposes a single public program unit:

  • PROCESS_REPLENISHMENT_PO — The main driver procedure that assembles replenishment purchase order data and passes it to the Purchasing open interface. It orchestrates the workflow end to end: identifying the Shikyu component demand, resolving supplier and item attributes, populating the PO interface tables, invoking the Purchasing document import, and handling errors through the FND message stack. It relies on FND_API for the standard API return status and FND_MSG_PUB for message propagation, consistent with the EBS API programming standards.

Tables Accessed

The package reads and writes a focused set of base and interface tables:

Usage Notes

JMF_SHIKYU_PO_PVT is a private package, so it is not addressed directly by end-user forms. It is typically invoked by the parent Shikyu processing package and by the concurrent program responsible for Shikyu replenishment order generation. Because it uses the Purchasing open interface rather than direct inserts, the standard Purchasing Document Import (PO_PDOI / PO_DISTRIBUTIONS_INTERFACE validation) must run after PROCESS_REPLENISHMENT_PO completes, so interface rows are validated and converted into live purchase orders. The correct execution sequence for a "Shikyu PO" run is: (1) call PROCESS_REPLENISHMENT_PO, (2) invoke the Purchasing open interface import program. Developers extending the Shikyu solution should treat this package as private and follow the ETRM documented dependency graph, using FND_LOG and FND_MSG_PUB behavior for diagnostics.