Search Results subcontract_orders_manager

Overview

JMF_SUBCONTRACT_ORDERS_PVT is a private (PVT) PL/SQL package in the APPS schema that supports the Oracle Process Manufacturing (OPM) subcontracting and tolling functionality, specifically within the context of the Shikyu (contract manufacturing) modules. In Oracle EBS 12.1.1 and 12.2.2 environments, this package provides the core business logic for creating, validating, and processing subcontract orders exchanged between a brand owner and a contract manufacturer. It serves as the programmatic engine behind the subcontract order workflow, translating user or interface-driven requests into records within the subcontract order tables, while reconciling item, routing, unit of measure, interorg, and sourcing data required for a valid transaction.

The package is classified as a private API (PVT), indicating that it is intended for internal use by other Oracle Process Manufacturing components rather than direct invocation by external custom code. It is referenced by the concurrent program JMF_INTERLOCK_SHIKYU_CP, which places it firmly within the Shikyu interlock processing framework. Its status is VALID, confirming its availability in the documented instance.

Key Procedures and Functions

The ETRM documentation records two documented entry points within this package:

• SUBCONTRACT_ORDERS_MANAGER — The top-level manager procedure that coordinates the processing of subcontract orders. It typically performs setup, validation, and orchestration, delegating detailed row-level work to the worker routine.
• SUBCONTRACT_ORDERS_WORKER — The worker procedure that executes the detailed processing logic for individual subcontract order records, including validation and persistence against the supporting OPM and Oracle supply chain tables.

No parameter lists are documented in the ETRM metadata; only the procedure names and their general-purpose role are recorded.

Tables Accessed

The package references the following tables via APPS synonyms:

• JMF_SUBCONTRACT_ORDERS and JMF_SUBCONTRACT_ORDERS_TEMP — the primary subcontract order tables where processed output is written and staged.
• JMF_SHIKYU_ALLOCATIONS, JMF_SHIKYU_BATCH_S, JMF_SHIKYU_COMPONENTS, JMF_SHIKYU_REPLENISHMENTS — supporting Shikyu contract manufacturing data that drives order composition and allocation.
• MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B — item validation and master item attributes.
• MTL_UNITS_OF_MEASURE — unit of measure conversion and validation.
• MTL_PARAMETERS and HR_ORGANIZATION_INFORMATION — organization and inventory parameter defaults.
• MTL_INTERORG_PARAMETERS — interorganization shipping and transfer rules.
• BOM_OPERATIONAL_ROUTINGS — routing information used to validate subcontract operations.
• OE_ORDER_LINES_ALL — order line reference for demand and sourcing linkage.
• PO_ASL_ATTRIBUTES — approved supplier list attributes used for sourcing validation.

Usage Notes

JMF_SUBCONTRACT_ORDERS_PVT is an internal processing package and is not intended for direct invocation by custom code. It is normally triggered indirectly through the Shikyu concurrent program suite, notably JMF_INTERLOCK_SHIKYU_CP, which drives subcontract order processing as part of the interlock cycle in OPM. Because it is classified as a private API, its signatures are not guaranteed across patches or releases, and customizations should not call it directly. Organizations requiring subcontract order integration should extend the supported public APIs or the associated concurrent programs rather than depending on this private layer.