Results for “mrp_sourcing_api_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MRP_SOURCING_API_PK is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that exposes the sourcing engine used by Oracle's planning and procurement applications. Its primary business function is to determine, for a given item and organization, the appropriate source of supply — whether that source is an approved supplier, an internal transfer from another inventory organization, or a manufacturing work order. In doing so, it applies the sourcing rules and bills of distribution defined by the planner, honoring effectivity dates, assignment sets, and priority ranking. The package therefore acts as a shared service invoked by upstream engines rather than as a user-facing component. Its status is VALID in both 12.1.1 and 12.2.2, and its ETRM classification is OTHER, reflecting that it is an internal API rather than a published open interface.

Key Procedures and Functions

• MRP_SOURCING — The core routine of the package. It evaluates sourcing rules and bills of distribution for a supplied item and organization combination and returns the resulting source of supply, supplier, or manufacturing reference. It is the entry point used by planning and procurement callers to obtain the sourcing decision.
• MRP_SOURCING_RULE_EXISTS — A validation function that confirms whether an applicable sourcing rule has been defined for the item, organization, or assignment set under evaluation. Callers use it to avoid invoking the full sourcing path where no rule exists.
• MRP_GET_SOURCING_HISTORY — Retrieves previously recorded sourcing decisions from the sourcing history table, allowing callers to compare the current determination against historical allocations or to audit prior results.
• MRP_PO_HISTORICAL_ALLOC — Returns historical purchase order allocation information associated with an item or supplier, supporting the sourcing decision with actual purchasing history.

The ETRM metadata documents five procedures and functions in total; the four listed above are the named entries. No parameter lists are published in the ETRM extract and none should be assumed.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. Sourcing history is persisted in and read from MRP_SOURCING_HISTORY. Item and organization context is drawn from MTL_SYSTEM_ITEMS, MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, and MTL_ITEM_SUB_INVENTORIES. Transactional and historical supply evidence comes from MTL_MATERIAL_TRANSACTIONS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS. Purchase order history is read from PO_HEADERS_ALL and PO_LINES_ALL. Manufacturing sources are evaluated through WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_FLOW_SCHEDULES, and WIP_REPETITIVE_ITEMS. Financial and ledger context is supplied by FINANCIALS_SYSTEM_PARAMETERS. Profile options are read via FND_PROFILE.

Usage Notes

MRP_SOURCING_API_PK is an internal dependency of several higher-level modules rather than a directly launched program. The ETRM dependency report shows it is referenced by CTO_AUTO_PROCURE_PK, INV_MINMAX_PVT, PO_AUTOSOURCE_SV, and by itself, and it also references FND_PROFILE. These callers cover configure-to-order auto-procurement, min-max replenishment, and purchasing automatic sourcing. It is therefore invoked during planning runs, replenishment processing, and auto-sourcing of purchase requisitions and orders, and any custom code that must reproduce standard sourcing behaviour should call MRP_SOURCING rather than re-implementing the logic. Because the API is not documented as a public open interface, direct invocation from custom code should be undertaken cautiously and validated against the supported callers listed above.